PgBouncer: Effectively Managing Your PostgreSQL Connection Pool

Why HikariCP might not be enough and where PgBouncer steps in. PostgreSQL forks a separate process at the operating system level for each new connection. This differs from the thread-based model of other databases like MySQL. Each idle connection consumes approximately 5–10 MB of RAM (with default w