Re: [Open Item] Re: Autovacuum on by default?

Поиск
Список
Период
Сортировка
От Christopher Browne
Тема Re: [Open Item] Re: Autovacuum on by default?
Дата
Msg-id 87r6z3y81z.fsf@wolfe.cbbrowne.com
обсуждение исходный текст
Ответ на Autovacuum on by default?  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Centuries ago, Nostradamus foresaw when peter_e@gmx.net (Peter Eisentraut) would write:
> Jim C. Nasby wrote:
>> I thought we had agreed it would be a good idea to turn autovac_delay
>> on?
>
> We had not, because there was no experience available about where to put 
> the default numbers.

I would also not because for Very Large Tables, the delay may make
vacuums run really inordinately long.  And that becomes an "evil big
long-running transaction" to worsen things.
-- 
(format nil "~S@~S" "cbbrowne" "gmail.com")
http://cbbrowne.com/info/internet.html
Signs of  a Klingon Programmer - 2.  "Specifications are  for the weak
and timid!"


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

Предыдущее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: integration of pgcluster into postgresql
Следующее
От: Markus Schiltknecht
Дата:
Сообщение: Re: integration of pgcluster into postgresql