Horton
Menu

Re: Further pg_upgrade analysis for many tables

Jeff Janes <jeff.janes@gmail.com>

View thread
From: Jeff Janes <jeff.janes@gmail.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: Peter Eisentraut <peter@eisentraut.org>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Magnus Hagander <magnus@hagander.net>
Date: 2012-11-10T00:06:38Z
Lists: pgsql-hackers 
On Thu, Nov 8, 2012 at 7:25 PM, Bruce Momjian <bruce@momjian.us> wrote:
>
> I did some more research and realized that I was not using --schema-only
> like pg_upgrade uses.  With that setting, things look like this:
>
...

For profiling pg_dump in isolation, you should also specify
--binary-upgrade.  I was surprised that it makes a big difference,
slowing it down by about 2 fold.

Cheers,

Jeff