Re: [GENERAL] Text Databases - Mailing list pgsql-general

From The Hermit Hacker
Subject Re: [GENERAL] Text Databases
Date
Msg-id Pine.BSF.4.05.9812041054010.13885-100000@thelab.hub.org
Whole thread Raw
In response to Re: [GENERAL] Text Databases  (Nicholas Humfrey <nhumfrey@poboxes.com>)
Responses Re: [GENERAL] Text Databases  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-general
On Thu, 3 Dec 1998, Nicholas Humfrey wrote:

>
> On Wed, 2 Dec 1998, Dustin Sallings wrote:
> >it sounds like you're looking at the wrong tool for a particular job.
>
> I am trying to get the best of both worlds. A good relational database
> system as well as being able to do text searches in mutiple fields.
>
> On Thu, 3 Dec 1998, Marc G. Fournier wrote:
> >See the 'fulltextindex' directory under the contrib directory.
>
> How fast is PostgreSQL at searching for text. Should I, as Dustin Sallings
> wrote look for a different relational database system ? I like PostgreSQL's
> features especially free source code, so I can run it on different
> platforms (Sparc,PPC,i486 etc.) Is there a more suitable free system
> available ?

    From reading the README file in the fulltextindex directory, it
looks like the way they implemented it should be as fast as any other of
the indices....check the README file and see what you think...

Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org


pgsql-general by date:

Previous
From: Dmitry Iv Popov
Date:
Subject: Postgres & Java [client/server]
Next
From: The Hermit Hacker
Date:
Subject: Re: [GENERAL] Can PostgreSQL handle this?