Re: optimizer choosing the wrong index

From: Adrian von Bidder <avbidder(at)fortytwo(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: optimizer choosing the wrong index
Date: 2010-07-08 19:23:06
Message-ID: 201007082123.14856@fortytwo.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Maclean 2010-07-08 20:42:58 Re: Problems with Vista and Windows 7
Previous Message Susan Cassidy 2010-07-08 18:58:51 weird empty return from select problem; periodically get no data returned - could it be a network issue?