Monday, 15 August 2011

Postgresql dies with 235 + concurrent connections -



Postgresql dies with 235 + concurrent connections -

i have installed postgresql on azure vm , running tests see if postgresql can back upwards expected load. have increased max_connections value 1000 when run ab -c 300, postgresql stops responding. there other settings should changing? thanks, kate.

postgresql perform best lot less 1000 connections on hardware. less 100. if application cannot queue work using connection pool, should set external connection pool pgbouncer between application , postgresql.

see: https://wiki.postgresql.org/wiki/number_of_database_connections

postgresql

No comments:

Post a Comment