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