Re: Writting a "search engine" for a pgsql DB

Charles Sprickman <spork@bway.net>

From: Charles Sprickman <spork@bway.net>
To: Madison Kelly <linux@alteeve.com>
Cc: pgsql-performance@postgresql.org
Date: 2007-02-26T21:24:12Z
Lists: 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
>