Re: Caching of Queries

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