Re: slowness what only full vacuum can solve

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: slowness what only full vacuum can solve
Дата
Msg-id 502532010200002500049588@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: slowness what only full vacuum can solve  (Laszlo Fogas <laszlo@falconsocial.com>)
Список pgsql-general
Laszlo Fogas <laszlo@falconsocial.com> wrote:

> Sorry, I wasn't clear.
>
> Autovacuum runs with default setting, I believe it's daily, or
> whenever it feels like.
>
> When autovacuum was disabled, we had this problem once every 2
> months.
>
> With autovacuum enabled, we had this problem once in every six
> month.

That was quite clear.

> It seems autovacuum could only delay the event, but not prevent
> it.

Autovacuum with default settings improves it drastically.
Autovacuum with more aggressive settings might well prevent the
problem entirely.

-Kevin


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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: slowness what only full vacuum can solve
Следующее
От: François Beausoleil
Дата:
Сообщение: Re: slowness what only full vacuum can solve