Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 7EB3D2E0083 for ; Tue, 22 Apr 2008 13:24:00 -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 04110-02 for ; Tue, 22 Apr 2008 13:23:57 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.179]) by developer.postgresql.org (Postfix) with ESMTP id 29F162E007A for ; Tue, 22 Apr 2008 13:23:57 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id n7so4018239wag.5 for ; Tue, 22 Apr 2008 09:23:55 -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=xgQlb/A2646somO95wv1NjneShm7BGlkMa/TpxQ2HBY=; b=NKiEKSRSM8LviNgEtrhWT5rYeGamKDLyyE4YzAVP8OPDInM1ovDzsWdo/98fRD0Yr4D5UCyjHfw+5h52lrO3EX7d83kG9ozzb2Pi1INI53xa1lmVWt21KXlnVWXUhowBu54njwsDbGQoR7J0qqatz/q7wQ7daWm08Fupb0hLhcU= 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=R/Sl+iqKzSxaSc2wKUSXu93QjbcHmBzIggIVBMuk/cvOt+2UkU6ygx7UtMVc/IJTl6xtaWEkQsdcxGAI63nxWyL8aFLJkPBb7+xuyYxTEdcDfyzoIUKo4unb44ARkkta7Ptl78Zz5w7j+JuBmAGkwnQf1/LCl+KgnwYcKoo2RKI= Received: by 10.114.102.1 with SMTP id z1mr530867wab.56.1208881435886; Tue, 22 Apr 2008 09:23:55 -0700 (PDT) Received: by 10.114.137.7 with HTTP; Tue, 22 Apr 2008 09:23:55 -0700 (PDT) Message-ID: Date: Tue, 22 Apr 2008 10:23:55 -0600 From: "Scott Marlowe" To: "Bryan Buecking" Subject: Re: CPU bound at 99% Cc: "Erik Jones" , pgsql-performance@postgresql.org In-Reply-To: <20080422161020.GE5961@starling-software.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20080422153045.GB5961@starling-software.com> <20080422161020.GE5961@starling-software.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/327 X-Sequence-Number: 29820 On Tue, Apr 22, 2008 at 10:10 AM, Bryan Buecking wrote: > > I agree, but the number of idle connections dont' seem to affect > performace only memory usage. I'm trying to lessen the load of > connection setup. But sounds like this tax is minimal? Not entirely true. There are certain things that happen that require one backend to notify ALL OTHER backends. when this happens a lot, then the system will slow to a crawl.