Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1f4ZEi-0002o8-BR
	for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Apr 2018 21:49:32 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1f4ZEh-00084R-Fe
	for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Apr 2018 21:49:31 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1f4ZEh-0007yF-7Y
	for pgsql-hackers@lists.postgresql.org; Fri, 06 Apr 2018 21:49:31 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1f4ZEd-00017W-2E
	for pgsql-hackers@postgresql.org; Fri, 06 Apr 2018 21:49:29 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id w36LnJOn020088;
	Fri, 6 Apr 2018 17:49:19 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
cc: "Rady, Doug" <radydoug@amazon.com>, Fabien COELHO <coelho@cri.ensmp.fr>,
        "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>,
        Robert Haas <robertmhaas@gmail.com>
Subject: Re: PATCH: pgbench - option to build using ppoll() for larger
 connection counts
In-reply-to: <20180406211528.ox4gjlwvkaekyv4w@alap3.anarazel.de>
References: <alpine.DEB.2.20.1801252339520.26762@lancre>
 <81936381-841A-459D-9FE5-18659680355C@amazon.com>
 <alpine.DEB.2.20.1801262348420.17596@lancre>
 <654A1247-8E1E-4E9C-937D-9119B1731FF2@amazon.com>
 <20180301083404.z2sbnjdaw7gxvz6x@alap3.anarazel.de>
 <alpine.DEB.2.20.1803011121300.7903@lancre>
 <20180304001409.tajjmefj7yq6xs77@alap3.anarazel.de>
 <2879AF01-915B-4D07-9F42-04F7CA71908D@amazon.com>
 <alpine.DEB.2.20.1803251252390.8109@lancre>
 <22D7FB26-058A-4022-A94C-FFDAD9F97764@amazon.com>
 <20180406211528.ox4gjlwvkaekyv4w@alap3.anarazel.de>
Comments: In-reply-to Andres Freund <andres@anarazel.de>
	message dated "Fri, 06 Apr 2018 14:15:28 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <20086.1523051359.1@sss.pgh.pa.us>
Date: Fri, 06 Apr 2018 17:49:19 -0400
Message-ID: <20087.1523051359@sss.pgh.pa.us>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk

Andres Freund <andres@anarazel.de> writes:
> I'm still not particularly happy with this.

I'm a bit confused as to what the point is.  It seems unlikely that one
pgbench process can effectively drive enough backends for select's
limitations to really be an issue.

			regards, tom lane