Re: Performance issue in pg_dump's dependency loop searching - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Performance issue in pg_dump's dependency loop searching
Date
Msg-id 4653.1406657190@sss.pgh.pa.us
Whole thread Raw
In response to Re: Performance issue in pg_dump's dependency loop searching  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Performance issue in pg_dump's dependency loop searching  (Claudio Freire <klaussfreire@gmail.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Performance issue in pg_dump's dependency loop searching
Next
From: Claudio Freire
Date:
Subject: Re: Performance issue in pg_dump's dependency loop searching