From: | Himanshu Baweja <himanshubaweja(at)yahoo(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | pg_stats not getting updated.... |
Date: | 2005-06-03 10:16:46 |
Message-ID: | 20050603101647.2803.qmail@web51007.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
wht i wanted to do is... identify the tables which are getting used simultaneously... so that i can move them to different tablespaces....
for that i tried to do sampling of "pg_statio_user_tables" for top 20 tables...(in terms of usage)... so that i know how much io is being done... for different tables and when....
now the problem is... pg_statio_user_tables is not getting updated... at least wht i am able to make out of documentation is they should be updated regularly at each commit... but i am doing lots of commits in my test application....
also docs state that withing each transaction block postgres tries to give the same stats.... forget abt transaction blocks.. i even tried.. disconnecting and then reconnecting my sampling application every two mins... but no use... each time i am getting same stats...(only 4 updates in 30mins).....
one more thing that i noted is each time i run analyze.... pg_statio_user_tables is updated....
plz note that all pg_stat* tables are not getting updated not just pg_statio*....
i posted in general mailing list but no satisfying reply so i thought maybe u all can tell whts happening......
thx
Himanshu
---------------------------------
Discover Yahoo!
Find restaurants, movies, travel & more fun for the weekend. Check it out!
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2005-06-03 11:02:08 | Re: Google's Summer of Code ... |
Previous Message | Marian POPESCU | 2005-06-03 09:13:25 | Re: PostgreSQL Developer Network |