[elephant-devel] full text indexing

[Gábor Melis]

There are 100k users in the db. Each user has a description string. I need to 
search users for words in their descriptions by prefix. Currently I lean 
towards simply maintaining a reverse word->oid index in a btree. Searching 
this is easy, but whenever a description changes the old mapping entries for 
that oid need to be deleted and the new ones added. Has any of you 
implemented such a scheme or have other ideas?

Cheers, Gábor