On Tue, 16 Nov 2004, Joshua D. Drake wrote:
Well there are a couple of reasons but the easiest one is index size.or more.
Yes site name ... is company names or web site name ... so not many word in each record ... but I don't understand why more words are more efficient than few words ?? sorry ...
An ILIKE btree index is in general going to be much smaller than a gist index.
The smaller the index the faster it is searched.
for single word queries @@ should have the same performance as ilike with index disabled and better for complex queries.
Sincerely,
Joshua D. Drake
Regards,
Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster