Re: Extremely slow server?

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Extremely slow server?
Дата
Msg-id CAMkU=1wzKV9CkFPVSH8qS0DGaG-rNeL2bfN-Q_9zN16+h+OEYg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Extremely slow server?  (bricklen <bricklen@gmail.com>)
Список pgsql-performance
On Sat, Sep 14, 2013 at 7:06 PM, bricklen <bricklen@gmail.com> wrote:


I don't have any solutions at the moment, but three things come to mind:

1). Try without "--blobs",
2). Does "strace -p <pid of pg_dump process>" show anything unusual? Futex? Lots of semops?

He probably needs to find the pid of the backend to which pg_dump is connected (such as from pg_stat_activity), and strace that rather than stracing pg_dump itself.

Cheers,

Jeff

В списке pgsql-performance по дате отправления:

Предыдущее
От: Vitalii Tymchyshyn
Дата:
Сообщение: Re: Extremely slow server?
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: COPY TO and VACUUM