Re: Autovacuum on by default?

Поиск
Список
Период
Сортировка
От Matthew T. O'Connor
Тема Re: Autovacuum on by default?
Дата
Msg-id 44E4A795.3070403@zeut.net
обсуждение исходный текст
Ответ на Re: Autovacuum on by default?  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Autovacuum on by default?
Список pgsql-hackers
Josh Berkus wrote:
>> Is it time to turn on autovacuum by default in 8.2?  I know we wanted 
>> to be on the side of caution with 8.1, but perhaps we should evaluate 
>> the experiences now.  Comments?
> 
> I'm in favor of this, but do we want to turn on vacuum_delay by default 
> as well?

I thought about this, might be a good idea as it will mitigate the 
impact of vacuums, however it will also slow down vacuums, I'm a bit 
concerned that it won't be able to keep up on really large database, or 
that it'll fall really far behind after vacuuming a big table.

Also, if we do enable it, what is a good default?


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] selecting large result sets in psql using cursors
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Autovacuum on by default?