Why is connection pooling critical for large-scale database operations, and how do you configure and tune connection pools for high-concurrency environments? Compare connection pooling approaches and their trade-offs.

Sample answer preview

Connection pooling is critical at scale because database connections are expensive resources. Each PostgreSQL connection, for example, spawns a dedicated server process consuming approximately five to ten megabytes of memory.