Re: [GENERAL] Text Databases

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Nicholas Humfrey <nhumfrey(at)poboxes(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Text Databases
Date: 1998-12-04 14:55:41
Message-ID: Pine.BSF.4.05.9812041054010.13885-100000@thelab.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message The Hermit Hacker 1998-12-04 14:57:24 Re: [GENERAL] Can PostgreSQL handle this?
Previous Message Tom Werges 1998-12-04 14:35:51 Re: [GENERAL] Perl DBD / DBI modules