Re: PostgreSQL search engine (Perl) - Mailing list pgsql-general

From Marc G. Fournier
Subject Re: PostgreSQL search engine (Perl)
Date
Msg-id 20020531112417.H2522-100000@mail1.hub.org
Whole thread Raw
In response to Re: PostgreSQL search engine (Perl)  (Anders Nielsen <anders@visator.com>)
List pgsql-general
What kind of hardware resources do you have it sitting on?  CPUs, memory,
disks?

On Fri, 31 May 2002, Anders Nielsen wrote:

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>


pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: www.postgresql.org search not working
Next
From: Tom Lane
Date:
Subject: Re: How to rebuild tables