"Net Virtual Mailing Lists" <[EMAIL PROTECTED]>(by way of Net Virtual Mailing Lists
<[EMAIL PROTECTED]>) 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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
