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!
Find restaurants, movies, travel & more fun for the weekend.
Check it out!