Re: Pg_upgrade speed for many tables

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Pg_upgrade speed for many tables
Date: 2012-11-06 01:52:13
Message-ID: 20121106015213.GK19099@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Nov 5, 2012 at 05:39:40PM -0800, Josh Berkus wrote:
>
> > Sorry, I should've said psql --single-transaction. Although that isn't
> > going to work either given the presence of \connect commands in the
> > script. I wonder whether pg_dumpall ought to have some sort of "one
> > transaction per database please" option.
>
> pg_dumpall ought to support -Fc output ...

That is already a TODO:

Add pg_dumpall custom format dumps?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2012-11-06 02:37:30 Re: Pg_upgrade speed for many tables
Previous Message Josh Berkus 2012-11-06 01:42:21 Re: RFC: Timing Events