Re: pg_dump additional options for performance

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: pg_dump additional options for performance
Дата
Msg-id 20080721210057.GH18846@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: pg_dump additional options for performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: pg_dump additional options for performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Tom, et al,

* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Ah, I see.  No objection to those switch names, at least assuming we
> want to stick to positive-logic switches.  What did you think of the
> negative-logic suggestion (--omit-xxx)?

My preference is for positive-logic switches in general.  The place
where I would use this patch would lend itself to being more options if
--omit-xxxx were used.  I expect that would hold true for most people.
It would be:

  --omit-data --omit-post-load
  --omit-pre-load --omit-post-load
  --omit-pre-load --omit-data

vs.

  --schema-pre-load
  --data-only
  --schema-post-load

Point being that I'd be dumping these into seperate files where I could
more easily manipulate the pre-load or post-load files.  I'd still want
pre/post load to be seperate though since this would be used in cases
where there's alot of data (hence the reason for the split) and putting
pre and post together and running them before data would slow things
down quite a bit.

Are there use cases for just --omit-post-load or --omit-pre-load?
Probably, but I just don't see any situation where I'd use them like
that.

    Thanks,

        Stephen

Вложения

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

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