Home > mailing lists

Re: will the planner ever use an index when the condition is <> ? - Mailing list pgsql-performance

From	Віталій Тимчишин
Subject	Re: will the planner ever use an index when the condition is <> ?
Date	December 18, 2011 09:41:35
Msg-id	CABWW-d1r9Doya=ntE5U+5o8Hj2W0WuiKvNeYsEyEecaj4mb=fg@mail.gmail.com Whole thread Raw
In response to	Re: will the planner ever use an index when the condition is <> ? (Filip Rembiałkowski <plk.zuber@gmail.com>)
List	pgsql-performance

Tree view

17.12.2011 18:25 пользователь "Filip Rembiałkowski" <plk.zuber@gmail.com> написал:
>
> Normally there is no chance it could work,
> because (a) the planner does not know all possible values of a column,
> and (b) btree indexes cannot search on "not equal" operator.
>

Why so? a<>b is same as (a<b or a>b), so, planner should chech this option.

pgsql-performance by date:

From: Filip Rembiałkowski
Date: 17 December 2011, 15:24:56
Subject: Re: will the planner ever use an index when the condition is <> ?

From: Roxanne Reid-Bennett
Date: 18 December 2011, 13:56:59
Subject: Re: will the planner ever use an index when the condition is <> ?

Re: will the planner ever use an index when the condition is <> ? - Mailing list pgsql-performance

Previous

Next