Re: The old "not using index" question

From: Hubert depesz Lubaczewski <depesz(at)depesz(dot)pl>
To: Jan-Philipp 'Thefly' Reining <jpr(at)turtle-entertainment(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: The old "not using index" question
Date: 2002-11-30 00:20:01
Message-ID: 20021130002001.GA10734@depesz.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Nov 29, 2002 at 05:37:04PM +0100, Jan-Philipp 'Thefly' Reining wrote:
> ---but this one does not?
> SELECT *
> FROM ttm_slots s
> WHERE s.peering = 72
> AND s.ranking < 1050
> AND s.ranking > 950
>
> The index ist "btree", so it should be able to use the index with a < >
> comparison?

show us explain analyze output.
probably planner thinks there are too many rows matching this criteria
to use index.

depesz

--
hubert depesz lubaczewski http://www.depesz.pl/
------------------------------------------------------------------------
Mój Boże, spraw abym milczał, dopóki się nie upewnię, że naprawdę mam
coś do powiedzenia. (c) 1998 depesz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philip Warner 2002-11-30 00:45:20 Re: 7.4 Wishlist
Previous Message Hubert depesz Lubaczewski 2002-11-30 00:11:13 strange pg_stats behaviour?