X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AEF1A3A4B04 for ; Fri, 26 Nov 2004 21:50:55 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51041-09 for ; Fri, 26 Nov 2004 21:50:52 +0000 (GMT) Received: from server2.sitesell.com (server2.sitesell.com [216.95.221.3]) by svr1.postgresql.org (Postfix) with SMTP id D62043A4B41 for ; Fri, 26 Nov 2004 21:50:52 +0000 (GMT) Received: (qmail 14939 invoked from network); 26 Nov 2004 21:50:51 -0000 Received: from dyn-70-236.tor.dsl.tht.net (134.22.70.236) by server2.sitesell.com with SMTP; 26 Nov 2004 21:50:51 -0000 Subject: Re: time to stop tuning? From: Rod Taylor To: David Parker Cc: Postgresql Performance In-Reply-To: <07FDEE0ED7455A48AC42AC2070EDFF7C26BDDF@corpsrv2.tazznetworks.com> References: <07FDEE0ED7455A48AC42AC2070EDFF7C26BDDF@corpsrv2.tazznetworks.com> Content-Type: text/plain Date: Fri, 26 Nov 2004 16:48:40 -0500 Message-Id: <1101505720.13382.2.camel@home> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 FreeBSD GNOME Team Port Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/412 X-Sequence-Number: 9366 > On limiting the client side connections: we've been gradually pushing up > the client-side connection pool and threads, and have seen steady > improvement in our throughput up to the current barrier we have reached. Very well.. Sometimes more simultaneous workers helps, other times it hinders. > I've attached the plans for the 4 queries that represent ~35% of our > load. These are run against the same dataset, but without any other > load. Another big query basically requires a test to be runnning because Those aren't likely from your production system as there isn't any data in those tables and the queries took less than 1ms. -- Rod Taylor