On 1/5/06, Szabolcs BALLA <szballa@xxxxxxxxxxxxxxxxx> 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 ;)
