enter image description here

Postgres uses a mechanism called MVCC(Multi Version Concurrency Control) to track changes in your database. Due to this reason, some of the rows become “dead”. Dead rows are generated by DELETE and UPDATE operations, as well as transactions that have to be rolled back. Refer this link learn more about MVCC.

These dead rows keep on adding as there are lots of updates and deletes. Periodic clean up of these dead rows is necessary to not only save space but also maintain the performance of your...

Read complete blog post

Recently we had requirement in Mamasan project to migrate Heroku PostGreSQL database to SoftLayer (dedicated server) psql database

One major issue we faced during migration (import of DB to SoftLayer DB) using "pg_restore" is the version conflict between the dump file that Heroku creates (for pgsql backups) and the old version 8.4. of PostGreSQL that SoftLayer instance has.

We upgraded PostGreSQL to version 9.1 on SoftLayer (remember to upgrade version above Heroku dump file or use same...

Read complete blog post