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 <[EMAIL PROTECTED]>:
On 30/11/06, Alvaro Herrera <[EMAIL PROTECTED]> 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/
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
