Re: pg_dump far too slow

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: pg_dump far too slow
Дата
Msg-id 603c8f071003151853h155a3ebi9623f5929dacd16@mail.gmail.com
обсуждение исходный текст
Ответ на pg_dump far too slow  (David Newall <postgresql@davidnewall.com>)
Список 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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: shared_buffers advice
Следующее
От: Robert Haas
Дата:
Сообщение: Re: GiST index performance