Himanshu Baweja <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster