I just want to make sure that I am interpreting this data correctly.

From pg_statio_user_tables, I have pulled relname, heap_blks_read, 
heap_blks_hit.  I get several rows like this:
relname                         heap_bkls_read  heap_blks_hit
 clmhdr                         8607161                 196547165                      

So this means that I am getting over a 100% cache hit ratio for this table, 
right?  If not, please help me understand what these numbers mean.



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to