From: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org> |
---|---|
To: | Anders Nielsen <anders(at)visator(dot)com> |
Cc: | 'Oleg Bartunov' <oleg(at)sai(dot)msu(dot)su>, 'Kaare Rasmussen' <kar(at)kakidata(dot)dk>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL search engine (Perl) |
Date: | 2002-05-31 14:25:16 |
Message-ID: | 20020531112417.H2522-100000@mail1.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)sai(dot)msu(dot)su]
> Sent: 31. maj 2002 13:05
> To: Anders Nielsen
> Cc: 'Kaare Rasmussen'; pgsql-general(at)postgresql(dot)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(at)kakidata(dot)dk]
> > Sent: 31. maj 2002 12:57
> > To: pgsql-general(at)postgresql(dot)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 Lrdag 11.00-17.00 Email: kar(at)kakidata(dot)dk
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)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(at)sai(dot)msu(dot)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(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-05-31 14:29:57 | Re: How to rebuild tables |
Previous Message | Marc G. Fournier | 2002-05-31 14:22:47 | Re: www.postgresql.org search not working |