pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mitch Vincent <mitch@venux.net>
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Dilema.
Date: Fri, 10 Dec 1999 18:10:40 -0500
Message-ID: <21965.944867440@sss.pgh.pa.us> (raw)
In-Reply-To: <00a201bf4356$a1640b80$0300000a@doot.org>

"Mitch Vincent" <mitch@venux.net> writes:
> Also feel free to suggest some kind of indexing system for the flat files,

Glimpse, http://glimpse.cs.arizona.edu/

If you are trying for a full-text index over a large amount of text,
Postgres is really not the right tool --- we don't have the right kind
of index support for searching for individual words/phrases within text
fields.  You can fake it with LIKE or regexp matches but performance
will be awful, because the searches will have to scan the whole database.
(There is code that partially addresses this in contrib/fulltextindex,
but performance will still be nothing to write home about.)

Much better to use something that's actually designed for the purpose.
Glimpse is a really nice tool: speedy, and its index files are quite
small.  I've used it for years to keep full-text indexes of all my
files.

			regards, tom lane



view thread (5+ messages)  latest in thread

Message-ID: <21965.944867440@sss.pgh.pa.us>
Permalink:  ../21965.944867440@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/21965.944867440@sss.pgh.pa.us

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us, mitch@venux.net
  Subject: Re: [SQL] Dilema.
  In-Reply-To: <21965.944867440@sss.pgh.pa.us>
  References: <00a201bf4356$a1640b80$0300000a@doot.org> <21965.944867440@sss.pgh.pa.us>

* 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