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

Re: pg_stats not getting updated....

From: Himanshu Baweja <himanshubaweja(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_stats not getting updated....
Date: 2005-06-03 12:25:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
i just noted one more thing...
pg_stat_get_db_blocks_fetched/hit is getting updated
but pg_stat_get_blocks_fetched/hit are not getting

why is this happening..


--- Himanshu Baweja <himanshubaweja(at)yahoo(dot)com> wrote:

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

Discover Yahoo! 
Get on-the-go sports scores, stock quotes, news and more. Check it out!


pgsql-hackers by date

Next:From: Tom LaneDate: 2005-06-03 13:29:27
Subject: Re: Source Code Help Needed
Previous:From: Robert TreatDate: 2005-06-03 11:02:08
Subject: Re: Google's Summer of Code ...

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