Re: is pg_autovacuum so effective ?

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: is pg_autovacuum so effective ?
Дата
Msg-id 421BD6BF.4060007@bigfoot.com
обсуждение исходный текст
Ответ на Re: is pg_autovacuum so effective ?  ("Matthew T. O'Connor" <matthew@zeut.net>)
Список pgsql-performance
Matthew T. O'Connor wrote:

> Well without thinking too much, I would first ask about your FSM
> settings?  If they aren't big enought that will cause bloat.  Try
> bumping your FSM settings and then see if you reach steady state.

FSM settings are big enough:

 max_fsm_pages                  | 2000000
 max_fsm_relations              | 1000

at least after a vacuum full I see that these numbers are an overkill...




REgards
Gaetano Mendola








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

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: is pg_autovacuum so effective ?
Следующее
От: Neil Conway
Дата:
Сообщение: Re: PostgreSQL is extremely slow on Windows