Re: About TSearch2 Performance - Mailing list pgsql-general

From Dennis Gearon
Subject Re: About TSearch2 Performance
Date
Msg-id 3F9934BB.5070404@fireserve.net
Whole thread Raw
In response to Re: About TSearch2 Performance  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: About TSearch2 Performance  ("Andrew J. Kopciuch" <akopciuch@olympusproject.org>)
List pgsql-general
Teodor Sigaev wrote:

> 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,
>>
>
What do those @@ do for the statement?

--
"You are behaving like a man",
is an insult from some women,
a compliment from an good woman.



pgsql-general by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: Nullable 'Foreign Key-like' Constraint
Next
From: Adam Witney
Date:
Subject: Re: shared memory on OS X - 7.4beta4