Re: Autovacuum on by default?

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Autovacuum on by default?
Date: 2006-08-25 16:03:08
Message-ID: 44EF1F3C.8090602@zeut.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> "Matthew T. O'Connor" <matthew(at)zeut(dot)net> writes:
>
>> 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.

I don't have any significant objection to removing them, it just seemed
to me that we are late in release cycle and that might be more than we
want to do at the moment. If others think it's OK, then it's OK with me.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-08-25 16:10:52 Re: [GENERAL] invalid byte sequence ?
Previous Message Martin Atukunda 2006-08-25 16:01:38 Re: [HACKERS] psql 'none' as a HISTFILE special case