Re: pg_dump additional options for performance

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: pg_dump additional options for performance
Дата
Msg-id 1202760421.21589.23.camel@dogma.ljc.laika.com
обсуждение исходный текст
Ответ на Re: pg_dump additional options for performance  ("Zeugswetter Andreas ADI SD" <Andreas.Zeugswetter@s-itsolutions.at>)
Список pgsql-hackers
On Wed, 2008-02-06 at 17:10 +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.
> 

Assuming pg_dump/pg_reload supports pre/data/post phases, as Simon
suggests, the multi-file options could also be handled by -Fc and using
pg_restore, correct?

Or would the multi-file options provide any new functionality?

Regards,Jeff Davis



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

Предыдущее
От: Manolo _
Дата:
Сообщение: Re: Avoid scanning on tape
Следующее
От: Robert Treat
Дата:
Сообщение: Re: Fwd: PostgreSQL 8.4 development plan