# Postgresql search

**URL:** <https://www.ruby-forum.com/t/postgresql-search/146877>\
**Category:** Rails I18n\
**Created:** [August 26, 2008, 12:34pm UTC](https://www.ruby-forum.com/t/postgresql-search/146877 "2008-08-26T12:34:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![8bits](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/8/8edcca/32.png) [@8bits](https://www.ruby-forum.com/u/8bits)\
**Post date:** [August 26, 2008, 12:34pm UTC](https://www.ruby-forum.com/t/postgresql-search/146877/1 "2008-08-26T12:34:14Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![8bits](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/8/8edcca/32.png) [@8bits](https://www.ruby-forum.com/u/8bits)\
**Post date:** [October 27, 2008, 7:34pm UTC](https://www.ruby-forum.com/t/postgresql-search/146877/2 "2008-10-27T19:34:14Z")

</div>

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.](http://code.google.com/p/acts-as-tsearch/)

–  
Roderick van Domburg

> **[De domeinnaam Nedforce.nl is te koop.](http://www.nedforce.nl)**
>
> Deze mooie domeinnaam kan al over een paar minuten van jou zijn. Betalen gaat eenvoudig en vertrouwd via iDEAL. Direct na de betaling ontvang je de verhuiscode per e-mail en kun je aan de slag.