Re: Strange problem with autovacuum

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

El 14/11/2017 a las 10:49 a. m., David G. Johnston escribió:
> On Tue, Nov 14, 2017 at 8:45 AM, Efraín Déctor
> <efraindector(at)motumweb(dot)com <mailto: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.
>