DIFF.BLOG
New Following Discover Jobs
More
Top Writers Suggest a blog Upvotes plugin
Report bug Contact About
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
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.
postgresql time-series-data Postgres Time-Series Databases indexing query performance
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
Vertical Advantage: Transforming Industries with Lakebase and Agentic AI
Mooncake · Aug 27, 2026
Partners Customers
How I Implemented Authorization in My Go App With RLS (Postgres)
Haseeb Majid · Aug 15, 2026
Authorization Row Level Security
Atom #hdye4fs
Brandur Leach · Aug 12, 2026
Postgres pgbouncer
Turning Claude into Postgres so I can raise a Series A
Byteofdev · Aug 1, 2026
artificial-intelligence Postgres
Hybrid Search Patterns with Postgres and pgvector
Crunchy Data · Jul 30, 2026
Vectors & LLMs Postgres
Discover more posts →
AUTHOR
RECENT POSTS FROM THE AUTHOR
Choose how you want to continue.
Continue with GitHub Continue with Google