Re: pg_dump far too slow - Mailing list pgsql-performance

From Robert Haas
Subject Re: pg_dump far too slow
Date
Msg-id 603c8f071003151853h155a3ebi9623f5929dacd16@mail.gmail.com
Whole thread Raw
In response to pg_dump far too slow  (David Newall <postgresql@davidnewall.com>)
List pgsql-performance
On Sun, Mar 14, 2010 at 4:01 AM, David Newall
<postgresql@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

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: shared_buffers advice
Next
From: Robert Haas
Date:
Subject: Re: GiST index performance