Re: Still recommending daily vacuum... - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: Still recommending daily vacuum...
Date
Msg-id 4689CE1A.2010402@commandprompt.com
Whole thread Raw
In response to Re: Still recommending daily vacuum...  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Still recommending daily vacuum...
List pgsql-hackers
Alvaro Herrera wrote:
> Joshua D. Drake wrote:
>> Tom Lane wrote:
>>> "Jim C. Nasby" <decibel@decibel.org> writes:
>>>> http://developer.postgresql.org/pgdocs/postgres/routine-vacuuming.html :
>>> Well, with autovac defaulting to ON in 8.3, that's certainly obsolete
>>> text now.
>>>
>>> Is there a reason to say anything beyond "use autovac"?
>> 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.

Joshua D. Drake




-- 
      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Still recommending daily vacuum...
Next
From: "Pavel Stehule"
Date:
Subject: Re: what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL