Identifying PostgreSQL Bloat and fixing it without downtime
MVCC (Multi-Version Concurrency Control) feature allows databases to provide concurrent access to data. This allows each SQL statement to see a snapshot of data as it was some time ago,…
Speeding up Initial data load for Oracle to PostgreSQL using Goldengate and copy command
Oracle Goldengate supports Oracle to PostgreSQL migrations by supporting PostgreSQL as a target database, though reverse migration i.e PostgreSQL to Oracle is not supported. One of the key aspect of…
Querying RDS PostgreSQL logs using Amazon Athena
PostgreSQL logs contains useful information which can help in troubleshooting performance issues,auditing and performing historical analysis. Some of items which can be logged are listed below Client connection and disconnection…
Migrating Function based indexes from Oracle to PostgreSQL
In this post, I will share issue faced while working with function based index in PostgreSQL . I was performing database migration from Oracle to PostgreSQL and used AWS Schema…