Re: website doc search is extremely SLOW

Поиск
Список
Период
Сортировка
Искать
От
Marc G. Fournier
Тема
Re: website doc search is extremely SLOW
Дата
Msg-id
20031231181039.I42809@ganymede.hub.org
Ответ на
Список
Дерево обсуждения
Re: website doc search is extremely SLOW "ezra epstein" <ee_newsgroup_post@prajnait.com>
Re: website doc search is extremely SLOW "Marc G. Fournier" <scrappy@postgresql.org>
Re: website doc search is extremely SLOW Dave Cramer <pg@fastcrypt.com>
Re: website doc search is extremely SLOW Mark Kirkwood <markir@paradise.net.nz>
Re: website doc search is extremely SLOW Tom Lane <tgl@sss.pgh.pa.us>
Re: website doc search is extremely SLOW "Marc G. Fournier" <scrappy@postgresql.org>
Re: website doc search is extremely SLOW Oleg Bartunov <oleg@sai.msu.su>
On Tue, 30 Dec 2003, Joshua D. Drake wrote:

> Hello,
>
>  Why are we not using Tsearch2?

Because nobody has built it yet?  Oleg's stuff is nice, but we want
something that we can build into the existing web sites, not a standalone
site ...

I keep searching the web hoping someone has come up with a 'tsearch2'
based search engine that does the spidering, but, unless its sitting right
in front of my eyes and I'm not seeing it, I haven't found it yet :(

Out of everything I've found so far, mnogosearch is one of the best ... I
just wish I could figure out where the bottleneck for it was, since, from
reading their docs, their method of storing the data doesn't appear to be
particularly off.  I'm tempted to try their caching storage manager, and
getting away from SQL totally, but I *really* want to showcase PostgreSQL
on this :(

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
В списке pgsql-general по дате отправления
От: Chris Ochs
Дата:
Сообщение: speeding up inserts
От: Bruce Momjian
Дата:
FAQ