Forum: Rails I18n Postgresql search

Posted by Nick Leichty (ocee)
on 2008-08-26 12:34
What do you think is the best plugin to make a heavily-trafficked
postgre database searchable?
Posted by Roderick van Domburg (roderickvd)
on 2008-10-27 19:34
Hi Nick,

> What do you think is the best plugin to make a heavily-trafficked
> postgre database searchable?

UltraSphinx is fast and support PostgreSQL. That speed comes at some 
cost in terms of functionality. If you require real-time index updates 
then Ferret may be the only route to go.

If your requirements allow and you can use PostgreSQL full-text 
indexing, perhaps combined with acts_as_tsearch [1], then that should be 
a great option too in terms of performance.

[1] http://code.google.com/p/acts-as-tsearch/

--
Roderick van Domburg
http://www.nedforce.nl
Please log in before posting. Registration is free and takes only a minute.
Existing account (Switch to SSL-encrypted connection)
NEW: Do you have a Google/GoogleMail or Yahoo account? No registration required!
Log in with Google account | Log in with Yahoo account
No account? Register here.