Re: Writting a "search engine" for a pgsql DB
Dave Page <dpage@postgresql.org>
From: Dave Page <dpage@postgresql.org>
To: Magnus Hagander <magnus@hagander.net>
Cc: Charles Sprickman <spork@bway.net>, Madison Kelly <linux@alteeve.com>, pgsql-performance@postgresql.org
Date: 2007-02-27T13:33:47Z
Lists: pgsql-performance
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