Re: YOUR SITES SEARCH FEATURE DOES NOT WORK! - Mailing list pgsql-admin

From Ang Chin Han
Subject Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!
Date
Msg-id 3F5873C7.8050107@bytecraft.com.my
Whole thread Raw
In response to Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!  ("Marc G. Fournier" <scrappy@hub.org>)
Responses Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-admin
Marc G. Fournier wrote:
> okay, first off ... what URL?  I've been working on, and testing, archives
> all week, and altho getting things down below a 2min search appears to be
> near impossible (anyone know something *better* then mnogosearch that will
> handle >250k URLs and growing ... ?  we tried ht/Dig before, and the
> resources it suck'd were outrageous) ...

(I assume we're talking about the email archives).

How about a quick and dirty script (perl, maybe) that grabs everything,
"intelligently" chucks the pseudo contents (stripping message quotes for
instance) into a pgsql table, and then see if tsearchv2 can be used to
search it via another quick and dirty CGI? Have to find some place to
host it though, the db might be huge.

Eating our own dog food and all that.

--
Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386
GNU/Linux
   6:30pm  up 253 days,  9:51,  5 users,  load average: 5.00, 5.00, 5.00

Attachment

pgsql-admin by date:

Previous
From: Andreas Schmitz
Date:
Subject: Re: Blob Data type in postgres ?
Next
From: "Jouneau Luc"
Date:
Subject: Re: Blob Data type in postgres ?