From: Peter Childs <peterachilds@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Autovaccum
Date: Thu, 30 Nov 2006 14:56:56 +0000
Message-ID: <a2de01dd0611300656r2c662c17na05360d941b57ac3@mail.gmail.com> (raw)
In-Reply-To: <20061130142406.GH15105@alvh.no-ip.org>
References: <55c095e90611300602n18fa7e8v8e985386f74afba1@mail.gmail.com>
<20061130142406.GH15105@alvh.no-ip.org>
On 30/11/06, Alvaro Herrera <alvherre@commandprompt.com> wrote:
> 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.
>
Complete Answer.
1. If you do any updates or deletes you need to vacuum.
2. If you do any update, deletes or inserts you need to analyse.
3. If you never change anything No Updates, No Inserts, No Deletes you
need to vacuum once ever 2 billion transactions due to wrap around if
you don't your data will disappear. But depending on how busy your
database is this could be once a year.
4. Auto Vacuum does all this automatically. Which is kind of useful.
5. You can do this manually via cron or by hand if you wish.
Peter.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: peterachilds@gmail.com
Subject: Re: Autovaccum
In-Reply-To: <a2de01dd0611300656r2c662c17na05360d941b57ac3@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox