Does Postgres Scale?
4 hours ago
- #Postgres scalability
- #durable workflows
- #database benchmarking
- Postgres can handle up to 144K writes per second, equivalent to 12 billion writes daily, in a benchmark focusing on write-intensive workloads.
- For durable workflows, a single Postgres server processes up to 43K workflows per second, involving two writes per workflow and a total of 86K writes.
- The bottleneck in raw write and workflow performance is the flushing of the write-ahead log (WAL) to disk, due to synchronization requirements.
- Postgres-backed queues achieve up to 12.1K workflows per second initially, with bottleneck shifting to lock contention in the workflow status table.
- Distributing work across multiple queues or partitions increases throughput to 30.6K workflows per second, with the bottleneck returning to the WAL at scale.