| From: | Himanshu Baweja <himanshubaweja(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Stats not getting updated.... |
| Date: | 2005-06-02 09:03:37 |
| Message-ID: | 20050602090339.17144.qmail@web51004.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nageshwar Rao | 2005-06-02 09:36:45 | writing a file using procedure |
| Previous Message | Janning Vygen | 2005-06-02 08:36:20 | One Sequence for all tables or one Sequence for each table? |