Re: BUG #7884: pg_upgradecluster is terribly slow

On 2/15/2013 10:27 AM, Kevin Grittner wrote:
> You might want to try the utility which*is*  supported by the
> PostgreSQL community, which is pg_upgrade.  For speed, consider
> using the -k option.  I've been able to upgrade a 3 TB database in
> just a few minutes with that.  (Timing depends more on the number
> of database objects than their size.)

do note this -k option only functions if the old and new cluster are on
the same mount point, so the files can be mv'd



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast