Yes, you are right. I now tried to select from one table various amount of
records and when the amount exceeded some given number so the blks_hit begun
fall.
Thanks,
David Hoksza
________________________________
30. července 2006, 20:24:33, napsal jste:
TL> David Hoksza <david.hoksza@seznam.cz> writes:
>> Hi, I'm not sure about the value idx_blks_hit of pg_statio_all_indexes
>> view. Is it total value of touched pages, or do I get total value when
>> I add idx_blks_read to it?
>> In other words - does idx_blks_hit cover also physical reads?
TL> I believe blks_hit is the number of page requests that were found in
TL> cache and hence did *not* require a read(). The other column is the
TL> number of page requests that *did* require a read().
TL> regards, tom lane