5 ms·
Look at some of the linked PDFs. It's the indexing technique and on-disk format that is an enabler for several notable use cases; personally, I'm looking forwa
by garenp 13y ago
Look at some of the linked PDFs. It's the indexing technique and on-disk format that is an enabler for several notable use cases; personally, I'm looking forward to a time when I can use pg for full-text search without having to resort to another external system like Lucene or Sphinx. What it won't have is the query "smarts" like Lucene or Sphinx do today, but you need speed first.
- baudehlo 13y agoPg's built in full text search works amazingly well and has all the smarts. It's also faster than lucene.
- rpedela 13y agoHuh? Please come up with about ten references (one isn't enough) to back up those claims.
- jeltz 13y agoI do not think so, but it might be after the GIN optimization work is committed. After it they beat Sphinx in several benchmarks. http://www.sai.msu.su/~megera/postgres/talks/Next%20generation%20of%20GIN.pdf http://www.sai.msu.su/~megera/postgres/talks/Next%20generati...
- baudehlo 13y agoI didn't say it was faster than sphinx (yet) but it is definitely faster than lucene in all the benchmarks I've thrown at it.