From: Tom Lane <tgl@sss.pgh.pa.us>
To: Greg Smith <greg@2ndquadrant.com>
Cc: David Kerr <dmk@mr-paradox.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: pgbench could not send data to client: Broken pipe
Date: Wed, 08 Sep 2010 15:44:36 -0400
Message-ID: <8754.1283975076@sss.pgh.pa.us> (raw)
In-Reply-To: <4C87E3A6.8060800@2ndquadrant.com>
References: <20100908174629.GD40339@mr-paradox.net>
<8037.1283973026@sss.pgh.pa.us>
<4C87E3A6.8060800@2ndquadrant.com>
Greg Smith <greg@2ndquadrant.com> 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.
> It's kind of futile to run pgbench simulating much more than a hundred
> or two clients before 9.0 anyway.
Yeah ...
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, greg@2ndquadrant.com, dmk@mr-paradox.net
Subject: Re: pgbench could not send data to client: Broken pipe
In-Reply-To: <8754.1283975076@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox