GIN: Understanding PostgreSQL's Inverted Index and Its Limitations

This series of posts traces the evolution from GIN to RUM to Extended RUM, showing how a single architectural idea—to store more in the index to do less work at query time—unlocks major performance im...