Re:PostgreSQL is Engine Yard's New Default
by buremba on Wednesday August 15, 2012 @11:43PM
(#4389807)
Postgresql cannot be fast as Lucene because of its not a "search engine". Postgresql full-text is fast enough for most cases but it doesn't have support for facet queries which is important for a search engine.
[ Parent
| on HN ]
Re:PostgreSQL is Engine Yard's New Default
by saurik on Thursday August 16, 2012 @12:10AM
(#4389872)
Actually, it does, which is why tools like PostGIS are built for it. In the most recent versions of PostgreSQL (I believe 9.1) they even added k-nearest-neighbor multi-dimensional index support to GiST.