Re: Clarification on using pg_upgrade

From: Tory M Blue <tmblue(at)gmail(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Clarification on using pg_upgrade
Date: 2016-03-24 17:43:27
Message-ID: CAEaSS0bi0oAk2u615P-WmtLj3XfvAeBBLgO05nxyK5tD7Pui5Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Wei Shan 2016-03-26 13:14:15 Query not using Index
Previous Message Moreno Andreo 2016-03-24 10:56:52 Re: [SPAM] Re: Architectural question