Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 7DC6163441A for ; Thu, 14 Jan 2010 06:46:46 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 78612-08 for ; Thu, 14 Jan 2010 10:46:35 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp1.hi-media-techno.com (smtp1.hi-media-techno.com [195.158.241.85]) by mail.postgresql.org (Postfix) with ESMTP id 12127634E08 for ; Thu, 14 Jan 2010 06:46:36 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by smtp1.hi-media-techno.com (Postfix) with ESMTP id 8C3D393B8C; Thu, 14 Jan 2010 11:46:34 +0100 (CET) Received: from smtp1.hi-media-techno.com ([127.0.0.1]) by localhost (smtp1.backbone.hi-media-techno.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 9tkL1zUgDML5; Thu, 14 Jan 2010 11:46:34 +0100 (CET) Received: from mail1.hi-media-techno.com (unknown [192.168.27.17]) by smtp1.hi-media-techno.com (Postfix) with ESMTP id 469F593B76; Thu, 14 Jan 2010 11:46:34 +0100 (CET) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail1.hi-media-techno.com (Postfix) with ESMTP id EA5F22A3AE; Thu, 14 Jan 2010 11:46:33 +0100 (CET) X-Virus-Scanned: amavisd-new at mail1.hi-media-techno.com Received: from mail1.hi-media-techno.com ([127.0.0.1]) by localhost (mail1.hi-media-techno.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ftBkRsoRVgiQ; Thu, 14 Jan 2010 11:46:33 +0100 (CET) Received: from dim (unknown [83.167.62.196]) by mail1.hi-media-techno.com (Postfix) with ESMTPSA id CA329CC37A; Thu, 14 Jan 2010 11:46:33 +0100 (CET) Received: by dim (Postfix, from userid 1000) id 4A0BC3FC2; Thu, 14 Jan 2010 11:44:15 +0100 (CET) From: Dimitri Fontaine To: Bob Dusek Cc: Scott Marlowe , pgsql-performance@postgresql.org Subject: Re: performance config help Organization: Hi-Media References: <4B4B177B020000250002E194@gw.wicourts.gov> <4B4B3BF6020000250002E1B1@gw.wicourts.gov> <61039b861001111323g531a5d68q1f59171d926aefef@mail.gmail.com> <61039b861001121001p37dc7698i48651189edcee9d0@mail.gmail.com> <4B4D53BF.4020905@postnewspapers.com.au> <61039b861001131210j673f1200r16f60f26f5a22265@mail.gmail.com> <61039b861001131437j4a70ab8nd68ebf0733994854@mail.gmail.com> Date: Thu, 14 Jan 2010 11:44:15 +0100 In-Reply-To: <61039b861001131437j4a70ab8nd68ebf0733994854@mail.gmail.com> (Bob Dusek's message of "Wed, 13 Jan 2010 17:37:56 -0500") Message-ID: <87eilt9da8.fsf@hi-media-techno.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.589 tagged_above=-10 required=5 tests=BAYES_00=-2.599, FH_DATE_PAST_20XX=3.188 X-Spam-Level: X-Archive-Number: 201001/271 X-Sequence-Number: 37151 Bob Dusek writes: > So, pgBouncer is pretty good. It doesn't appear to be as good as > limiting TCON and using pconnect, but since we can't limit TCON in a > production environment, we may not have a choice. You can still use pconnect() with pgbouncer, in transaction mode, if your application is compatible with that (no advisory locks or other session level tricks). Regards, -- dim