Re: Performance issue in pg_dump's dependency loop searching

Simon Riggs <simon@2ndQuadrant.com> writes:
> On 25 July 2014 20:47, Tom Lane <tgl@sss.pgh.pa.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