Re: Unused indices

Benjamin Krajmalnik wrote:
>
>
> Index Scans 0
>
> Index Tuples Read 0
>
> Index Tuples Fetched 0
>
> Index Blocks Read 834389
>
> Index Blocks Hit 247283300
>
> Index Size 1752 kB
>
>
>
>
>
> Since there are no index scans, would it be safe to remove this one?
>

Yes. The block usage you're seeing there reflects the activity from
maintaining the index. But since it isn't ever being used for queries,
with zero scans and zero rows it's delivered to clients, it's not doing
you any good. Might as well reclaim your 1.7MB of disk space and reduce
overhead by removing it.

--
Greg Smith 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books