Re: [NOVICE] Strange problem with autovacuum

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [NOVICE] Strange problem with autovacuum
Дата
Msg-id CAKFQuwavACgFRsMMk1egLCmd6OGNkb1GO_3L2J=X_dQ71P3JSQ@mail.gmail.com
обсуждение исходный текст
Ответ на [NOVICE] Strange problem with autovacuum  (Efraín Déctor <efraindector@motumweb.com>)
Ответы Re: [NOVICE] Strange problem with autovacuum  (Efraín Déctor <efraindector@motumweb.com>)
Список pgsql-novice
Дерево обсуждения
On Tue, Nov 14, 2017 at 8:45 AM, Efraín Déctor <efraindector@motumweb.com> wrote:

Hello list.

I have a strange problem with one of our servers (PostgreSQl 9.2.8). Every monday the autovacuum workers seems to stop working (the workers decrease in number) this causes that 5 tables that are constantly updated and deleted to be really slow.


​Best guess is you have a weekly query being run that requires significant locking to execute and is thus preventing vacuum from doing its thing.

pg_stat_activity and pg_locks should be consulted during those times to gain a better feel for everything that is running during those troughs.

Maybe a Sunday night pg_dump?

David J.

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

Предыдущее
От: Efraín Déctor
Дата:
Сообщение: Re: [NOVICE] Strange problem with autovacuum
Следующее
От: JORGE MALDONADO
Дата:
Сообщение: [NOVICE] Please advice on a query