Hi list, We're working on upgrading from 9.1 to 9.3 some of our database clusters, while seeking to minimize (write) downtime by making the upgrades as fast as possible. However, our clusters have the particularity that they get to host many different *databases*, as in, ~2000 databases per cluster. Most of those databases are small (only a table and PostGIS functions), so it's more a problem of the number of DBs than the space they use. The total size of the cluster is around 60gb. I first started using pg_upgrade but, even when enabling parallelization and hardlinks, as most of the steps (preliminary check?) don't seem to be parallelized, the upgrade takes ~5 hours as it goes database-per-database serially on most steps. I'm experimenting with reducing the time by spawning parallel pg_dump and pg_restore instances, so far I've reached a 3:15h mark that I still think can reduce a bit more with some tweaking. Does anyone have any tips on reducing the time of upgrading such a kind of a cluster? Thanks! -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
