Himanshu Baweja wrote:
i also noted one more thing... the stats are getting updated only when i do vacuum.... is that wht is supposed to happen... or something is wrong....
Hmm - there's something strange going on certainly. Try a couple of simple queries on a table and see whether the stats get updated.
It is possible that during very busy periods the stats don't get recorded - that's part of the design.
-- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx