Re: Uber migrated from Postgres to MySQL - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Uber migrated from Postgres to MySQL
Date
Msg-id 20160801185749.GA28258@momjian.us
Whole thread Raw
In response to Re: Uber migrated from Postgres to MySQL  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
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@momjian.us>        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 +


pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Uber migrated from Postgres to MySQL
Next
From: Jeff Janes
Date:
Subject: Re: Force pg_hba.conf user with LDAP