Databases · Senior · Question 72 of 75

After a deploy, hundreds of new app instances open connections at once and the database becomes unresponsive. What helps?

1Raising max_connections to 10,000
2Disabling connection pooling in the app
✓Correct answer: A pooler in front of the database, limits on pool size per instance, and gradual (staggered) startup with retries and backoff

Explanation

Connection storms waste CPU on authentication and process creation. Serverless platforms are especially prone to this.

Further reading

Test yourself

Take the Databases · Senior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.