Re: website doc search is extremely SLOW

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: website doc search is extremely SLOW
Date: 2004-01-04 19:40:32
Message-ID: 1639e816e7a49f67ff69f184b69d690c@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> I keep searching the web hoping someone has come up with a 'tsearch2'
> based search engine that does the spidering, but, unless its sitting right
> in front of my eyes and I'm not seeing it, I haven't found it yet :(

I wrote my own search engine for the docs back when the site was having
problems last year, and myself and some others needed a searchable
interface. It actually spidered the raw sgml pages themselves, and was
fairly quick. I can resurrect this if anyone is interested. It runs
with Perl and PostgreSQL and nothing else. :) Of course, it could probably
be modified to feed it's sgml parsing output to tsearch as well.

In the meantime, could we please switch to a simple google search? It
would require changing one or two lines of HTML source, and at least
there would be *something* until we get everything sorted out.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200401041439

-----BEGIN PGP SIGNATURE-----

iD8DBQE/+GwIvJuQZxSWSsgRAkOgAJ9lmXwd/h/d+HzPiaPUVvO/Gq1O9wCeNbmn
CidSrTYP0sc5pp/hdlIS19o=
=YPWw
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2004-01-04 20:02:17 Re: website doc search is extremely SLOW
Previous Message Tom Lane 2004-01-04 19:26:57 Re: GetLastInsertID ?