Database-based alternatives to tsearch2?

From: Wes <wespvp(at)syntegra(dot)com>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Database-based alternatives to tsearch2?
Date: 2006-12-12 18:19:02
Message-ID: C1A44EB6.38885%wespvp@syntegra.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 for searches. The application library would need to implement
the actual word search.

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).

Is anyone aware of any such solutions for PostgreSQL, open source or
otherwise?

Thanks

Wes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomi N/A 2006-12-12 18:29:07 Re: a question on SQL
Previous Message Richard Broersma Jr 2006-12-12 18:13:04 Re: Are updateable view as a linked table in ms-access a bad idea?