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 1m7ui7-0005t3-Io for pgsql-hackers@arkaria.postgresql.org; Mon, 26 Jul 2021 07:07:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m7ui6-00071C-Gw for pgsql-hackers@arkaria.postgresql.org; Mon, 26 Jul 2021 07:07:34 +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 1m7ui5-00070a-5T for pgsql-hackers@lists.postgresql.org; Mon, 26 Jul 2021 07:07:34 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m7ui1-0007cr-SA for pgsql-hackers@postgresql.org; Mon, 26 Jul 2021 07:07:32 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 241AF5C0044; Mon, 26 Jul 2021 03:07:28 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Mon, 26 Jul 2021 03:07:28 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=mxTqBtg1ap2N7JoSoGBRaMoiOZl zjIfDx7hRoJx6ANw=; b=KU1tuEAAgUz/sLNzwv8Gh5uroUaTe/6uoxxbLotaBVH b0VfWmcHLnu16/hJgmbVjGPUIUbE5Q+jbstenlTmfJFm6xuti2fBrv9B3ZM7lZOd pyiTAAfsfz/9l2sy+eOR10cNSN0t4pEt4VzX90jBoI1vykc4nPeZrZt8AUakGPe6 N/j93trTA1ZGZGeqeWqoQ3/iogih5CoWAAYifJNzjJCP/xb/YNiLLzMmgG5Ty9s/ EpekI5ji+MHPx9jP/TGq2WLBn2VwDAiQdz/GoX8Gl7+1Iqs0grqU4k9QsqNyxTKc cpoJjxlr5+LoEROcQ4nmqr2TlnvyFU8mumrDh8uhHxQ== 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:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=mxTqBt g1ap2N7JoSoGBRaMoiOZlzjIfDx7hRoJx6ANw=; b=sDe7VkA0M7PQhTEOweT7PJ pFF/K1rY6MrYaBEu+wEOtdBNpVUtRPomgDhQAodeHDzU1snjiwd3adCznGBsbRmL YdsRkyvi6WKFq/Z+E+QFO7dk6M1gmvbOeAknvpQIm2chl1Y654oXS3AURiekcK91 bKZmFmin8hQnQwWbfx+vus9MZiXNBVijVtpn69qwtciGB3tTLyNPnWJ7axYu5jMS jTqHK8iFzHlEHqfc3EDI2uFnJrnaV3L22j8APG/KDNcsmcpTCRbkTDJ/Z59cslnU OgRW3TJBHiFEUzX0W48o0x+yiZ+44y7Fi09gKQMLJTOWVRMWUAroH40VJp3n9Fog == X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvtddrgeeggdduudduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpedvgeduuefhtdeuleettdevjeeh heeiveeuieegleetgeeljeelieeuieehgeevhfenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 26 Jul 2021 03:07:25 -0400 (EDT) Date: Mon, 26 Jul 2021 16:07:20 +0900 From: Michael Paquier To: Andres Freund Cc: Alvaro Herrera , Andrew Dunstan , Peter Geoghegan , pgsql-hackers@postgresql.org Subject: Re: something is wonky with pgbench pipelining Message-ID: References: <20210720180039.23rivhdft3l4mayn@alap3.anarazel.de> <202107201857.kyv2gv3ouxot@alvherre.pgsql> <20210721235508.nefqq2r5vx4as7op@alap3.anarazel.de> <20210724230833.5trny35utntla6ch@alap3.anarazel.de> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="4ywArOkWW4W5kXye" Content-Disposition: inline In-Reply-To: <20210724230833.5trny35utntla6ch@alap3.anarazel.de> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --4ywArOkWW4W5kXye Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sat, Jul 24, 2021 at 04:08:33PM -0700, Andres Freund wrote: > On 2021-07-21 16:55:08 -0700, Andres Freund wrote: >> I'm inclined to push it to 14 and master, but ... >=20 > RMT: ^ If it were me, I think that I would have back-patched this change even if found after the GA release of 14 as there is no advantages in keeping the current behavior either except overloading pgbench with unnecessary system calls. No objections from me to change that now for 14~. -- Michael --4ywArOkWW4W5kXye Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmD+XygACgkQnvQgOdby QH2cJw//YDXp26oiUjLUaNi5vppJuqUrh3wdN3x6AXY+gkPS8ngZ3j80lGo6ouQx bs0itrGLxnkVZ7GtUlhPaY/efdoW8108TpV2d++qm1I3JZwjbvPMCKu0q51lD+I4 h0HmUAsgOg2rsdfpDvlgzYMuxXU9LxAQvrlvYP21MsxTVl1luCokFVN9yz2UG15e ZgDQYOWWnkBe6aCjFTOZhtQ8qegtLj9BNY5vR8I3l39iNGUSqfuR+1cf2TVBvPAF XxXxJ2BUVMbu06yPAOrPUzMncJD6CtVuELBSN2CT+xhi0pq2X87DGRw5/zNbkJIE PoHAhcY17FitRG7gupv4Bxl6WvGZpsOwdTUDi+ptKWR+M0bp4lFHF5ONAU2Qqz1c gRWpk9Y8NOzngc3qsuRua013XeX+9ri9ju+pPhYBNAstvi9xa9TyZSObTkFuMihg lG/SoZGZ0bU6EAPmohq8UNxYuA06rJpsjvxse8lErHJNz5QaE6ADlxRpxDJM/+PQ EPooNr6/IFHQhdszBUNZ1nyNBixmmZpsiIsDblrNkbf4nQ6ihvoH0NF1rkfFy6rr iehd1HlOgM8yZF5Ffyd/9ufo6u1mDF3UnnVGyyeWFfTfQXELuK72R4Z2u7ejt19a ny3PwM/wLb61YfBLO/kuF/Tf6BcCrjsKZvw68NC2oB989B+frzI= =ExXV -----END PGP SIGNATURE----- --4ywArOkWW4W5kXye--