Re: Why does a simple query not use an obvious index? - Mailing list pgsql-performance

From Greg Stark
Subject Re: Why does a simple query not use an obvious index?
Date
Msg-id 87llfxk5v6.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Why does a simple query not use an obvious index?  (Mr Pink <mr_pink_is_the_only_pro@yahoo.com>)
Responses Re: Why does a simple query not use an obvious index?
List pgsql-performance
Mr Pink <mr_pink_is_the_only_pro@yahoo.com> writes:

> AFAIK postgres doesn't peek at values used in a query when optimizing

Of course it does.

However sometimes things don't work perfectly.
To get good answers rather than just guesses we'll need two things:

. What version of postgres are you using.
. The output of EXPLAIN ANALYZE select ...

--
greg

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Equivalent praxis to CLUSTERED INDEX?
Next
From: Greg Stark
Date:
Subject: Re: Why does a simple query not use an obvious index?