Top Architect

Jun 29, 2020 · Databases

How to Size Database Connection Pools: Lessons from HikariCP and Real‑World Performance Tests

This article explains why a smaller database connection pool often yields better latency and throughput, illustrates the effect with Oracle and PostgreSQL benchmarks, and provides a practical formula (connections = (CPU cores × 2) + effective disks) for sizing pools in production systems.