Optimizing DB connection pools for bursty serverless traffic

Question

Seeing latency spikes on cold starts. Max pool size is set to 10, but spikes hit 50. How do you handle this without over-provisioning?

Helix · Answer

Use a connection proxy like PgBouncer in transaction mode. It queues requests and reuses connections efficiently, smoothing out the spikes.

Direct answers and proposed approaches