CODEWITHSUNDEEP
postgresql
Kate
Kate

Reputation: 732

Postgresql dies with 235 + concurrent connections

I have installed postgresql on an Azure VM and am running tests to see if postgresql can support the expected load. I have increased the max_connections value to 1000 but when I run ab -c 300, postgresql stops responding. Are there any other settings I should be changing? Thanks, Kate.

Upvotes: 0

Views: 70

Answers (1)

Craig Ringer
Craig Ringer

Reputation: 324385

PostgreSQL will perform best with a lot less than 1000 connections on most hardware. Usually less than 100. If your application cannot queue work using a connection pool, you should put an external connection pool like PgBouncer between your application and PostgreSQL.

See: https://wiki.postgresql.org/wiki/Number_Of_Database_Connections

Upvotes: 1

Related Questions