Re: Clarification on using pg_upgrade - Mailing list pgsql-performance

From Tory M Blue
Subject Re: Clarification on using pg_upgrade
Date
Msg-id CAEaSS0bi0oAk2u615P-WmtLj3XfvAeBBLgO05nxyK5tD7Pui5Q@mail.gmail.com
Whole thread Raw
In response to Re: Clarification on using pg_upgrade  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: Clarification on using pg_upgrade  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List 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


pgsql-performance by date:

Previous
From: Moreno Andreo
Date:
Subject: Re: [SPAM] Re: Architectural question
Next
From: Wei Shan
Date:
Subject: Query not using Index