Re: [GENERAL] Database-based alternatives to tsearch2?

2006-12-12 Thread Daniel Verite
Wes wrote: > I've seen questions asked on the list about alternatives to tsearch2, but > not for the type of full text indexing I'm looking for. > > I'm looking for a non index-based full text indexing - one that stores the > information as table data instead of index data. I do not need

Re: [GENERAL] Database-based alternatives to tsearch2?

2006-12-12 Thread Richard Huxton
Wes wrote: Indexes are too fragile. Our documents will be offline, and re-indexing would be impossible. Additionally, as I undertstand it, tsearch2 doesn't scale to the numbers I need (hundreds of millions of documents). Jeff's right about tsvector - sounds like it's what you're looking for.

Re: [GENERAL] Database-based alternatives to tsearch2?

2006-12-12 Thread Jeff Davis
On Tue, 2006-12-12 at 12:19 -0600, Wes wrote: > I'm looking for a non index-based full text indexing - one that stores the > information as table data instead of index data. I do not need to implement > SQL operators for searches. The application library would need to implement > the actual word

[GENERAL] Database-based alternatives to tsearch2?

2006-12-12 Thread Wes
I've seen questions asked on the list about alternatives to tsearch2, but not for the type of full text indexing I'm looking for. I'm looking for a non index-based full text indexing - one that stores the information as table data instead of index data. I do not need to implement SQL operators fo