On Tue, Oct 23, 2012 at 09:41:20AM -0400, Nikolas Everett wrote: > On Mon, Oct 22, 2012 at 6:17 PM, Alan Hodgson <ahodgson@xxxxxxxxx> wrote: > > On Monday, October 22, 2012 05:55:07 PM Nikolas Everett wrote: > > I see that pg_upgrade is an option. Having never used how long should I > > expect pg_upgrade to take? Obviously we'll measure it in our > environment, > > but it'd be nice to have a ballpark figure. > > pg_upgrade using hard links should only take a minute or 2. You'll also > need > to shuffle around packages and services and config files. The slowest part > for any > decent sized database will be doing an analyze after bringing it up under > 9.2, > though. So however long that takes for your db, plus maybe 10-15 minutes or > so, if you've practiced. > > > Yikes! Analyze will certainly take the longest time - we'll have to build some > kind of strategy for which tables to analyze first and how many to analyze at > once. pg_upgrade 9.2 creates a script that incrementally produces more accurate statistics, which should help. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
