Soeren Gerlach <soeren@all-about-shift.com> writes:
> * pg_dump takes 2/3 of the [single] CPU, postmaster the other 1/3 for both
> dumps
Really!? Hmm, that seems fairly backwards ... thinks ...
In the -Fc case this makes some amount of sense because pg_dump runs
gzip-style compression on the data (which is why the output file is
so much smaller). But for plain text dump, pg_dump should be just
pushing the data straight through to stdout; it really ought not take
much CPU as far as I can see. There may be some simple performance
glitch involved there. Are you interested in recompiling with -pg
and getting a gprof profile of pg_dump?
regards, tom lane