Hi Everybody,
If i do vacuumdb -z <databasename> daily as a part of my maintanence, do i have to still vacuum analyze each table in the database ?. The reason i am asking is that even though i do vacuumdb daily my stats are not updated properly in pg_class view and the reltuples values is much higher than the actual records in the table ? can anyone shed some light on this problem ?
Thanks!
Pallav
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
