Re: [GENERAL] 5 minutes to pg_dump nothing

On 9/23/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I wrote:
> > "Nikita The Spider The Spider" <nikitathespider@gmail.com> writes:
> >> Thanks for your help! Given that this problem seems to be triggered by
> >> a sort of edge case and the fix is non-trivial, I guess I should not
> >> expect a new version of pg_dump soon?
>
> > We might look into fixing it for 8.3, but I doubt we'd risk back-patching
> > such a change to older branches.
>
> Actually, it doesn't look that hard --- want to try the attached patch?
> I couldn't measure any speed difference at all on the standard PG
> regression-test database, but there are not huge numbers of objects
> in that.

Tom,
Your patch decreases the runtime of pg_dump by an order of magnitude for me which means I don't have to roll my own table dumper. Thanks very much for the swift turnaround and for a great database.

-- 
Philip
http://NikitaTheSpider.com/
Whole-site HTML validation, link checking and more

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly