On 1/5/06, Szabolcs BALLA <szballa@xxxxxxxxxxxxxxxxx> wrote: > Hi, > > How do I know vacuum is need or not? I mean, are there any query to know > status of statistics, tables, indexes, etc? > (7.4.7) > Our database size bigger than just go and do it. :( > > Thanks, > Szabek 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!!! -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)
