Re: Autovaccum

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Ezequias Rodrigues da Rocha <ezequias(dot)rocha(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Autovaccum
Date: 2006-11-30 14:24:06
Message-ID: 20061130142406.GH15105@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

  • Autovaccum at 2006-11-30 14:02:34 from Ezequias Rodrigues da Rocha

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Childs 2006-11-30 14:56:56 Re: Autovaccum
Previous Message Ezequias Rodrigues da Rocha 2006-11-30 14:02:34 Autovaccum