Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 3FB686322CA for ; Wed, 8 Sep 2010 16:58:30 -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 30163-05 for ; Wed, 8 Sep 2010 19:58:18 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from vexbert.mr-paradox.net (vexbert.mr-paradox.net [198.145.180.174]) by mail.postgresql.org (Postfix) with ESMTP id C2DC963283F for ; Wed, 8 Sep 2010 16:58:18 -0300 (ADT) Received: by vexbert.mr-paradox.net (Postfix, from userid 18391) id B5DEA845EE; Wed, 8 Sep 2010 15:58:17 -0400 (EDT) Date: Wed, 8 Sep 2010 12:58:17 -0700 From: David Kerr To: Tom Lane Cc: Greg Smith , pgsql-performance@postgresql.org Subject: Re: pgbench could not send data to client: Broken pipe Message-ID: <20100908195817.GC49941@mr-paradox.net> References: <20100908174629.GD40339@mr-paradox.net> <8037.1283973026@sss.pgh.pa.us> <4C87E3A6.8060800@2ndquadrant.com> <8754.1283975076@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <8754.1283975076@sss.pgh.pa.us> User-Agent: Mutt/1.4.2.3i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/33 X-Sequence-Number: 40236 On Wed, Sep 08, 2010 at 03:44:36PM -0400, Tom Lane wrote: - Greg Smith writes: - > Tom Lane wrote: - >> So I think you could get above the FD_SETSIZE limit with a bit of - >> hacking if you were using 9.0's pgbench. No chance with 8.3 though. - - > I believe David can do this easily enough by compiling a 9.0 source code - > tree with the "--disable-thread-safety" option. - - It would take a bit more work than that, because the code still tries to - limit the client count based on FD_SETSIZE. He'd need to hack it so - that in non-thread mode, the limit is FD_SETSIZE per subprocess. I was - suggesting that an official patch to that effect would be a good thing. Yeah, that might be beyond me =) Dave