From: | "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com> |
---|---|
To: | "Peter Childs" <peterachilds(at)gmail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Autovaccum |
Date: | 2006-11-30 15:03:41 |
Message-ID: | 55c095e90611300703j580fef50tae19393af37f7988@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)gmail(dot)com>:
> On 30/11/06, Alvaro Herrera <alvherre(at)commandprompt(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Shane Ambler | 2006-11-30 15:10:53 | Re: Autovaccum |
Previous Message | Peter Childs | 2006-11-30 14:56:56 | Re: Autovaccum |