medium10 pts · first answer countsconnection-poolingpostgresql

Why use a connection pooler

Hundreds of app containers each open 20 connections to PostgreSQL. Why is a pooler like PgBouncer helpful?

A.Each PostgreSQL connection is a separate backend process with its own memory, so a pooler lets many clients share a small number of server connectionsB.PgBouncer caches query results so the database is never queried twiceC.PgBouncer turns asynchronous replication into synchronous replicationD.PostgreSQL cannot accept more than 10 connections without a pooler

← Risk of asynchronous replication Covering index →