Re: optimizer choosing the wrong index

Adrian von Bidder <avbidder@fortytwo.ch>

From: Adrian von Bidder <avbidder@fortytwo.ch>
To: pgsql-general@postgresql.org
Date: 2010-07-08T19:23:06Z
Lists: pgsql-general
Heyho!

On Wednesday 07 July 2010 13.42:59 Martin Below wrote:
> I'm facing a strange problem where the optimizer does pick the wrong
> index.

What's not clear to me is why you want pg to chose a particular index.  Are 
you having performance issues? (The case you show is a table with 200k rows 
- this doesn't look like very much.)

cheers
-- vbi

-- 
Verbing weirds language.
        -- Calvin & Hobbes