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 1kdCqP-0002GT-AT for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Nov 2020 13:40:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kdCqO-0007Oz-6e for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Nov 2020 13:40:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kdCqN-0007Os-F0 for pgsql-hackers@lists.postgresql.org; Thu, 12 Nov 2020 13:40:55 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kdCqK-00019O-F4 for pgsql-hackers@postgresql.org; Thu, 12 Nov 2020 13:40:54 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailout.west.internal (Postfix) with ESMTP id 81816B01; Thu, 12 Nov 2020 08:40:47 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Thu, 12 Nov 2020 08:40:48 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:subject:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=Ka68EPmfgFcf1NNqY KCdlpIZgLGM08g7krURphN4buM=; b=DBjMBuyi8AugUTi00IcGAAmLEcg+aDZtA qvNQdb+sxNfBg8AFQElLGCMM/KkGzTr50sPM01xhhPAzkNR3Ut7EyLScmhrlSfzt otCRB18OScIWxfW+jpMcz1uShw67iNoAC/Wtf/CXU1lifmeQV3jevgdbaGfhGIi0 CZefM23+CeHe7GBpMWOqJUGIgLbaDlX+EJm7tA5EF69ezyGfB2z33QmSpLfd1Qt5 b6xlRAWSl8FL1C/hkMbGdRXz2q4YWXs7ABOSXiNi4qQ7YgQHZV5/+Q95Au6BPCbN Ts0+KOXlmhhvr4PWxapN9Sgsoz15PD/EeqWLkVPMr6DNjn7SnfLMw== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedruddvfedgvdelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffukfggtggujggfsehttdertddtredvnecuhfhrohhmpeetlhhvrghr ohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqe enucggtffrrghtthgvrhhnpeevgfelveegueejgefhgeetgefhgeehieefheehleetteei udeiiefhgffgheffteenucfkphepudeltddrleehrddukedrjeelnecuvehluhhsthgvrh fuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghrrhgvsegrlhhv hhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Received: from perhan.alvh.no-ip.org (unknown [190.95.18.79]) by mail.messagingengine.com (Postfix) with ESMTPA id B4C8730671A5; Thu, 12 Nov 2020 08:40:45 -0500 (EST) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 226482A14FE; Thu, 12 Nov 2020 10:40:43 -0300 (-03) Date: Thu, 12 Nov 2020 10:40:43 -0300 From: Alvaro Herrera To: "David G. Johnston" Cc: Matthieu Garrigues , Michael Paquier , Dave Cramer , PostgreSQL-development , Craig Ringer , Vaishnavi Prabakaran , Andres Freund , Daniel Verite , Michael Paquier Subject: Re: PATCH: Batch/pipelining support for libpq Message-ID: <20201112134043.GA19787@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk (Adding previous reviewers to CC) On 2020-Nov-03, David G. Johnston wrote: > Given the caveats around blocking mode connections why not just require > non-blocking mode, in a similar fashion to how synchronous functions are > disallowed? This is a very good question. Why indeed? Does anybody have a good answer to this? If not, I propose we just require that non-blocking mode is in use in order for batch mode to be used. I've been doing a review pass over this patch and have an updated version, which I intend to share later today (after I fix what appears to be a misunderstanding in the "singlerow" test in testlibpqbatch.c)