Re:PostgreSQL is Engine Yard's New Default
by fdr on Thursday August 16, 2012 @03:17AM
(#4390269)
I can't give you a comparison, but for what it's worth, it is used on the Postgres documentation and mailing list archives. I mention this because you can play with it and get an intuitive sense of its performance and subjective usefulness.
It's also handy because you can combine it with relational data. For example, if you search from a manual page of a particular version of Postgres, it'll only return results from that version.
The main performance limitation is probably update/insert rate, and it doesn't has as many features as a dedicated IR-type system, but it's frequently good-enough and already present.
http://archives.postgresql.org/
http://www.postgresql.org/search/?u=%2Fdocs%2F9.1%2F&q=c...
It's also handy because you can combine it with relational data. For example, if you search from a manual page of a particular version of Postgres, it'll only return results from that version.
The main performance limitation is probably update/insert rate, and it doesn't has as many features as a dedicated IR-type system, but it's frequently good-enough and already present.