#
DIFF.BLOG
New
Following
Discover
Jobs
More
Top Writers
Suggest a blog
Upvotes plugin
Report bug
Contact
About
Privacy
Sign up
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
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
indexing
Database Animations
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
The curious case of Google's AlloyDB
Radim Marek ·
Aug 15, 2026
Google Cloud Platform
cloud infrastructure
Avoiding SQLite Database Locks in Production
Bendangelo Blog ·
Jul 4, 2026
ruby
sqlite
Discover more posts →
AUTHOR
Advertise
Sponsor diff.blog
Put your product in front of developers who read and write about their craft. One exclusive sponsor at a time.
Become a sponsor →
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
.