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

Re: pg_stats not getting updated....

From: Himanshu Baweja <himanshubaweja(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_stats not getting updated....
Date: 2005-06-03 17:06:09
Message-ID: 20050603170609.18804.qmail@web51001.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-hackers
--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Himanshu Baweja <himanshubaweja(at)yahoo(dot)com> writes:
> > "SELECT pg_stat_get_db_blocks_fetched(764755937),
> > pg_stat_get_db_blocks_hit(764755937);"
> > gives be constantly increasing stats and
> 
> > "SELECT relname,heap_blks_read from
> > pg_statio_user_tables order by heap_blks_read DESC
> > LIMIT 15;"
> 
> > is still showing me all zero 4 mins into the test
> > until i first vacuum analyze is done....
> 
> Um, looking at the view definition, heap_blks_read
> is the *difference*
> between blocks_fetched and blocks_hit ... is it
> possible your test is
> testing a 100%-cached situation, such that those two
> numbers increase
> in lockstep?
> 
> 			regards, tom lane
> 

both blocks fetched and block reads are zero... had
already checked for that.... => block hit is also
zero...

any ideas now...

thx
Himanshu


		
__________________________________ 
Discover Yahoo! 
Have fun online with music videos, cool games, IM and more. Check it out! 
http://discover.yahoo.com/online.html

In response to

pgsql-hackers by date

Next:From: Gevik babakhaniDate: 2005-06-03 17:12:00
Subject: Re: PostgreSQL Developer Network
Previous:From: Alon GoldshuvDate: 2005-06-03 16:57:00
Subject: Re: NOLOGGING option, or ?

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