Re: Optimizing a complex query (long)

From: Paulo Jan <admin(at)digital(dot)ddnet(dot)es>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Optimizing a complex query (long)
Date: 2001-10-29 16:32:29
Message-ID: 3BDD849D.7B36E022@digital.ddnet.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
>
> Paulo Jan <admin(at)mail(dot)ddnet(dot)es> writes:
> > The problem that I'm having is that the
> > search on text fields is too slow,
>
> The only way to make that acceptably fast is to build an index designed
> specially for text searches. A simple index will only help for queries
> like field = 'foo', not field ~ 'foo'.
>
> The contrib/fti module is one possible approach (a rather inelegant one,
> but a lot of people are using it). In 7.2 there will be a new

Umm... okay. The only problem is that, in all the FTP mirrors I looked
at, the contrib/ directory was empty. What's up?

Paulo Jan.
DDnet.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pedro Alves 2001-10-29 16:42:22 Running vacuum on cron
Previous Message Nick 2001-10-29 16:32:09 PostgresSQL 7.x Oracle8 Comparison