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

Hello.

I have 2 processes that runs on monday. I will stop them and see if it helps.

I understand the while the procesess are running the autovacuum will stop, but shouldnt they resume their work after the procesess are finished?

Thanks

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.