Postgres Pro
Downloads
Home   >   mailing lists

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

From Simon Riggs
Subject Re: Performance issue in pg_dump's dependency loop searching
Date
Msg-id CA+U5nM+2nU=bizBZqpUzVe9PCWcUNCVSxz6O6-M=darX8pS1kg@mail.gmail.com
Whole thread Raw
In response to Performance issue in pg_dump's dependency loop searching  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Performance issue in pg_dump's dependency loop searching  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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.

-- Simon Riggs                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Making joins involving ctid work for the benefit of UPSERT
Next
From: Tom Lane
Date:
Subject: Re: Performance issue in pg_dump's dependency loop searching