Re: pg_dump additional options for performance

Поиск
Список
Период
Сортировка
От Decibel!
Тема Re: pg_dump additional options for performance
Дата
Msg-id 20080208170934.GW1212@decibel.org
обсуждение исходный текст
Ответ на Re: pg_dump additional options for performance  ("Zeugswetter Andreas ADI SD" <Andreas.Zeugswetter@s-itsolutions.at>)
Ответы Re: pg_dump additional options for performance
Список pgsql-hackers
On Wed, Feb 06, 2008 at 05:10:00PM +0100, Zeugswetter Andreas ADI SD wrote:
> Simon wrote:
> > My proposal is to provide two additional modes:
> > --schema-pre-load corresponding to (1) above
> > --schema-post-load corresponding to (3) above
>
> Sounds nice.
> For a large schema we might rather want one switch that dumps 2 files,
> no ?
> Probably also better from a mvcc perspective.

+1

For that matter, it'd be better if you could just get all 3 files (pre,
data, post) in one shot with one transaction; that would guarantee you a
clean dump.
--
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Hiroshi Saito"
Дата:
Сообщение: Re: The question of LOCALE at the time of a regression test.
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: The question of LOCALE at the time of a regression test.