Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group