Re: Optimizing a complex query (long)

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.