Re: Autovacuum on by default? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Autovacuum on by default?
Date
Msg-id 1802.1156521451@sss.pgh.pa.us
Whole thread Raw
In response to Re: Autovacuum on by default?  ("Matthew T. O'Connor" <matthew@zeut.net>)
Responses Re: Autovacuum on by default?
[Open Item] Re: Autovacuum on by default?
List 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 by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: [GENERAL] invalid byte sequence ?
Next
From: "Martin Atukunda"
Date:
Subject: Re: [PATCHES] psql 'none' as a HISTFILE special case