Re: About TSearch2 Performance

Поиск
Список
Период
Сортировка
От Dennis Gearon
Тема Re: About TSearch2 Performance
Дата
Msg-id 3F9934BB.5070404@fireserve.net
обсуждение исходный текст
Ответ на Re: About TSearch2 Performance  (Teodor Sigaev <teodor@sigaev.ru>)
Ответы Re: About TSearch2 Performance
Список 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 по дате отправления:

Предыдущее
От: Manfred Koizar
Дата:
Сообщение: Re: Nullable 'Foreign Key-like' Constraint
Следующее
От: Adam Witney
Дата:
Сообщение: Re: shared memory on OS X - 7.4beta4