Search Postgresql Archives

Re: Stats not getting updated....

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux