From: Harald Armin Massa <haraldarminmassa@gmail.com>
To: Bryan Buecking <buecking@gmail.com>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: CPU bound at 99%
Date: Tue, 22 Apr 2008 18:15:38 +0200
Message-ID: <7be3f35d0804220915t5d1525d7u3e697079b09cc68c@mail.gmail.com> (raw)
In-Reply-To: <20080422155640.GD5961@starling-software.com>
References: <20080422153045.GB5961@starling-software.com>
<20080422084109.18e4282e@commandprompt.com>
<20080422155640.GD5961@starling-software.com>
Bryan,
> > about 2300 connections in idle
> > > (ps auxwww | grep postgres | idle)
that is about 2300 processes being task scheduled by your kernel, each
of them using > 1 MB of RAM and some other ressources, are you sure
that this is what you want?
Usual recommended design for a web application:
start request, rent a connection from connection pool, do query, put
connection back, finish request, wait for next request
so to get 500 connections in parallel, you would have the outside
situaion of 500 browsers submitting requests within the time needed to
fullfill one request.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: haraldarminmassa@gmail.com, buecking@gmail.com
Subject: Re: CPU bound at 99%
In-Reply-To: <7be3f35d0804220915t5d1525d7u3e697079b09cc68c@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox