On Tue, Nov 16, 2004 at 03:55:58PM +0100, Herv Piedvache wrote:
> WHERE s.idx_site_name @@ to_tsquery('atari');
How much text does each site_name field contain? From the field
name I'd guess only a few words. Based on my own experience, if
the fields were documents containing thousands of words then I'd
expect tsearch2 to be faster than ILIKE by an order of magnitude
or more.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/