Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 0F27D9FB9B0 for ; Tue, 27 Feb 2007 09:34:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 82944-01-8 for ; Tue, 27 Feb 2007 09:33:59 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from developer.pgadmin.org (developer.pgadmin.org [63.246.23.140]) by postgresql.org (Postfix) with ESMTP id 82A4C9FB9C9 for ; Tue, 27 Feb 2007 09:34:04 -0400 (AST) Received: from [172.24.32.71] ([62.232.55.118]) (authenticated bits=0) by developer.pgadmin.org (8.13.8/8.13.8) with ESMTP id l1RD7K9Z028453 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 27 Feb 2007 13:07:21 GMT Message-ID: <45E4333B.9020008@postgresql.org> Date: Tue, 27 Feb 2007 13:33:47 +0000 From: Dave Page User-Agent: Thunderbird 1.5.0.9 (Macintosh/20061207) MIME-Version: 1.0 To: Magnus Hagander CC: Charles Sprickman , Madison Kelly , pgsql-performance@postgresql.org Subject: Re: Writting a "search engine" for a pgsql DB References: <45E30ADA.2050700@alteeve.com> <20070227131558.GP12721@svr2.hagander.net> In-Reply-To: <20070227131558.GP12721@svr2.hagander.net> X-Enigmail-Version: 0.94.1.2 OpenPGP: url=http://www.pgadmin.org/pgp/davepage.pgp Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/320 X-Sequence-Number: 23374 Magnus Hagander wrote: > > Just as a datapoint, we did try to use mnogosearch for the > postgresql.org website+archives search, and it fell over completely. > Indexing took way too long, and we had search times several thousand > times longer than with tsearch2. > > That said, I'm sure there are cases when it works fine :-) There are - in fact before your time the site did use Mnogosearch. We moved to our own port of ASPSeek when we outgrew Mnogo's capabilities, and then to your TSearch code when we outgrew ASPSeek. When we outgrow PostgreSQL & Tsearch2, then, well, we'll need to stop pretending to be Google... /D