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

From Alvaro Herrera
Subject Re: Uber migrated from Postgres to MySQL
Date
Msg-id 20160727230252.GA374245@alvherre.pgsql
Whole thread Raw
In response to Re: Uber migrated from Postgres to MySQL  (Patrick B <patrickbakerbr@gmail.com>)
Responses Re: Uber migrated from Postgres to MySQL  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
Patrick B wrote:
> >
> > I think it's safe to say that that has absolutely nothing to do
> > with the size being 3TB.  They symptoms you report are a little
> > thin to diagnose the actual cause.
>
> might be... we're using SATA disks... and that's a big problem. But still..
> the size of the DB is indeed a problem.

Andrew is correct -- the size of the database is not a limitation for
pg_upgrade.  Disk tech is not relevant either.  You may run into the
problem that you don't have enough disk space, but then that is not a
database or pg_upgrade problem, is it?

Other things might cause issues, but since you haven't actually reported
the problem, we don't know what is or whether there is any possible fix.

Then again, if you want to report a pg_upgrade failure, I suggest you
open a thread of your own rather than hijack this one.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-general by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Locking issue
Next
From: Bruce Momjian
Date:
Subject: Re: Uber migrated from Postgres to MySQL