Re: optimizer choosing the wrong index - Mailing list pgsql-general

From Adrian von Bidder
Subject Re: optimizer choosing the wrong index
Date
Msg-id 201007082123.14856@fortytwo.ch
Whole thread Raw
In response to optimizer choosing the wrong index  (Martin Below <machtin.below@googlemail.com>)
List 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

Attachment

pgsql-general by date:

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