Re: Stats not getting updated....
| От | Himanshu Baweja |
|---|---|
| Тема | Re: Stats not getting updated.... |
| Дата | |
| Msg-id | 20050602103848.40197.qmail@web51004.mail.yahoo.com обсуждение исходный текст |
| Ответ на | Stats not getting updated.... (Himanshu Baweja <himanshubaweja@yahoo.com>) |
| Ответы |
Re: Stats not getting updated....
|
| Список | pgsql-general |
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:
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....thxHimanshu
Discover Yahoo!
Have fun online with music videos, cool games, IM & more. Check it out!
В списке pgsql-general по дате отправления: