On Sun, Mar 14, 2010 at 4:01 AM, David Newall <postgre...@davidnewall.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance