From: Greg Smith <greg@2ndquadrant.com>
To: Benjamin Krajmalnik <kraj@servoyant.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Unused indices
Date: Wed, 23 Feb 2011 16:17:16 -0500
Message-ID: <4D65795C.20404@2ndquadrant.com> (raw)
In-Reply-To: <F4E6A2751A2823418A21D4A160B689887B0F8E@fletch.stackdump.local>
References: <F4E6A2751A2823418A21D4A160B689887B0F8E@fletch.stackdump.local>
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@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: greg@2ndquadrant.com, kraj@servoyant.com
Subject: Re: Unused indices
In-Reply-To: <4D65795C.20404@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox