Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id A28D9632B6E for ; Thu, 9 Sep 2010 11:38:34 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 49210-06 for ; Thu, 9 Sep 2010 14:38:26 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id 8BFCD6322AE for ; Thu, 9 Sep 2010 11:38:27 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id 5FA6334C211; Thu, 9 Sep 2010 07:38:25 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at commandprompt.com Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id NTS25ECHhs9b; Thu, 9 Sep 2010 07:38:19 -0700 (PDT) Received: from perhan.alvh.no-ip.org (200-126-90-175.bk6-dsl.surnet.cl [200.126.90.175]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id 7666F348011; Thu, 9 Sep 2010 07:38:19 -0700 (PDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 276846E875; Thu, 9 Sep 2010 10:38:16 -0400 (CLT) Content-Type: text/plain; charset=UTF-8 Cc: Kevin Grittner , Greg Smith , pgsql-performance , Tom Lane Subject: Re: pgbench could not send data to client: Broken pipe From: Alvaro Herrera To: David Kerr In-reply-to: <20100908222959.GB59539@mr-paradox.net> References: <8037.1283973026@sss.pgh.pa.us> <4C87E3A6.8060800@2ndquadrant.com> <20100908195654.GB49941@mr-paradox.net> <9771.1283978128@sss.pgh.pa.us> <20100908204443.GG49941@mr-paradox.net> <4C87B22802000025000353B7@gw.wicourts.gov> <20100908212056.GI49941@mr-paradox.net> <4C87BF0502000025000353BE@gw.wicourts.gov> <20100908220011.GA59539@mr-paradox.net> <4C87C77C02000025000353D2@gw.wicourts.gov> <20100908222959.GB59539@mr-paradox.net> Date: Thu, 09 Sep 2010 10:38:16 -0400 Message-Id: <1284043050-sup-4975@alvh.no-ip.org> User-Agent: Sup/git Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201009/42 X-Sequence-Number: 40245 Excerpts from David Kerr's message of mié sep 08 18:29:59 -0400 2010: > Thanks for the insight. we're currently in performance testing of the > app. Currently, the JVM is the bottleneck, once we get past that > i'm sure it will be the database at which point I'll have the kind > of data you're talking about. Hopefully you're not running the JVM stuff in the same machine. -- Álvaro Herrera The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support