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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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.



In response to

Browse pgsql-hackers by date

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