Re: Writting a "search engine" for a pgsql DB - Mailing list pgsql-performance

From Charles Sprickman
Subject Re: Writting a "search engine" for a pgsql DB
Date
Msg-id Pine.OSX.4.64.0702261551070.289@white.nat.fasttrackmonkey.com
Whole thread Raw
In response to Writting a "search engine" for a pgsql DB  (Madison Kelly <linux@alteeve.com>)
Responses Re: Writting a "search engine" for a pgsql DB  (Magnus Hagander <magnus@hagander.net>)
List pgsql-performance
On Mon, 26 Feb 2007, Madison Kelly wrote:

> Hi all,
>
> I'd really like to come up with a more intelligent search engine that doesn't
> take two minutes to return results. :) I know, in the end good indexes and
> underlying hardware will be important, but a sane as possible query structure
> helps to start with.

I'm not a programmer, so I can't comment on how good of an example this
is, but I've been pretty happy with mnogosearch:

http://www.mnogosearch.com/

The *nix versions are free.  Looking at the db structure gave me a bit of
an idea of what I'm guessing is the "right way" to search a huge amount of
documents.

Charles

>  Thanks all!!
>
> Madison
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>              http://archives.postgresql.org
>

pgsql-performance by date:

Previous
From: Ron
Date:
Subject: Re: Vacuumdb - Max_FSM_Pages Problem.
Next
From: Jeff Davis
Date:
Subject: Re: Two hard drives --- what to do with them?