| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Efraín Déctor <efraindector(at)motumweb(dot)com> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Strange problem with autovacuum |
| Date: | 2017-11-14 16:49:13 |
| Message-ID: | CAKFQuwavACgFRsMMk1egLCmd6OGNkb1GO_3L2J=X_dQ71P3JSQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Tue, Nov 14, 2017 at 8:45 AM, Efraín Déctor <efraindector(at)motumweb(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | JORGE MALDONADO | 2017-11-14 17:04:32 | Please advice on a query |
| Previous Message | Efraín Déctor | 2017-11-14 16:40:08 | Re: Strange problem with autovacuum |