Jason Coene wrote:
> Hi Tom,
>
> Easily recreated with Apache benchmark, "ab -n 30000 -c 3000
> http://webserver ". This runs 1 query per page, everything else is cached
> on webserver.
That test require 30000 access with 3000 connections that is not a normal
load. Describe us your HW.
3000 connections means a very huge load, may you provide also the result of
"vmstat 5" my webserver trash already with -c 120 !
how many connection your postgres can manage ?
You have to consider to use a connection pool with that ammount of connections.
Regards
Gaetano Mendola