TDTiger Dataintigerdata.hashnode.dev·6d ago · 7 min readWhy Your PostgreSQL Partition Key Is Creating a Write BottleneckOriginally published on June 19, 2026. Written by NanoHertz Communications. At 50K inserts per second, a skewed partition key can concentrate 40K of those inserts onto a single partition. That one par00
TDTiger Dataintigerdata.hashnode.dev·Jun 30 · 7 min readWhen PostgreSQL Isn't the Right Fit: Recognizing Workloads That Need Different ArchitectureOriginally published on June 12, 2026. Written by NanoHertz Communications. When PostgreSQL isn't the right fit, the signs don't announce themselves clearly. Postgres is the right database for roughly00
TDTiger Dataintigerdata.hashnode.dev·Jun 18 · 4 min readGreat Models Aren't Enough for Physical AIOriginally published on June 18, 2026. Written by Hien Phan and Noah Hein. Notes from our Physical AI dinner What should a drone do when a police helicopter approaches it? We heard that question at a 00
TDTiger Dataintigerdata.hashnode.dev·Jun 10 · 14 min readA Unified Namespace Determines Your Historian Schema, Not the Other Way AroundOriginally published on June 10, 2026. Written by Damaso Sanoja. Most teams build the historian schema first, then connect it to a Unified Namespace. Adopt a UNS and the dependency runs the other way.00
TDTiger Dataintigerdata.hashnode.dev·Jun 5 · 8 min readRow vs Columnar Storage for Analytics: Why PostgreSQL Scans Are Slower Than They Should BeOriginally 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), 00