Re: pg_dump additional options for performance - Mailing list pgsql-patches

From Tom Lane
Subject Re: pg_dump additional options for performance
Date
Msg-id 19095.1216682386@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump additional options for performance  (Stephen Frost <sfrost@snowman.net>)
Responses Re: pg_dump additional options for performance  (Simon Riggs <simon@2ndquadrant.com>)
List 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 by date:

Previous
From: Stephen Frost
Date:
Subject: Re: pg_dump additional options for performance
Next
From: daveg
Date:
Subject: Re: pg_dump lock timeout