uh-oh

From: Tom Allison <tallison(at)tacocat(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: uh-oh
Date: 2006-06-11 21:03:13
Message-ID: 448C8511.2030001@tacocat.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

  • Re: uh-oh at 2006-06-11 22:28:08 from Philip Hallstrom
  • Re: uh-oh at 2006-06-12 05:29:34 from Christopher Browne

Browse pgsql-novice by date

  From Date Subject
Next Message Jaime Casanova 2006-06-11 21:38:40 Re: SQL comments
Previous Message Tom Allison 2006-06-11 21:01:19 Re: SQL comments