Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jeMNW-0000aU-Hy for pgsql-bugs@arkaria.postgresql.org; Thu, 28 May 2020 17:31:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jeMNU-0003KZ-Ht for pgsql-bugs@arkaria.postgresql.org; Thu, 28 May 2020 17:31:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jeMNU-0003Ho-9C for pgsql-bugs@lists.postgresql.org; Thu, 28 May 2020 17:31:36 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jeMNS-0006mF-3M for pgsql-bugs@lists.postgresql.org; Thu, 28 May 2020 17:31:35 +0000 Received: from pro.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 04SHVUE8016406; Thu, 28 May 2020 13:31:31 -0400 From: Tom Lane To: "Jawarilal, Manish" cc: "pgsql-bugs@lists.postgresql.org" Subject: Re: pgbench bug / limitation In-reply-to: References: Comments: In-reply-to "Jawarilal, Manish" message dated "Thu, 28 May 2020 15:30:55 -0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <7220.1590687090.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Thu, 28 May 2020 13:31:30 -0400 Message-ID: <7221.1590687090@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk "Jawarilal, Manish" writes: > OS: Windows 10 > C:\Program Files\PostgreSQL\12\bin>pgbench.exe -c 120 -r -T 3600 -h -p 9432 -U DBUser testdb > too many client connections for select() Yeah ... pgbench can support fairly large connection counts on platforms that have ppoll(), but Windows does not. Without ppoll() we fall back to select() which may not allow more than 100 or so. Having said that ... it looks like pgbench thinks it can override Windows' default setting: #ifdef WIN32 #define FD_SETSIZE 1024 /* must set before winsock2.h is includ= ed */ #endif and some googling confirms that indeed that should work. How did you build or come by this copy of pgbench? regards, tom lane