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

From Jeff Davis
Subject Re: pg_dump additional options for performance
Date
Msg-id 1202760421.21589.23.camel@dogma.ljc.laika.com
Whole thread Raw
In response to Re: pg_dump additional options for performance  ("Zeugswetter Andreas ADI SD" <Andreas.Zeugswetter@s-itsolutions.at>)
List pgsql-hackers
On Wed, 2008-02-06 at 17:10 +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.
> 

Assuming pg_dump/pg_reload supports pre/data/post phases, as Simon
suggests, the multi-file options could also be handled by -Fc and using
pg_restore, correct?

Or would the multi-file options provide any new functionality?

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: Manolo _
Date:
Subject: Re: Avoid scanning on tape
Next
From: Robert Treat
Date:
Subject: Re: Fwd: PostgreSQL 8.4 development plan