Re: High CPU load caused by the autovacuum launcher process

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: High CPU load caused by the autovacuum launcher process
Дата
Msg-id CAMkU=1z3swfd7V+BTjDgLkxEhQ3TTf-puQMm8MVE1=ah3u9M6w@mail.gmail.com
обсуждение исходный текст
Ответ на High CPU load caused by the autovacuum launcher process  (Owayss Kabtoul <owayssk@gmail.com>)
Список pgsql-admin
Дерево обсуждения
On Fri, Jun 8, 2018 at 3:24 AM, Owayss Kabtoul <owayssk@gmail.com> wrote:
Hi folks,

I ran into an issue where, on Postgres instances that have a very large number of databases per cluster (~15K), the autovacuum process seems to have a very high impact on CPU usage. Specifically, it is the autovacuum launcher process, not the workers. The launcher process eats a whole CPU (attached is in screenshot of htop).
...
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.

After changing autovacuum_naptime, did you give it enough time to stabilize at the new setting?  Say, at least 3 * 50 = 150 minutes?

But overall, I would say that if you want to have 15,000 databases, you should just resign yourself to having one CPU dedicated to this task.

Cheers,

Jeff

В списке pgsql-admin по дате отправления:

Предыдущее
От: Steven Crandell
Дата:
Сообщение: Re: High CPU load caused by the autovacuum launcher process
Следующее
От: Tom Lane
Дата:
Сообщение: Re: High CPU load caused by the autovacuum launcher process