| 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: | Whole Thread | Raw Message | 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
| 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? |