Re: [GENERAL] About TSearch2 Performance

[Teodor Sigaev]

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: [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly