From: Josh Berkus <josh@agliodbs.com>
To: Jocelyn Callier <callier@vdl2.ca>
To: pgsql-sql@postgresql.org
Subject: Re: Full text search
Date: Tue, 13 Nov 2001 13:33:27 -0800
Message-ID: <web-505322@davinci.ethosmedia.com> (raw)
In-Reply-To: <3BF18208.7040000@vdl2.ca>
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@vdl2.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@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, callier@vdl2.ca
Subject: Re: Full text search
In-Reply-To: <web-505322@davinci.ethosmedia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox