On Tue, 30 Mar 2010 13:01:54 +0200, Peter Eisentraut <peter_e@gmx.net>
wrote:
> On tis, 2010-03-30 at 08:39 +0200, Stefan Kaltenbrunner wrote:
>> on fast systems pg_dump is completely CPU bottlenecked
>
> Might be useful to profile why that is. I don't think pg_dump has
> historically been developed with CPU efficiency in mind.
Already done that (I had posted some WIP patches to speed up COPY,
hopefully I'll have time to finish those one day ;)
Most of the time spent in the postmaster process during "COPY TO" is in
the datum -> string functions.