Re: pg_dump additional options for performance

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: pg_dump additional options for performance
Дата
Msg-id 488D3199.2040902@commandprompt.com
обсуждение исходный текст
Ответ на Re: pg_dump additional options for performance  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: pg_dump additional options for performance  (Stephen Frost <sfrost@snowman.net>)
Список 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 по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: pg_dump additional options for performance
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: pg_dump additional options for performance