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