Re: Autovacuum Daemon is Turned On by Default in Postgres 8.3.8?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Autovacuum Daemon is Turned On by Default in Postgres 8.3.8?
Date: 2010-06-03 01:51:30
Message-ID: AANLkTilEjlruSzeJPOtlQ76r2Wv_x1EA8aE2IsOYdfLM@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 2, 2010 at 6:40 PM, Wang, Mary Y <mary(dot)y(dot)wang(at)boeing(dot)com> wrote:
> Hi,
>
> I'm looking at my log file (see my log file below) and it seems like the autovacuum daemon is turned on by default in Postgres 8.3.8.  Does that mean that I no longer need to manually invoke the autovacuum command anymore?  I used to do it manually in an older version of Postgres.

For most installations autovacuum with default settings is just fine.
If you run a really busy site then you might have to adjust the
parameters of autovac as well as the free space map.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message zhong ming wu 2010-06-03 03:00:33 c program fails to run with the postgres which is installed at user location
Previous Message Adrian Klaver 2010-06-03 01:21:47 Re: Autovacuum Daemon is Turned On by Default in Postgres 8.3.8?