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: (view raw, whole thread or download thread mbox)
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

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-2017 The PostgreSQL Global Development Group