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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Feb 26, 2007 at 04:24:12PM -0500, Charles Sprickman wrote:
> 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.

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 :-)

//Magnus


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux