pg_dump makes our system unusable - any way to pg_dump in the middle of the day? (postgres 8.4.4)

Поиск
Список
Период
Сортировка
От Aleksey Tsalolikhin
Тема pg_dump makes our system unusable - any way to pg_dump in the middle of the day? (postgres 8.4.4)
Дата
Msg-id AANLkTins5cg3vR6TZoBVr4RYi4GWeF9kbxXiDOCa-NTt@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_dump makes our system unusable - any way to pg_dump in the middle of the day? (postgres 8.4.4)  (Adam Bruss <abruss@awrcorp.com>)
Re: pg_dump makes our system unusable - any way to pg_dump in the middle of the day? (postgres 8.4.4)  (Vick Khera <vivek@khera.org>)
Список pgsql-general
I read in the pg_dump man page that pg_dump does not block other users
accessing the database (readers or writers).

In practice, if I pg_dump our 100 GB database, our application, which
is half Web front end and half OLTP, at a certain point, slows to a
crawl and the Web interface becomes unresponsive.  I start getting
check_postgres complaints about number of locks and query lengths.  I
see locks around for over 5 minutes.

I've had to abort pg_dump as it made the system unusable.

Can I pg_dump without breaking the system?

Best,
-at

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

Предыдущее
От: Aleksey Tsalolikhin
Дата:
Сообщение: Re: database is bigger after dump/restore - why? (60 GB to 109 GB)
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: database is bigger after dump/restore - why? (60 GB to 109 GB)