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

"Net Virtual Mailing Lists" (by way of Net Virtual Mailing Lists ) 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