Re: pg_dump additional options for performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump additional options for performance
Дата
Msg-id 19095.1216682386@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dump additional options for performance  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: pg_dump additional options for performance
Список pgsql-patches
Stephen Frost <sfrost@snowman.net> writes:
> Are there use cases for just --omit-post-load or --omit-pre-load?

Probably not many.  The thing that's bothering me is the
action-at-a-distance property of the positive-logic switches.
How are we going to explain this?

    "By default, --schema-pre-load, --data-only, --schema-post-load
    are all ON.  But if you turn one of them ON (never mind that
    it was already ON by default), that changes the defaults for
    the other two to OFF.  Then you have to turn them ON (never
    mind that the default for them is ON) if you want two out of
    the three categories."

You have to bend your mind into a pretzel to wrap it around this
behavior.  Yeah, it might be convenient once you understand it,
but how long will it take for the savings in typing to repay the
time to understand it and the mistakes along the way?

            regards, tom lane

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

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