X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 75140D1B563 for ; Fri, 14 Nov 2003 21:30:45 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 64706-06 for ; Fri, 14 Nov 2003 17:30:16 -0400 (AST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id 3E473D1B570 for ; Fri, 14 Nov 2003 17:30:14 -0400 (AST) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 1AKlWC-000711-00 for ; Fri, 14 Nov 2003 16:30:16 -0500 Received: by dba2 (Postfix, from userid 1019) id 0731BCBB8; Fri, 14 Nov 2003 16:30:16 -0500 (EST) Date: Fri, 14 Nov 2003 16:30:16 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Help with count(*) Message-ID: <20031114213015.GT28153@libertyrms.info> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <200311141251.38786.mallah@trade-india.com> <1068831807.2540.44.camel@fuji.krosing.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/122 X-Sequence-Number: 4682 On Fri, Nov 14, 2003 at 02:16:56PM -0500, Christopher Browne wrote: > otherwise-unoccupied connection in the pool, in effect, doing a sort > of "vacuum" of the connections. I don't get very favorable reactions > when I suggest that, though... Because it's a kludge on top of another kludge, perhaps? ;-) This needs to be fixed properly, not through an ungraceful series of workarounds. A -- ---- Andrew Sullivan 204-4141 Yonge Street Afilias Canada Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110