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....
thx
Himanshu
Himanshu Baweja <himanshubaweja@yahoo.com> wrote:
i am trying to identify which tables should be moved to diff drives.... i first identified the most used tables... by looking at the data in pg_statio_user_tables.....
and then i did sampling of the io-usage of these tables every 2 mins... to identify which are getting used when....
but the problem is my stats are not getting updated.... they first get updated around 20% done... and then once more at around 70% done.... why is the stats not getting updated more frequently.....
the test application i am using has a 33 min test with lots of read and write....
thx
Himanshu
Discover Yahoo!
Have fun online with music videos, cool games, IM & more.
Check it out!