Home > mailing lists

Re: FTI is really really slow; what am I doing wrong? - Mailing list pgsql-general

From	Bruno Wolff III
Subject	Re: FTI is really really slow; what am I doing wrong?
Date	August 22, 2001 15:40:37
Msg-id	20010822104459.A14251@wolff.to Whole thread Raw
In response to	FTI is really really slow; what am I doing wrong? ("Paul C." <ulive1x@hotmail.com>)
List	pgsql-general

Tree view

I think the problem is that the indexes on the words are not usable for
regular expression matching. If the words are folded to lower case
when the index is built, then using an exact match (or even like) should
be much faster.

pgsql-general by date:

From: Peter Eisentraut
Date: 22 August 2001, 15:38:02
Subject: Re: During dump: function not found

From: Bruno Wolff III
Date: 22 August 2001, 16:04:09
Subject: Re: Join questions

Re: FTI is really really slow; what am I doing wrong? - Mailing list pgsql-general

Previous

Next