The recent update of PostgreSQL 9.6 has made many enhancements in full-text search and has also brought us RUM plug-in support.
This article shows how PostgreSQL, equipped with both GIN indexes and the cost-based optimizer (CBO), can automatically choose the most optimal query method.
This article discusses how you can accelerate PostgreSQL ad hoc query and dictionary (random field combination) through RUM index acceleration.
