When queries slow down, the instinct is simple. Add indexes. → Composite indexes on device_id + timestamp
→ Partial indexes for recent data
→ Covering indexes for hot queries Result → queries drop back to milliseconds. But something important just changed. Every insert

→ View original post on X — @ronald_vanloon,