Skip site navigation (1) Skip section navigation (2)

disused indexes and performance?

From: Elisa <elisa(dot)derickson(at)shoutlet(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: disused indexes and performance?
Date: 2011-10-19 15:24:00
Message-ID: 75c4e21a-0010-49f2-8670-d00d9e584f7e@h14g2000yqi.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-performance
I recently ran a query against our production database and saw several
disused indexes.  Is there a performance harm in having disused
indexes out there?

Of course, I will be checking our code base and with developers to
ensure that these indexes aren't being used programmatically to
prevent redundant inserts and the like. ..

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2011-10-19 15:44:39
Subject: Re: How many Cluster database on a single server
Previous:From: Kevin GrittnerDate: 2011-10-19 15:13:42
Subject: Re: How many Cluster database on a single server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group