Re: Optimizing a complex query (long) - Mailing list pgsql-general

From Paulo Jan
Subject Re: Optimizing a complex query (long)
Date
Msg-id 3BDD849D.7B36E022@digital.ddnet.es
Whole thread Raw
In response to Optimizing a complex query (long)  (Paulo Jan <admin@digital.ddnet.es>)
List pgsql-general

Tom Lane wrote:
>
> Paulo Jan <admin@mail.ddnet.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.

pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: psql and HTML
Next
From: Pedro Alves
Date:
Subject: Running vacuum on cron