About TSearch2 Performance

From: Diogo Biazus <diogo(at)ikono(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: About TSearch2 Performance
Date: 2003-10-21 10:54:39
Message-ID: 3F95106F.2060302@ikono.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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,

--
Diogo Biazus
diogo(at)ikono(dot)com(dot)br
http://www.ikono.com.br

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff 2003-10-21 12:10:12 Re: lastval(seq) ?
Previous Message Oleg Bartunov 2003-10-21 10:54:14 Re: tsearch2 and aspell