Re: FTI is really really slow; what am I doing wrong?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Paul C(dot)" <ulive1x(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: FTI is really really slow; what am I doing wrong?
Date: 2001-08-22 15:44:59
Message-ID: 20010822104459.A14251@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-08-22 15:54:43 Re: Join questions
Previous Message Andrew Gould 2001-08-22 15:41:27 Re: During dump: function not found