On Wed, Nov 7, 2012 at 5:59 PM, Bruce Momjian <bruce@xxxxxxxxxx> wrote: >> > Is there any reason to upgrade the slave when you are going to do rsync >> > anyway? Of course you need to install the new binaries and libs, but it >> > seems running pg_upgrade on the standby is unnecessary. >> >> Just to speed up the rsync > > pg_upgrade is mostly modifying the system tables --- not sure if that is > faster than just having rsync copy those. The file modification times > would be different after pg_upgrade, so rsync might copy the file anyway > when you run pg_upgrade. It would be good for you to test if it really > is a win --- I would be surprised if pg_upgrade was in this case on the > standby. I guess it depends on the release (ie: whether a table rewrite is necessary). I'll check next time I upgrade a database, but I don't expect it to be anytime soon. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
