Re: Full text search

Jocelyn,

> Is there another tip to make the search faster ? Something like
> automatic indexation of words when insering the text ? Or, I don't
> know,
> optimization stuff... ?

Unfortunately, Postgres does not currently have a "full text index"
feature. I've had an idea how to write one for some time, but haven't
had the budget. If anyone wants to fund it ...

However, there are some things you can do immediately:
1. Put the e-mail messages in their own table, seperate from the header
information. Then move that table to a seperate drive so that that
drive can be devoted to only searching e-mail text. (This assumes
you're not already using SCSI RAID)
2. Add lots more RAM and increase the sort_mem setting in
postgresql.conf. Also the number and size of WAL_FILES (see Techdocs).
3. Alternatively, you can store your e-mails as files and use a
3rd-party full text indexing product. There are several of these on
Sourceforge/Freshmeat. However, since that means moving the text our of
the database, it may not improve things for you much.

-Josh Berkus

>
> Any help would be appreciate.
>
> Thanks.
>
> --------------
> Jocelyn Callier
> callier(at)vdl2(dot)ca
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco