On Sun, Mar 14, 2010 at 4:01 AM, David Newall <postgresql@xxxxxxxxxxxxxxx> wrote: > an expected 40 - 45GB of compressed output. CPU load is 100% on the core > executing pg_dump, and negligible on all others cores. The system is > read-mostly, and largely idle. The exact invocation was: > > nohup time pg_dump -f database.dmp -Z9 database Can you connect a few times with gdb and do "bt" to get a backtrace? That might shed some light on where it's spending all of its time. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
