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