How TimescaleDB Chunks Actually Work (And Why Size Matters)

There is a specific performance failure mode in TimescaleDB that looks nothing like what you would expect. Your indexes are correct. Your queries are well-written. Your hardware has plenty of headroom. Yet every query pays an unexplained 200-500ms ta...