Received: from vdl2.ca (koala.vdl2.ca [199.84.183.6]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fADKVJm49873 for ; Tue, 13 Nov 2001 15:31:19 -0500 (EST) (envelope-from callier@vdl2.ca) Received: from vdl2.ca [199.84.183.4] by vdl2.ca [199.84.183.6] with SMTP (MDaemon.v2.8.5.0.R) for ; Tue, 13 Nov 2001 16:55:12 +0000 Message-ID: <3BF18208.7040000@vdl2.ca> Date: Tue, 13 Nov 2001 15:26:48 -0500 From: Jocelyn Callier User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.2) Gecko/20010726 Netscape6/6.1 X-Accept-Language: en-us MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Full text search Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-Return-Path: callier@vdl2.ca X-Archive-Number: 200111/172 X-Sequence-Number: 5556 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