Skip site navigation (1) Skip section navigation (2)

pg_stats not getting updated....

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 (view raw or flat)
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!

pgsql-hackers by date

Next:From: Robert TreatDate: 2005-06-03 11:02:08
Subject: Re: Google's Summer of Code ...
Previous:From: Marian POPESCUDate: 2005-06-03 09:13:25
Subject: Re: PostgreSQL Developer Network

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group