Re: [PORTS] Pgaccess doesn't run on -current anymore, Update (fwd)

Someone is/was talking about using PostgreSQL for the backend for this?
Basically, making the mailing list archives searchable...

We don't have free-text searching, I don't believe, but anyone have an
idea on what would be involved in having it?

Talk to Maarten Boekhold, M.Boekhold@et.tudelft.nl. I just asked him
about this because we suggested the CLUSTER change, and I wanted to get
new performance numbers. I also asked him for a copy for contrib.

I am going to add him to the TODO contrib list. I think he has
contributed patches in the past, but is not on the list.

---------- Forwarded message ----------
Date: Mon, 30 Mar 1998 09:50:48 +0100
From: Bob Bishop <rb@gid.co.uk>
To: shimon@simon-shapiro.org, Wolfram Schneider <wosch@cs.tu-berlin.de>
Cc: freebsd-database@FreeBSD.ORG, andreas@klemm.gtn.com, scrappy@hub.org,
asami@FreeBSD.ORG, Amancio Hasty <hasty@rah.star-gate.com>
Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update

At 10:57 pm +0100 29/3/98, Simon Shapiro wrote:

..
We have been playing with the idea of normalizing the archive into an
RDBMS. [etc]

Great, but to be useful you need free-text search too.

--
Bob Bishop (0118) 977 4017 international code +44 118
rb@gid.co.uk fax (0118) 989 4254 between 0800 and 1800 UK

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

On Mon, 30 Mar 1998, Simon Shapiro wrote:

On 30-Mar-98 The Hermit Hacker wrote:

On Mon, 30 Mar 1998, Simon Shapiro wrote:

On 30-Mar-98 Bob Bishop wrote:

At 10:57 pm +0100 29/3/98, Simon Shapiro wrote:

..
We have been playing with the idea of normalizing the archive into an
RDBMS. [etc]

Great, but to be useful you need free-text search too.

Yup. This is in the head-scratching stage still. I was thinking of
either
glimpse or maybe simply extracting the blob and applying regex to it.
Comments?

Just checked into it, and *supposedly* there is a free-text search
module for PostgreSQL available...

Which? Where? This is good news. Saves some headaches.

I've CC'd this into pgsql-hackers@postgresql.org ... Bruce pointed out
that Maarten(?) was working on something like this...

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

The Hermit Hacker wrote:

We don't have free-text searching, I don't believe, but anyone have an
idea on what would be involved in having it?

A new type of index splitting and indexing words
working on text and large objects would be
a good starting point.

regards,
--
---------------------------------------------
G�ran Thyni, sysadm, JMS Bildbasen, Kiruna