Get the latest tech news
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.
Given the wide array of specialized data stores out there — Kafka, Valkey, Clickhouse, countless others — and thousands of infrastructure consultants whose sole purpose is to convince you to switch to a difficult-to-manage managed service, there’s generally a lack of intuition for how far a database like Postgres can scale on modern hardware. If we’re saturating CPU, this will introduce dampening behavior, making it slower to acquire locks and for Postgres to spawn a query process, which can increase the average write time and thus slowing throughput. At a certain point, increasing the batch size will not yield any additional throughput, because the time spent on i/o when writing the data to disk will far exceed the overhead of each connection and query.
Or read this on Hacker News
