Q43 PostgreSQL Domain 2 · 25–30% of exam Priority · Real Exam

An application opens thousands of short-lived connections and the server hits its connection limit. Which built-in feature addresses this?

  1. A Increase max_connections indefinitely
  2. B Enable the built-in PgBouncer connection pooler (correct answer)
  3. C Add a read replica
  4. D Enable query store

Shortcut: Flexible Server includes PgBouncer. Transaction-mode pooling multiplexes many client connections onto a small set of server connections, which is the correct fix for connection churn.