This post describes performance optimization methods to improve store operations by accelerating equivalent and range searches over PostgreSQL Arrays, JSON and Internal Tag Data.
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 discusses several key optimization methods available for the tagging business scenario using PostgreSQL functions.
This article discusses how you can accelerate PostgreSQL ad hoc query and dictionary (random field combination) through RUM index acceleration.
What are the different indexes of PostgreSQL for? How can we optimize our database with these indexes?