Full text search - Mailing list pgsql-sql

From Jocelyn Callier
Subject Full text search
Date
Msg-id 3BF18208.7040000@vdl2.ca
Whole thread Raw
Responses Re: Full text search  ("Josh Berkus" <josh@agliodbs.com>)
Re: Full text search  (Jason Earl <jason.earl@simplot.com>)
List pgsql-sql
Hi all.
I'm using Postgres 7.1 to store emails archives. I want to perform a 
full text search in emails' contents. Emails' content can be quite big 
(up to 15000 characters). I've already seen that Regex match function 
'~' is way faster than the classical sql 'LIKE' function.

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... ?

Any help would be appreciate.

Thanks.

--------------
Jocelyn Callier
callier@vdl2.ca




pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: how do I update or insert efficently in postgres
Next
From: Tom Lane
Date:
Subject: Re: how do I update or insert efficently in postgres