Re: Caching of Queries - Mailing list pgsql-performance

From Gaetano Mendola
Subject Re: Caching of Queries
Date
Msg-id 41530A90.1030702@bigfoot.com
Whole thread Raw
In response to Re: Caching of Queries  ("Jason Coene" <jcoene@gotfrag.com>)
Responses Re: Caching of Queries  ("Jason Coene" <jcoene@gotfrag.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Matt Clark"
Date:
Subject: Re: Caching of Queries
Next
From: Markus Schaber
Date:
Subject: Re: Caching of Queries