Have you tried a special add-on for pgsql -
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
Lucene is faster than tsearch (I hope so), but tsearch neednot be
synchronized with the main DB...up to you.
Cheers,
Leo
Ankur Goel wrote:
Hi,
I have to search the documents which are stored
Use JCDB to connect to your DB, issue appropriate SELECTs to select
each of you entity/document units, then use the returned data to create
instances of Lucene documents, add those to the index via IndexWriter,
and you got yourself a Lucene index that represents data you have
stored in DB.
If
[mailto:[EMAIL PROTECTED]
Sent: Saturday, January 31, 2004 5:52 PM
To: Lucene Users List
Subject: Re: Lucene with Postgres db
Use JCDB to connect to your DB, issue appropriate SELECTs to select
each of you entity/document units, then use the returned data to create
instances of Lucene documents
:[EMAIL PROTECTED]
Sent: Saturday, 31 January 2004 8:10 PM
To: [EMAIL PROTECTED]
Subject: Lucene with Postgres db
Hi,
I have to search the documents which are stored in postgres db.
Can someone give a clue how to go about it?
Thanks
Ankur Goel
Brickred Technologies
B-2 IInd Floor