On Mon, Aug 1, 2016 at 11:54:00AM -0700, Jeff Janes wrote: > > Uh, that is only true if the slowness was in _dumping_ many objects. > > Most of the fixes have been for _restoring_ many objects, and that is > > done in the new cluster, so they should be OK. > > There have been improvements on both sides. For the improvements that > need to exist in the old-server to be effective, we did backpatch the > main one back to 9.1, in the October 2015 releases, specifically to > help people get off the old versions. So if you are on 9.1 with > tens/hundreds of thousands of objects, you need to do a minor version > upgrade to at least 9.1.19 before doing the major version upgrade. If > you are on 9.0 or before with so many objects, you don't have a lot of > good options. Yeah, that's what I remember. Thanks for the details. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
