Re: Vacuum is needed or not? - Mailing list pgsql-admin

From Jaime Casanova
Subject Re: Vacuum is needed or not?
Date
Msg-id c2d9e70e0601050748j75b26a82r3c68532aa04ec4e4@mail.gmail.com
Whole thread Raw
In response to Vacuum is needed or not?  (Szabolcs BALLA <szballa@confinsystems.com>)
Responses Re: Vacuum is needed or not?  (Guido Barosio <gbarosio@gmail.com>)
List pgsql-admin
On 1/5/06, Szabolcs BALLA <szballa@confinsystems.com> wrote:
>
>
VACUUM is needed at least every billion transactions...

execute it in a
> script periodically... if you are in doubt if you need
VACUUM then you need
> it urgently, execute it right now!!!

>
> yes, and i running every weekend a full analyze, but actually i think it's
> need again, but just for feel i couldn't stop the server.
> I need evidence. (oldspice rulez ;))
>
> Szabek

a plain VACUUM (without full) is enough in most cases... and you don't
need to stop the server for a plain VACUUM...

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

pgsql-admin by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Vacuum is needed or not?
Next
From: Guido Barosio
Date:
Subject: Re: Vacuum is needed or not?