Re: [HACKERS] [GENERAL] pg_dump incredibly slow dumping a single schema from a large db

2012-03-31 Thread Tom Lane
I wrote: > So this is dumb; we should manage the "is the object already processed" > component of that with an O(1) check, like a bool array or some such, > rather than an O(N) search loop. > As for the getTables slowdown, the only part of that I can see that > looks to be both significant and ent

Re: [HACKERS] [GENERAL] pg_dump incredibly slow dumping a single schema from a large db

2012-03-31 Thread Tom Lane
Mike Roest writes: > The file is 6 megs so I've dropped it here. > That was doing perf for the length of the pg_dump command and then a perf > report -n > http://dl.dropbox.com/u/13153/output.txt Hmm ... that's a remarkably verbose output format, but the useful part of this info seems to be just