> 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.
Have you vacuum analyzed that table? Maybe the statistics still think a
table scan is the best option?
In response to
- uh-oh at 2006-06-11 21:03:13 from Tom Allison
- Re: uh-oh at 2006-06-12 10:17:41 from Tom Allison
pgsql-novice by date
|Next:||From: Christopher Browne||Date: 2006-06-12 05:29:34|
|Subject: Re: uh-oh|
|Previous:||From: Jaime Casanova||Date: 2006-06-11 21:40:10|
|Subject: Re: SQL comments|