Re: Autovacuum help..

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Autovacuum help..
Дата
Msg-id cone.1154878879.713281.31808.1000@zoraida.natserv.net
обсуждение исходный текст
Ответ на Autovacuum help..  (Sundar Narayanaswamy <sundar007@yahoo.com>)
Ответы Re: Autovacuum help..
Список pgsql-general
Matthew T. O'Connor writes:

> In many instances the default thresholds for autovacuum are too
> conservative.  You can try making it more aggressive and see what
> happens, you can do this generally, or on a table specific basis.

I think something is very wrong with the estimates I am getting back. After
3 times increasing the max_fsm_pages, every time I get the same error..
about needing to increase max_fsm_pages.. and always the error is
recommending exactly the same number of additional fsm_pages.

I see other threads with other people having simmilar problems. Going to see
if I can find a resolution in the archives.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Disabling and enabling constraints and triggers to make pg_restore work
Следующее
От: Chris
Дата:
Сообщение: Re: error initing db