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