Re: pg_dump additional options for performance - Mailing list pgsql-hackers

From Decibel!
Subject Re: pg_dump additional options for performance
Date
Msg-id 20080208170934.GW1212@decibel.org
Whole thread Raw
In response to Re: pg_dump additional options for performance  ("Zeugswetter Andreas ADI SD" <Andreas.Zeugswetter@s-itsolutions.at>)
Responses Re: pg_dump additional options for performance  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
On Wed, Feb 06, 2008 at 05:10:00PM +0100, Zeugswetter Andreas ADI SD wrote:
> Simon wrote:
> > My proposal is to provide two additional modes:
> > --schema-pre-load corresponding to (1) above
> > --schema-post-load corresponding to (3) above
>
> Sounds nice.
> For a large schema we might rather want one switch that dumps 2 files,
> no ?
> Probably also better from a mvcc perspective.

+1

For that matter, it'd be better if you could just get all 3 files (pre,
data, post) in one shot with one transaction; that would guarantee you a
clean dump.
--
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

pgsql-hackers by date:

Previous
From: "Hiroshi Saito"
Date:
Subject: Re: The question of LOCALE at the time of a regression test.
Next
From: Andrew Dunstan
Date:
Subject: Re: The question of LOCALE at the time of a regression test.