Re: Why does a simple query not use an obvious index?

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Mr Pink <mr_pink_is_the_only_pro(at)yahoo(dot)com>
Cc: Jack Kerkhof <jack(dot)kerkhof(at)guest-tek(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Why does a simple query not use an obvious index?
Date: 2004-08-29 21:10:37
Message-ID: 87llfxk5v6.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Mr Pink <mr_pink_is_the_only_pro(at)yahoo(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stark 2004-08-29 21:12:05 Re: Why does a simple query not use an obvious index?
Previous Message Josh Berkus 2004-08-29 18:59:01 Re: Equivalent praxis to CLUSTERED INDEX?