Re: [HACKERS] tsearch vs. fulltextindex

2002-08-13 Thread Christopher Kings-Lynne
MAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: [HACKERS] tsearch vs. fulltextindex > > > > Good point. Some said fulltextindex was better for certain queries, but > if no one can come up with such a case, we can remove it. > > ---

Re: [HACKERS] tsearch vs. fulltextindex

2002-08-13 Thread Bruce Momjian
Good point. Some said fulltextindex was better for certain queries, but if no one can come up with such a case, we can remove it. --- Christopher Kings-Lynne wrote: > Hi, > > I've just done some performance comparisons be

[HACKERS] tsearch vs. fulltextindex

2002-08-13 Thread Christopher Kings-Lynne
Hi, I've just done some performance comparisons between contrib/fulltextindex and contrib/tsearch. Even with every optimisation I can think of for fulltextindex, tsearch is 300 times faster ;) Plus it doesn't require a separate table or complicated queries. I think we should strongly encourage