Row vs Columnar Storage for Analytics: Why PostgreSQL Scans Are Slower Than They Should Be

Originally published on June 5, 2026. Written by NanoHertz Communications. Here's a query that runs on most time-series tables: SELECT time_bucket('1 hour', ts) AS hour, avg(temperature),