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

From Peter Eisentraut
Subject Re: Autovacuum on by default?
Date
Msg-id 200608251130.46372.peter_e@gmx.net
Whole thread Raw
In response to Autovacuum on by default?  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Autovacuum on by default?
Re: Autovacuum on by default?
List pgsql-hackers
Summarizing this thread, I see support for the following:

- autovacuum set to on by default in 8.2.

- stats_row_level also defaults to on.

(Perhaps stats_block_level should also default to on so it's not inconsistent, 
seeing that everything else in on, too.)

- Delayed vacuum and delayed autovacuum will stay disabled.

- Scale factor set to 0.08 (vacuum) and 0.04 (analyze) (?)  (formerly 0.4 and 
0.2)

- Leave base thresholds alone (pending further analysis that might remove them 
altogether?)

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-hackers by date:

Previous
From: Markus Schiltknecht
Date:
Subject: Re: Replication
Next
From: stark
Date:
Subject: Re: Tricky bugs in concurrent index build