Re: pg_dump additional options for performance

Stephen Frost wrote:
> * Tom Lane (tgl@[EMAIL PROTECTED]
) wrote:
>> Stephen Frost <sfrost@[EMAIL PROTECTED]
> writes:
>>> I dislike, and doubt that I'd use, this approach.  At the end of the
>>> day, it ends up processing the same (very large amount of data)
multiple
>>> times.

> This would depend on the dump being in the custom format, though I
> suppose that ends up being true for any usage of these options.  I've
> never really been a fan of the custom format, in large part because it
> doesn't really buy you all that much and makes changing things more
> difficult (by having to extract out what you want to change, and then
> omit it from the restore).

Custom format rocks for partial set restores from a whole dump. See the 
TOC option :)

Joshua D. Drake

-- 
Sent via pgsql-patches mailing list (pgsql-patches@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches