Re: High CPU load caused by the autovacuum launcher process

On 06/08/2018 02:24 AM, Owayss Kabtoul wrote:
> Hi folks,
>
> I ran into an issue where, on Postgres instances that have a very large 
> number of databases per cluster (~15K), the

I won't ask why there's a cluster with 15,000 databases...

> So auto-vacuum never really sleeps. Even changing the autovacuum_naptime 
> and setting it to a much higher value (from 1min to 50min) did not have 
> any effect at all. Both strace and the postgres logs showed a similar 
> behaviour: lots of reads to global.stat file and constantly iterating 
> through all the databases non-stop and executing autovacuum.
>
>
> Is there anything that I can do to minimize the CPU load impact that this 
> process is having?

What if you disable autovacuum and run it manually?

-- 
Angular momentum makes the world go 'round.