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.