Fastest way to drop an index?

From: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Fastest way to drop an index?
Date: 2009-02-03 12:18:58
Message-ID: e373d31e0902030418h4c029595ubc89abfdd804b5f7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a table with two fields:

user_id
col2

There is quite a pivotal SQL for our site that issues the query:

...WHERE user_id = 'xyz' and col2 = 'xyz'

Until now, I have had two indexes, one for user_id and one for col2.

Now, I built a compound index concurrently (user_id, col2). After an
error the previous, this has now built, but the query above is still
using individual indexes of olden times.

So I want to drop the index on col2 alone. (Col2 is never used by
itself, so no use keeping the index. We only created it originally
because an index on this field alone would be smaller than a compound
index, and because PG manual said individual indexes tend to work
better.)

But when I try to drop the col2 index, it takes forever, and eats up a
lot of memory to the extent that all other stuff stops. Why should
dropping an index be so tedious?

Would appreciate any thoughts on this. Thanks!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Katson 2009-02-03 12:21:01 dict-xsyn converts word to synlist, what about backwards?
Previous Message Oleg Bartunov 2009-02-03 12:15:48 Re: Full text index not being used