Postgresql search

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

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] Google Code Archive - Long-term storage for Google Code Project Hosting.


Roderick van Domburg