On Jul 1, 2009, at 4:20 AM, Gerd König wrote:
b) pg_statio_user_tables=>
heap_blks_read is the number of disk blocks read for that table
(excluding index
access), does heap_blks_hit mean the number of accesses to the
cache for that data ?
...and is the number of heap_blks_read in heap_blks_h
Hello,
I'm currently have to investigate some time to anyalyze how often the database
has to read data from disk compared to the number of cache(shared buffer)
accesses.
I got the following key figures for an example table:
a) pg_statio_user_indexes=>
-[ RECORD 12 ]+
