Re: PostgreSQL search engine (Perl)

The problem with in-database search-engines are that they're usually tagged
on as a add-on feature and doesn't recieve the concentrated programming
effort that is required to create a high-performance full-text indexing
solution.

I'd be interested in comparing performance stats with people who use
OpenFTS, as I have a 8.5 gig fulltext Lucene index (including the indexed
text) and I am more than happy with the response times I'm seeing.

regards,
Anders Nielsen

-----Original Message-----
From: Oleg Bartunov [mailto:oleg@sai.msu.su]
Sent: 31. maj 2002 13:05
To: Anders Nielsen
Cc: 'Kaare Rasmussen'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] PostgreSQL search engine (Perl)


On Fri, 31 May 2002, Anders Nielsen wrote:

> I can recommend using the Lucene search-engine, it's in Java and it's got
> nothing to do with PostgreSQL, but it performs excellently.

main drawback of not-db-affiliated search engines is problem to access
metadata stored in db. Modern portals require a lot of such metadata,
think about authorization layer, versioning etc.
Besides that Lucene and many others like namazu (www.namazu.org)
are good enough. OpenFTS os our attempt to overcome metadata barrier.


>
> -----Original Message-----
> From: Kaare Rasmussen [mailto:kar@kakidata.dk]
> Sent: 31. maj 2002 12:57
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] PostgreSQL search engine (Perl)
>
>
> > Search the documentation does not work right now:
>
> What I was trying to find was information about full text indexing.
>
> It's supposed to be used in a search engine. But maybe someone knows a
> search engine in Perl optimized for PostgreSQL?
>
> One that works ? ;-)
>
>  --
> Kaare Rasmussen            --Linux, spil,--        Tlf:        3816 2582
> Kaki Data                tshirts, merchandize      Fax:        3816 2501
> Howitzvej 75               еben 14.00-18.00        Web:      www.suse.dk
> 2000 Frederiksberg        LЬrdag 11.00-17.00       Email: kar@kakidata.dk
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

    Regards,
        Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83