Horton

Re: Still recommending daily vacuum...

Michael Paesold <mpaesold@gmx.at>

View thread View on postgr.es
From: Michael Paesold <mpaesold@gmx.at>
To: "Joshua D. Drake" <jd@commandprompt.com>
Cc: Alvaro Herrera <alvherre@commandprompt.com>, Tom Lane <tgl@sss.pgh.pa.us>, "Jim C. Nasby" <decibel@decibel.org>, pgsql-hackers@postgresql.org
Date: 2007-07-03T09:31:08Z
Lists: pgsql-hackers 
Joshua D. Drake wrote:
> Alvaro Herrera wrote:
>> Joshua D. Drake wrote:
>>> Did we change the default autovac parameters for 8.3 (beyond turning 
>>> it on?) because on any reasonably used database, they are way to 
>>> conservative.
>>
>> We're still on time to change them ...  Any concrete proposals?
> 
> I could provide numbers from production high use databases. We could 
> probably back those down a little and make more reasonable numbers.

Please do so. Perhaps others can also tell their typical settings.

Best Regards
Michael Paesold