News for hackers. Stuff that matters.
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.
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.