Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 4B9E72E0072 for ; Tue, 22 Apr 2008 13:15:46 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 01306-03 for ; Tue, 22 Apr 2008 13:15:40 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175]) by developer.postgresql.org (Postfix) with ESMTP id 6B7E12E007B for ; Tue, 22 Apr 2008 13:15:40 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so172242ugf.49 for ; Tue, 22 Apr 2008 09:15:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=hoP2meduVwyNMMPg5BPyiJstMMjefnFLWcZ1mtAHxgY=; b=kKy6DxIiGC5A3DWk4vTKJUy1A6dJ6CHkrhO5OEs+VDbqxzlOSa+7BwidxRgHJjZEWuQqN2Z7y6bSaGmC4ILuo8IN8j2Kbz6c/TrSF63qNP9sQTEWT+91MoCdUrzwa6NfdgiFwu4/6drgO1GF7uCerEkADXRa0v1tQAGwhjfCvvk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=NtQ1ZLEbztycituYrA7aLQWCIDsDjUvO6bZWFBYyd8exlMKHtvYe8kHt4VxEYg1oD2Zr6sj63/f6PmdmxfVb/s+Q34BCmRlm49T4w3hn2dwxpiobyPvIt6u/r7S1WLeh9mRFd8i1wb6TmhS0RCpcIZAUDlA7y3tXUbQQW3Ohuas= Received: by 10.66.221.18 with SMTP id t18mr7063539ugg.80.1208880939218; Tue, 22 Apr 2008 09:15:39 -0700 (PDT) Received: by 10.66.252.17 with HTTP; Tue, 22 Apr 2008 09:15:38 -0700 (PDT) Message-ID: <7be3f35d0804220915t5d1525d7u3e697079b09cc68c@mail.gmail.com> Date: Tue, 22 Apr 2008 18:15:38 +0200 From: "Harald Armin Massa" To: "Bryan Buecking" Subject: Re: CPU bound at 99% Cc: "PostgreSQL Performance" In-Reply-To: <20080422155640.GD5961@starling-software.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <20080422153045.GB5961@starling-software.com> <20080422084109.18e4282e@commandprompt.com> <20080422155640.GD5961@starling-software.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/323 X-Sequence-Number: 29816 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 --=20 GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Stra=DFe 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!