Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> On 25 July 2014 20:47, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Another idea would be to
> ...persist the optimal dump order in the database.
> That way we can maintain the correct dump order each time we do DDL,
> which is only a small incremental cost, no matter how many objects we
> have.
I don't see any obvious way to make it incremental; so I doubt that
it would be a small extra cost. In any case I disagree that making DDL
slower to make pg_dump faster is a good tradeoff. Many people seldom
or never use pg_dump.
regards, tom lane