The fastest Postgres inserts

Blog The fastest Postgres inserts The fastest Postgres inserts Since you’re here, you might be interested in checking out Hatchet — the platform for running background tasks, data pipelines and AI agents at scale. Alexander Belanger Published on May 15, 2025 At Hatchet, we spent the past half year running hundreds of benchmarks against different Postgres configurations. We set out with a simple question: at what scale does Postgres break? For us, the question is existential — we use Postgres as the backing database for our task queue, orchestrator, and monitoring system. We had good reasons for building on top of Postgres, which we’ve written about elsewhere. But after starting to scale the system, we’d been observing some concerning behavior on our database — very high spikes in CPU, esoteric errors like multixact members limit exceeded , high lock contention — and we weren’t sure whether we’d reached some universal limit in our Postgres cluster, or whether we were doing somethi ... Read full article.