| 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: | Whole Thread | Raw Message | 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
| 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? |