Hi, I implemented a full text search using postgres > 8.3. My performance is very good to index (using triggers/after_filter or crontab time based index update) and to search for something. With Postgres i can index only lexemes, other solutions, like sphinx based or aaf creates the index based in length. So everything bigger than 2/3 chars is indexed. I think to use a lexeme is better to avoid falses positives in a real world.
My questions are: - Any good reason to dont use tsearch and choose a aaf/*sphinx solution ? - There is any way to make tsearch index the text by length and not by lexeme (i know, probably this question i should ask in a postgres forum) Regards, Victor --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
