Postgres Pro
Downloads
Home   >   mailing lists

Re: [NOVICE] Strange problem with autovacuum - Mailing list pgsql-novice

From David G. Johnston
Subject Re: [NOVICE] Strange problem with autovacuum
Date
Msg-id CAKFQuwavACgFRsMMk1egLCmd6OGNkb1GO_3L2J=X_dQ71P3JSQ@mail.gmail.com
Whole thread Raw
In response to [NOVICE] Strange problem with autovacuum  (Efraín Déctor <efraindector@motumweb.com>)
Responses Re: [NOVICE] Strange problem with autovacuum
List pgsql-novice
Tree view
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 by date:

Previous
From: Efraín Déctor
Date:
Subject: Re: [NOVICE] Strange problem with autovacuum
Next
From: JORGE MALDONADO
Date:
Subject: [NOVICE] Please advice on a query