Skip site navigation (1) Skip section navigation (2)

Re: uh-oh

From: Philip Hallstrom <postgresql(at)philip(dot)pjkh(dot)com>
To: Tom Allison <tallison(at)tacocat(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: uh-oh
Date: 2006-06-11 22:28:08
Message-ID: 20060611172745.K95440@bravo.pjkh.com (view raw or flat)
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.

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

Responses

  • Re: uh-oh at 2006-06-12 10:17:41 from Tom Allison

pgsql-novice by date

Next:From: Christopher BrowneDate: 2006-06-12 05:29:34
Subject: Re: uh-oh
Previous:From: Jaime CasanovaDate: 2006-06-11 21:40:10
Subject: Re: SQL comments

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group