From: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
To: Peter Childs <peterachilds@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Autovaccum
Date: Thu, 30 Nov 2006 13:03:41 -0200
Message-ID: <55c095e90611300703j580fef50tae19393af37f7988@mail.gmail.com> (raw)
In-Reply-To: <a2de01dd0611300656r2c662c17na05360d941b57ac3@mail.gmail.com>
References: <55c095e90611300602n18fa7e8v8e985386f74afba1@mail.gmail.com>
<20061130142406.GH15105@alvh.no-ip.org>
<a2de01dd0611300656r2c662c17na05360d941b57ac3@mail.gmail.com>
It is possible to set this up on PgAdmin ?
I need to shutdown the postgresql service to change this parameters ?
ps: Your information was very clear for me. Thank you very much.
Ezequias
2006/11/30, Peter Childs <peterachilds@gmail.com>:
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/
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: ezequias.rocha@gmail.com, peterachilds@gmail.com
Subject: Re: Autovaccum
In-Reply-To: <55c095e90611300703j580fef50tae19393af37f7988@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