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

Time-Series Cardinality: Why One More Indexed Column Costs More Than a Million More Rows

· Timescale · Aug. 28, 2026, 5:07 p.m.
time-series-data postgresql Postgres indexing query performance Time-Series Databases
Summary
This post explains the impact of adding indexed columns on query performance within Time-Series databases, specifically focused on Postgres. It discusses a case where introducing a new column negatively affected query efficiency, highlighting the trade-offs in cardinality and indexing strategies.
Read full post on www.tigerdata.com →
MORE POSTS LIKE THIS
Postgres Sorting at Scale Needs More Than ORDER BY
Timescale · Jun 24, 2026
postgresql Postgres
Data Access Testing With @testcontainers
Frontendmasters · Nov 4, 2026
blog-post database
The Top 10 SQL Server Wait Types, Worldwide
Brentozar · Nov 4, 2026
Wait Stats sql-server
What runs vinellu: one Postgres, three front doors
Avelino · Oct 31, 2026
Startups Postgres
Auth Workspace: a hexagonal auth/authz library for Axum + Postgres (v0.1.0, feedback welcome)
Users Rust Lang · Oct 24, 2026
Open Source Authorization
Lakebase Postgres branch-based restores for fast recovery at scale
Mooncake · Oct 1, 2026
engineering data engineering
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.