This short article discusses the structure of the PostgreSQL RUM Index with additional info not provided in the ctid (row number) of GIN posting list|tree.
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?