Received: from charon.simplot.com (jrsmailhub.simplot.com [12.18.144.212]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fADLkCm52330 for ; Tue, 13 Nov 2001 16:46:12 -0500 (EST) (envelope-from earlj@xanadu.simplot.com) Received: from xanadu.simplot.COM (151.113.0.132) by charon.simplot.com (MX V5.1-A AnGp) with SMTP; Tue, 13 Nov 2001 14:46:13 -0700 Received: from npa01zz001.simplot.com by xanadu.simplot.COM; (5.65v4.0/1.1.8.2/20Aug97-1116AM) id AA13143; Tue, 13 Nov 2001 14:46:12 -0700 Received: from earlj by npa01zz001.simplot.com with local (Exim 3.32 #1 (Debian)) id 163lNi-00007g-00; Tue, 13 Nov 2001 14:46:10 -0700 To: Jocelyn Callier CC: pgsql-sql@postgresql.org Subject: Re: Full text search References: <3BF18208.7040000@vdl2.ca> From: Jason Earl Date: 13 Nov 2001 14:46:08 -0700 In-Reply-To: <3BF18208.7040000@vdl2.ca> Message-ID: <87snbijqe7.fsf@npa01zz001.simplot.com> Lines: 37 User-Agent: Gnus/5.0808 (Gnus v5.8.8) Emacs/21.1 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200111/175 X-Sequence-Number: 5559 You might want to take a look at 7.2 new tsearch module. It sounds like precisely what you are looking for. http://openfts.sourceforge.net/ It's what the PostgreSQL project is using to index their mailing lists. Check out fts.postgresql.org for a nifty demonstration. Jason Jocelyn Callier writes: > 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 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org