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.
pgsql-performance by date
|Next:||From: Edoardo Ceccarelli||Date: 2004-04-21 16:23:12|
|Subject: Re: slow seqscan|
|Previous:||From: Dave Cramer||Date: 2004-04-21 15:05:31|
|Subject: Re: Wierd context-switching issue on Xeon|