July 2026
Postgres: bounded connection pool + statement timeouts
A single runaway query can no longer pin the connection pool. Statement-level deadline enforced.
Read more
What changed: Pool size capped at 20 connections (from unbounded). Statement timeout set to 15s for tenant-facing reads, 30s for admin queries. Slow queries now fail loudly with 57014 query_canceled instead of pinning connections.
Why: Three production wedges in Q1 traced to a single slow aggregation holding connections during traffic spikes. This is the structural fix.
Monitoring: /admin/system-health surfaces pool saturation as a first-class metric.
Want to see it live?
HatchOS is built for freight operations that want to move faster than their competitors.
See it live → Book a Demo