Re: Slow dump with pg_dump/pg_restore ? How to improve ?

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