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 20160728023010.GB12810@momjian.us
Whole thread Raw
In response to Re: Uber migrated from Postgres to MySQL  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-general
On Thu, Jul 28, 2016 at 02:23:18AM -0000, Greg Sabino Mullane wrote:
>
> Marc wrote:
> > I donât have a 1TB database to try it on, mind you, so your
> > âwait couple of daysâ might be *with* the âlink option?
>
> I think you mean *without*, but yeah, there is no way the --link
> option is going to take that long. Hard links are  awesome. We've upgraded
> some really big databases, and --link is really, really fast.
> If you can't use --link (usually because you want to get over
> the checksum hump), we use something like Bucardo to help out.
> No need to ever wait a "couple of days" as OP claims. :)
>
> What really bites is the analyze afterwards. That's the part
> that takes too long (yes, --in-stages helps some). Would love
> to see progress made there.

Agreed.  I will try to prioritize it.

--
  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: "Greg Sabino Mullane"
Date:
Subject: Re: Uber migrated from Postgres to MySQL
Next
From: Jeff Janes
Date:
Subject: Re: Uber migrated from Postgres to MySQL