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

From Joshua D. Drake
Subject Re: pg_dump additional options for performance
Date
Msg-id 488D3199.2040902@commandprompt.com
Whole thread Raw
In response to Re: pg_dump additional options for performance  (Stephen Frost <sfrost@snowman.net>)
Responses Re: pg_dump additional options for performance  (Stephen Frost <sfrost@snowman.net>)
List pgsql-patches
Stephen Frost wrote:
> * Tom Lane (tgl@sss.pgh.pa.us) wrote:
>> Stephen Frost <sfrost@snowman.net> 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

pgsql-patches by date:

Previous
From: Stephen Frost
Date:
Subject: Re: pg_dump additional options for performance
Next
From: Stephen Frost
Date:
Subject: Re: pg_dump additional options for performance