TDTiger Dataintigerdata.hashnode.dev·3d ago · 16 min readTime-Series Cardinality: Why One More Indexed Column Costs More Than a Million More RowsOriginally published on August 28, 2026. Written by Damaso Sanoja. Cardinality is a consequence of how many dimensions you index your readings by. Here is where the curve bends, measured, and what you00
TDTiger Dataintigerdata.hashnode.dev·Sep 4 · 9 min read14,000x Faster Planning for LIMIT Queries on HypertablesOriginally published on August 27, 2026. Written by Sven Klemm. A very common query against a time-series table is fetching the latest row for a device: SELECT * FROM metrics WHERE device = 'D001' ORD00
TDTiger Dataintigerdata.hashnode.dev·Aug 31 · 14 min readWhy We Aren't Ready for C-3POOriginally published on June 25, 2026. Written by Matty Stratton, Hien Phan and Noah Hein. When people picture a robot, they picture C-3PO (or if you're a Trekkie, it's Lieutenant Commander Data and h00
TDTiger Dataintigerdata.hashnode.dev·Aug 24 · 10 min readHow to Tell Whether Your Slow Query Is a Planning or an Execution Problem Originally published on August 21, 2026. Written by NanoHertz Communications. Every EXPLAIN ANALYZE prints two numbers at the bottom, and most engineers read only one of them. Planning Time is how lon00
TDTiger Dataintigerdata.hashnode.dev·Aug 17 · 14 min readContinuous Aggregate Refresh, Demystified: Invalidation, Lookback, and Late-Arriving DataOriginally published on August 14, 2026. Written by Damaso Sanoja. Yesterday the shift dashboard reported 41,900 units across an eight-hour window. Today the same query over the same eight hours repor00