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

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

From
The Hermit Hacker
Date:
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?

---------- 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



>
>
> 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)

free-text searching

From
Goran Thyni
Date:
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