Re: BUG #7884: pg_upgradecluster is terribly slow

On Fri, Feb 15, 2013 at 03:55:02PM -0800, John R Pierce wrote:
> 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

Actually, hard linked, not moved.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +