uh-oh - Mailing list pgsql-novice

From Tom Allison
Subject uh-oh
Date
Msg-id 448C8511.2030001@tacocat.net
Whole thread Raw
Responses Re: uh-oh  (Philip Hallstrom <postgresql@philip.pjkh.com>)
List pgsql-novice
I think I screwed up.

I was running something in the background to update a table based on the jobs
output (once every 1-10 seconds) and while that was running I created an index
on the same table.

Now that index is not used according to explain plans.
It does show up when I type '\di'
But I can't DROP INDEX.

I think I'm in some trouble but I don't know how much.

pgsql-novice by date:

Previous
From: Tom Allison
Date:
Subject: Re: SQL comments
Next
From: "Jaime Casanova"
Date:
Subject: Re: SQL comments