Advanced
Database Management Systems
Q86 / 100
What is database connection pooling vs. connection multiplexing?
Correct! Well done.
Incorrect.
The correct answer is B) Connection pooling reuses connections per application process; multiplexing (PgBouncer transaction mode) shares one server connection across many client transactions, reducing server-side connection count
B
Correct Answer
Connection pooling reuses connections per application process; multiplexing (PgBouncer transaction mode) shares one server connection across many client transactions, reducing server-side connection count
Explanation
PgBouncer in transaction mode multiplexes: many clients share few server connections (one per concurrent transaction, not per client). This allows 10,000 app connections with only 100 PostgreSQL connections.
Progress
86/100