DIFF.BLOG
New Following Discover Jobs
More
Top Writers Suggest a blog Upvotes plugin
Report bug Contact About Privacy
Sign up
Topics
Follow your own topics →
Menu
New Following Discover Jobs Top Writers
More
Suggest a blog Upvotes plugin Report bug Contact About
Sign up
Privacy Policy
The home for great developer writing.
We surface the best developer writing from thousands of independent blogs, updated daily.
Join Diff.blog
TOPICS

Knowing When Your Composite Index Earns Its Write Cost

· Timescale · Sept. 18, 2026, 4 p.m.
postgresql PostgreSQL Performance Performance Optimization Database Management Composite Indexes Query Cost Analysis
Summary
The blog post discusses composite indexes, focusing on the cost associated with inserts vs. their return on query performance. It offers a four-step method to evaluate both aspects and provides guidance on auditing current indexes for efficiency.
Read full post on www.tigerdata.com →
MORE POSTS LIKE THIS
Getting rid of a 4 TB table in PostgreSQL
Radim Marek · Oct 31, 2026
data engineering postgresql
Hiring and firing a DBA
Applied Cartography · Sep 7, 2026
hiring Performance Optimization
Database Animations: The Interview Question Everybody Gets Wrong
Brentozar · Sep 3, 2026
Database Animations indexing
Autoscaling Lakebase Postgres
Mooncake · Aug 31, 2026
engineering data engineering
Postgres 19: How Our Advice Has Changed Since We Wrote It
Crunchy Data · Aug 18, 2026
Production Postgres Postgres 19
Avoiding SQLite Database Locks in Production
Bendangelo Blog · Jul 4, 2026
sqlite ruby
Discover more posts →
AUTHOR
RECENT POSTS FROM THE AUTHOR
Choose how you want to continue.
Continue with GitHub Continue with Google
By continuing, you agree to our Privacy Policy.