Re: About TSearch2 Performance

First one will be a bit faster

Diogo Biazus wrote:
> Hi,
>
> Is there any performance diference between the following SQL commands:
>
> SELECT * FROM documents WHERE content_ix @@
> to_tsquery('word1&word2|word3');
>
> SELECT * FROM documents WHERE content_ix @@ to_tsquery('word1') AND
> content_ix @@ to_tsquery('word2') OR content_ix @@ to_tsquery('word3');
>
> I'm having to do this on some complex querys to put LIKEs between some
> ts_querys.
> Does anyone has such experience?
>
> Thanks in advance,
>

--
Teodor Sigaev                                  E-mail: teodor@sigaev.ru