Databases · Senior · Question 37 of 75
What's a typical reason to cap max_connections in PostgreSQL and pool instead of raising it to thousands?
- 1PostgreSQL can't count above 1000
- ✓Correct answer: Each connection is a process with its own memory, and too many active backends cause contention that lowers total throughput
- 3Higher values disable replication
Explanation
Throughput usually peaks with a number of active connections near a small multiple of CPU cores. A pooler queues the rest cheaply.