Re: Autovacuum on by default?

From: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
To: "Peter Eisentraut" <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Autovacuum on by default?
Date: 2006-08-26 12:40:46
Message-ID: 1d4e0c10608260540i3faeaepad66ecb7d9b9bde@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 8/25/06, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> 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.
> - 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)

IMHO, we shoud also change superuser_reserved_connections from 2 to 3
because one of the connections will be used by autovacuum.

--
Guillaume

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonah H. Harris 2006-08-26 12:44:07 Re: integration of pgcluster into postgresql
Previous Message Jonah H. Harris 2006-08-26 12:35:10 Re: Adding fulldisjunctions to the contrib