On 9/23/07, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > I wrote: > > "Nikita The Spider The Spider" <nikitathespider@xxxxxxxxx> 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@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
