pg_upgrade using hard links should only take a minute or 2. You'll also needOn 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.
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.
Thanks for letting me know.
Nik
