Re: Autovaccum - Mailing list pgsql-sql

From Alvaro Herrera
Subject Re: Autovaccum
Date
Msg-id 20061130142406.GH15105@alvh.no-ip.org
Whole thread Raw
In response to Autovaccum  ("Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>)
Responses Re: Autovaccum
Re: Autovaccum
List pgsql-sql
Ezequias Rodrigues da Rocha wrote:
> Hi list,
> 
> I would like to know if it is necessary to set my database to
> autovaccum if the intent of my DB Manager is do not make any deletion
> in any time.
> 
> If there is no deletions why autovaccum ok ?

You need to vacuum from time to time anyway, even if you don't delete
anything.  The easiest way to do it is let autovacuum do it for you.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-sql by date:

Previous
From: "Ezequias Rodrigues da Rocha"
Date:
Subject: Autovaccum
Next
From: "Peter Childs"
Date:
Subject: Re: Autovaccum