Re: Index problem.... GIST (tsearch2)

"Net Virtual Mailing Lists" <mailinglists(at)net-virtual(dot)com>(by way of Net Virtual Mailing Lists <mailinglists(at)net-virtual(dot)com>) writes:

> >SELECT * from sometable WHERE category1 IS NOT NULL
> > AND data_fti @@ to_tsquery('default', 'postgres');

What you can do is a partial index:

create index fulltextindex on sometable (...) WHERE category1 IS NOT NULL

This is even better than the is_null() index because it will still be able to
do the full text search. However note that having three entire full text
indexes is going to consume a lot of space and incur a lot of disk i/o
overhead to maintain.

--
greg