Re: Problems with autovacuum

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problems with autovacuum
Дата
Msg-id 6357.1243277706@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Problems with autovacuum  (Łukasz Jagiełło <lukasz.jagiello@gforces.pl>)
Ответы Re: Problems with autovacuum  (Łukasz Jagiełło <lukasz.jagiello@gforces.pl>)
Re: Problems with autovacuum  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-performance
=?UTF-8?B?xYF1a2FzeiBKYWdpZcWCxYJv?= <lukasz.jagiello@gforces.pl> writes:
> That autovacuum working hole time, shoudn't be run only when db needs ?

With 2000 databases to cycle through, autovac is going to be spending
quite a lot of time just finding out whether it needs to do anything.
I believe the interpretation of autovacuum_naptime is that it should
examine each database that often, ie once a minute by default.  So
it's got more than 30 databases per second to look through.

Maybe it would make more sense to have one database (or at least,
many fewer databases) and 2000 schemas within it?

If you really want to stick with this layout, you're going to have to
increase autovacuum_naptime.

            regards, tom lane

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

Предыдущее
От: Łukasz Jagiełło
Дата:
Сообщение: Re: Problems with autovacuum
Следующее
От: Łukasz Jagiełło
Дата:
Сообщение: Re: Problems with autovacuum