Databases · Middle · Question 37 of 75
Why do applications use a connection pool?
- 1Pools make queries return more rows
- 2PostgreSQL accepts only pooled connections
- ✓Correct answer: Each PostgreSQL connection is a separate process and opening one is slow, so a pool reuses a limited number of connections
Explanation
max_connections is limited, and each connection uses memory. Many app instances or serverless functions often need an external pooler like PgBouncer.