On Sun, Dec 18, 2011 at 16:52, Roxanne Reid-Bennett <rox(at)tara-lu(dot)com> wrote:
> Is there an index type that can check "not equal"?
> This specific column has a limited number of possible values - it is
> essentially an enumerated list.
Instead of writing WHERE foo<>3 you could rewrite it as WHERE foo IN
(1,2,4,...) or WHERE foo < 3 OR foo > 3. Both of these are indexable
queries, but obviously the planner may choose not to use index scan if
it's not worth it.
In response to
pgsql-performance by date
|Next:||From: Roxanne Reid-Bennett||Date: 2011-12-18 20:18:49|
|Subject: Re: will the planner ever use an index when the condition
is <> ?|
|Previous:||From: Tom Lane||Date: 2011-12-18 18:31:26|
|Subject: Re: will the planner ever use an index when the condition is <> ? |