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

· Timescale · Aug. 28, 2026, 5:07 p.m.
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.
AUTHOR