pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Martin Foster <martin@ethereal-realms.org>
To: pgsql-performance@postgresql.org
Subject: Cleaning up indexes
Date: Thu, 23 Sep 2004 22:16:28 GMT
Message-ID: <0XH4d.41061$yW6.30251@clgrps12> (raw)

My database was converted from MySQL a while back and has maintained all 
of the indexes which were previously used.   Tt the time however, there 
were limitations on the way PostgreSQL handled the indexes compared to 
MySQL.

Meaning that under MySQL, it would make use of a multi-column index even 
if the rows within did not match.    When the conversion was made more 
indexes were created overall to correct this and proceed with the 
conversion.

Now the time has come to clean up the used indexes.   Essentially, I 
want to know if there is a way in which to determine which indexes are 
being used and which are not.   This will allow me to drop off the 
unneeded ones and reduce database load as a result.

And have things changed as to allow for mismatched multi-column indexes 
in version 7.4.x or even the upcoming 8.0.x?

	Martin Foster
	martin@ethereal-realms.org



view thread (3+ messages)  latest in thread

Message-ID: <0XH4d.41061$yW6.30251@clgrps12>
Permalink:  ../0XH4d.41061$yW6.30251@clgrps12/
Also on:    postgresql.org/message-id/0XH4d.41061$yW6.30251@clgrps12

 · 

reply

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: martin@ethereal-realms.org
  Subject: Re: Cleaning up indexes
  In-Reply-To: <0XH4d.41061$yW6.30251@clgrps12>

* 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