easy5 pts · first answer countsconnection-poolingpostgresql

FATAL: too many clients

After scaling the app from 4 to 40 servers, PostgreSQL logs "sorry, too many clients already". What is the best first fix?

A.Restart PostgreSQL every hourB.Put a connection pooler such as pgBouncer in front and reduce per-app pool sizesC.Set max_connections to 100000D.Disable authentication to make connections faster

← Rejecting bad values Finding slow MySQL queries →