Skip site navigation (1) Skip section navigation (2)

Re: Caching of Queries

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Jason Coene <jcoene(at)gotfrag(dot)com>
Subject: Re: Caching of Queries
Date: 2004-09-23 17:40:32
Message-ID: 41530A90.1030702@bigfoot.com (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-performance by date

Next:From: Markus SchaberDate: 2004-09-23 17:46:26
Subject: Re: Caching of Queries
Previous:From: Matt ClarkDate: 2004-09-23 17:38:32
Subject: Re: Caching of Queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group