Posts tagged "indexes"

Published on
October 30, 2026
Article · Measurement
Make an index earn its place in a write-heavy table
Evaluate a PostgreSQL status index against both its read benefit and update work. Use HOT statistics as evidence about the mechanism, not as a speed score.
Published on
October 24, 2026
Article · Through the layers
Your MySQL Primary Key Travels Into the Other Indexes
Inspect a secondary-index query with numeric and text primary keys, and see why the key choice affects more than one index.
Published on
October 24, 2026
Article · Through the layers
PostgreSQL HOT Updates: Check When a Rust Write Avoids New Index Entries
Compare non-indexed and indexed updates using PostgreSQL's current-transaction HOT counters, without turning a tiny fixture into a performance claim.

Make an index earn its place in a write-heavy table