Re: Vacuum as "easily obtained" locks

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Vacuum as "easily obtained" locks
Дата
Msg-id CAOR=d=34ATQGx54Rp+mpknqKK125TVuHWLGEGW_HfJuB8GH0uA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Vacuum as "easily obtained" locks  (Andy Colson <andy@squeakycode.net>)
Список pgsql-general
On Wed, Aug 3, 2011 at 8:03 AM, Andy Colson <andy@squeakycode.net> wrote:
> If you have lots and lots of tables, autovacuum only checks one at a time,
> then wait's a bit.  Did you run your test for several days?

Not true.  autovac naps by default 1 minute between each db. i.e. if
you have 5 dbs it takes 5 minutes by default to check each database.
So if autovac is on it should have run within a few minutes on his
database, unless he has hundreds of dbs.

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

Предыдущее
От: Andy Colson
Дата:
Сообщение: Re: Vacuum as "easily obtained" locks
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Vacuum as "easily obtained" locks