Re: Bitmap scans vs. the statistics views - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Bitmap scans vs. the statistics views
Date
Msg-id 1114213250.6004.28.camel@fuji.krosing.net
Whole thread Raw
In response to Re: Bitmap scans vs. the statistics views  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On R, 2005-04-22 at 13:46 -0700, Josh Berkus wrote:
> Tom,
> 
> Hmmm ... we need to flag *something* in pg_stat_*_indexes, whether it is a new 
> column or the tuplefetch column.   People use that view to find indexes they 
> can drop.

I think that "idx_scan" and "idx_tup_read" can have the same meaning as
for other index types, i.e. of number of scans and number of index
tuples read (and copied into bitmap).

and as idx_tup_fetch seems to be == idx_tup_read, it can be the same for
bitmap indexes as well :)

but if the view will be changed, I'd like to see column idx_pages_read
added there.

-- 
Hannu Krosing <hannu@tm.ee>


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: possible TODO: read-only tables, select from indexes
Next
From: Hannu Krosing
Date:
Subject: Re: possible TODO: read-only tables, select from indexes