Thanks to all that responded I successfully upgraded 800GB DB with pg_upgrade in about 2 hours. This would have taken 2 days to dump/restore.
Slon is also starting to not be viable as it takes some indexes over 7 hours to complete. So this upgrade path seemed to really be nice. Not sure how I can incorporate with my slon cluster, I guess that will be the next thing I research. Appreciate the responses and assistance. Tory -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
