On 1/5/06, Szabolcs BALLA <szballa(at)confinsystems(dot)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 ;)