Re: Pg_upgrade speed for many tables - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Pg_upgrade speed for many tables
Date
Msg-id 20121106015213.GK19099@momjian.us
Whole thread Raw
In response to Re: Pg_upgrade speed for many tables  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Pg_upgrade speed for many tables  (Andrew Dunstan <andrew@dunslane.net>)
List 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@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: RFC: Timing Events
Next
From: Andrew Dunstan
Date:
Subject: Re: Pg_upgrade speed for many tables