Re: Question regarding autovacuum

Поиск
Список
Период
Сортировка
От Steve Crawford
Тема Re: Question regarding autovacuum
Дата
Msg-id 46D48F8E.4040104@pinpointresearch.com
обсуждение исходный текст
Ответ на Re: Question regarding autovacuum  (Karl Denninger <karl@denninger.net>)
Ответы Re: Question regarding autovacuum
Список pgsql-general
Karl Denninger wrote:

>> Are your FSM settings enough to keep track of the dead space you have?
>>
> I don't know.  How do I check?

vacuum verbose;

Toward the bottom you will see something like:
...
1200 page slots are required to track all free space.
Current limits are:  453600 page slots, 1000 relations, using 2723 kB.
....

Make sure your current limits have a higher number than the page slots
required.

Cheers,
Steve

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Question regarding autovacuum
Следующее
От: Erik Jones
Дата:
Сообщение: Re: Out of Memory - 8.2.4