On Oct 31, 2006, at 13:04 , Leif Mortenson wrote:
> Hello,
> I have been having a problem with the following query ignoring an
> index
> on the foos.bar column.
>
> SELECT c.id
> FROM foos c, bars r
> WHERE r.id != 0
> AND r.modified_time > '2006-10-20 10:00:00.000'
> AND r.modified_time <= '2006-10-30 15:20:00.000'
> AND c.bar = r.id
<snip />
> Having a column containing large numbers of null or 0 values seems
> fairly
> common. Is there way to tell Postgres to create an index of all
> values with
> meaning. Ie all non-0 values? None that I could find.
Try
create index foo_non_zero_bar_index on foos(bar) where bar <> 0;
Take a look on the docs on partial indexes for more information.
http://www.postgresql.org/docs/current/interactive/indexes-partial.html
Hope this helps.
Michael Glaesemann
grzm seespotcode net