Re: Autovacuum on by default?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Autovacuum on by default?
Дата
Msg-id 1802.1156521451@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Autovacuum on by default?  ("Matthew T. O'Connor" <matthew@zeut.net>)
Ответы Re: Autovacuum on by default?
[Open Item] Re: Autovacuum on by default?
Список pgsql-hackers
"Matthew T. O'Connor" <matthew@zeut.net> writes:
> Peter Eisentraut wrote:
>> - Leave base thresholds alone (pending further analysis that might remove them 
>> altogether?)

> While there is talk of removing this all together, I think it was also 
> agreed that as long as these values are there, they should be reduced. 
> I think the defaults in 8.1 are 1000/500, I think 200/100 was suggested.

ISTM that if we don't want to remove the thresholds immediately,
we should make them default to zero for a release or two and see how
well it works.

At the moment I can't find the thread that discussed removing them,
but IIRC there were some good arguments why the thresholds should always
be zero.
        regards, tom lane


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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: [GENERAL] invalid byte sequence ?
Следующее
От: "Martin Atukunda"
Дата:
Сообщение: Re: [PATCHES] psql 'none' as a HISTFILE special case