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

In response to

• Re: pg_stats not getting updated.... at 2005-06-03 14:21:45 from Himanshu Baweja

Responses

• Re: pg_stats not getting updated.... at 2005-06-03 17:06:09 from Himanshu Baweja
• Re: pg_stats not getting updated.... at 2005-06-06 07:53:51 from Himanshu Baweja

pgsql-hackers by date

Next:	From: Gevik Babakhani	Date: 2005-06-03 15:57:32
	Subject: Re: PostgreSQL Developer Network
Previous:	From: Himanshu Baweja	Date: 2005-06-03 14:21:45
	Subject: Re: pg_stats not getting updated....