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

Re: pg_dump additional options for performance

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_dump additional options for performance
Date: 2008-02-06 15:47:58
Message-ID: 47A9D6AE.4090807@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers

Simon Riggs wrote:
> My proposal is to provide two additional modes:
> --schema-pre-load corresponding to (1) above
> --schema-post-load corresponding to (3) above
>
> This would then allow this sequence of commands 
>
> pg_dump --schema-pre-load
> pg_dump --data-only
> pg_dump --schema-post-load
>
> to be logically equivalent, but faster than
>
> pg_dump --schema-only
> pg_dump --data-only
>   

It would actually be better, as well as faster, because it will be 
guaranteed to work :-) There are known cases where schema-only followed 
by data-only fails.


One more note: we need to make sure the corresponding new modes are also 
added to pg_restore.

cheers

andrew

In response to

pgsql-hackers by date

Next:From: Simon RiggsDate: 2008-02-06 15:48:13
Subject: Segment Visibility Map for VACUUM
Previous:From: Magnus HaganderDate: 2008-02-06 15:41:56
Subject: Re: pg_dump additional options for performance

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