Re: [GENERAL] pg_statio_all_indexes

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 <[EMAIL PROTECTED]

Re: [GENERAL] pg_statio_all_indexes

David Hoksza <[EMAIL PROTECTED]> 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? I believe blks_hit

Re: [GENERAL] pg_statio_all_indexes

As per my understanding, 'pg_statio_all_indexes' displays "idx_blks_hit" using "pg_stat_get_blocks_hit(oid)" where the function "pg_stat_get_blocks_hit" gets number of disk block requests found in cache for a table or index. Hope this helps...Thanks, -- Shoaib MirEnterpriseDB (www.enterprisedb.com)

[GENERAL] pg_statio_all_indexes

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? Thanks, David Hoksza ---(end of b