New answers tagged scalability
max_connections = 1024 ?! You need a connection pool. Use PgBouncer in transaction-pooling mode if your app doesn't support built-in pooling. You're running PostgreSQL on a tiny toy server. Keep the active connection count low and queue work up in series. High max_connections introduces significant inefficiency, and having lots of actively working ...
Top 50 recent answers are included