Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id E86D79FB865 for ; Mon, 26 Feb 2007 17:31:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 32467-06 for ; Mon, 26 Feb 2007 17:31:05 -0400 (AST) X-Greylist: delayed 00:06:38.981302 by SQLgrey-1.7.4 Received: from xena.bway.net (xena.bway.net [216.220.96.26]) by postgresql.org (Postfix) with ESMTP id E07CF9FB883 for ; Mon, 26 Feb 2007 17:31:04 -0400 (AST) Received: (qmail 26472 invoked by uid 0); 26 Feb 2007 21:24:24 -0000 Received: from unknown (HELO white.nat.fasttrackmonkey.com) (216.220.116.154) by smtp.bway.net with (DHE-RSA-AES256-SHA encrypted) SMTP; 26 Feb 2007 21:24:24 -0000 Date: Mon, 26 Feb 2007 16:24:12 -0500 (EST) From: Charles Sprickman X-X-Sender: spork@white.nat.fasttrackmonkey.com To: Madison Kelly cc: pgsql-performance@postgresql.org Subject: Re: Writting a "search engine" for a pgsql DB In-Reply-To: <45E30ADA.2050700@alteeve.com> Message-ID: References: <45E30ADA.2050700@alteeve.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200702/312 X-Sequence-Number: 23366 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 >