On 04/03/2015 09:34 AM, Steve Crawford wrote:
Check out the pg_reorg extension. This extension does create a new
table on the fly while tracking updates. It then applies any updates
that have occurred while creating the new copy and finally swaps the
new version in place of the old. It creates I/O but doesn't require
the long-duration locks of the other methods.
Actually I should have also said check out pg_repack, the fork of
pg_reorg. In either case also do some reading on potential pitfalls:
http://adpgtech.blogspot.com/2014/10/pgrepack-pitfalls.html
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
