Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ruPqh-005GtQ-8M for pgsql-hackers@arkaria.postgresql.org; Wed, 10 Apr 2024 04:46:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ruPqf-00FHcf-E8 for pgsql-hackers@arkaria.postgresql.org; Wed, 10 Apr 2024 04:46:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ruPqd-00FHYa-Tu for pgsql-hackers@lists.postgresql.org; Wed, 10 Apr 2024 04:46:13 +0000 Received: from wfout4-smtp.messagingengine.com ([64.147.123.147]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ruPqY-0008am-Ux for pgsql-hackers@lists.postgresql.org; Wed, 10 Apr 2024 04:46:11 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailfout.west.internal (Postfix) with ESMTP id 7BE001C000DC; Wed, 10 Apr 2024 00:46:02 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Wed, 10 Apr 2024 00:46:03 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1712724362; x=1712810762; bh=+MRdB6oKzn 9bIEr5pG/8p7X6JqDFcFSOnNohbEjXo0c=; b=Lms/ojm/sJxeGEggRhu3bR2WxZ w6FbhhxW9NgQnCUys2tziJwsk1h+pq08QOke9nvHdwS//0g30vJfw5s2NF8dXCLO Oy+1wyI/WRs7VzFg3cskneisBm17tb+BI7YKbbjpBkOuQyECJOyp9JyJ02ym2aL+ 66j+hqz4YwoN8DIoV4hWvPi4piREJ7fI1Qzpb65M+pxZ+PHeRTYWfi6Vv8AAknRp G8+QC4Qjop3yvEuB0WrWTkj+9ZFztnD8dBUK8vkAsOgBE7pUyzu+JnhufcWdqLps SJAEbqnwM7/Tjk6jOovyAuFd/pe/OiHpXxp6piAbklVlBOWU7JVBP2UzrFKA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1712724362; x=1712810762; bh=+MRdB6oKzn9bIEr5pG/8p7X6JqDF cFSOnNohbEjXo0c=; b=Tuuz/v+hYnCyg8XxgdKSJu7+F1Okw35JeB0eOmajMRrq QBgVBMT7UnPI02Q++KbVagmuikiMIIjG6leMCJUIhW5qFAzE9+rs2a9EoVxSS83d O8lNenOMYMRIgPJQ1XLWaFRpXggkOjUqUbTwMiPeTJa1WIMOBI8+9LmvGtdZuPfS M66Cy7Mf9ns2Vqq+elZNxlWRL3qzZ9YbbSpvZzIkqablrfJlo4EjICgpZnE55T0V Fx5EZPnbbZb6gLIrBC4Fenv0CsjDo4LpxkJvxwF2MDJFfknDdBfjjw0Gh0kgo5FN lKeM2SMPJ3mpoLn705jvlPQIk8QIrRbwKbXvHsoBcA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrudehhedgkeefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeg geegfffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiih ii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 10 Apr 2024 00:45:57 -0400 (EDT) Date: Wed, 10 Apr 2024 13:45:40 +0900 From: Michael Paquier To: Jeff Davis Cc: Heikki Linnakangas , Masahiko Sawada , Amit Kapila , vignesh C , Peter Smith , Tomas Vondra , "Hayato Kuroda (Fujitsu)" , Shubham Khanna , Dilip Kumar , PostgreSQL Hackers Subject: Re: Improve eviction algorithm in ReorderBuffer Message-ID: References: <791d98f474e518387d09eb390b8a12f265d130cc.camel@j-davis.com> <8cb6bbf6-57e7-4d14-9664-89505993afaa@iki.fi> <10f5dcecb5224c9967a7d595b6168a4144ffc24e.camel@j-davis.com> <4ce8dd017b911e8b2772147992db468deed71896.camel@j-davis.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="WPfROjmZPpvou56U" Content-Disposition: inline In-Reply-To: <4ce8dd017b911e8b2772147992db468deed71896.camel@j-davis.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --WPfROjmZPpvou56U Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Apr 09, 2024 at 09:16:53PM -0700, Jeff Davis wrote: > On Wed, 2024-04-10 at 12:13 +0900, Michael Paquier wrote: >> Wouldn't the best way forward be to revert >> 5bec1d6bc5e3 and revisit the whole in v18? >=20 > Also consider commits b840508644 and bcb14f4abc. Indeed. These are also linked. -- Michael --WPfROjmZPpvou56U Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmYWGXQACgkQnvQgOdby QH23oQ/+PwlUNKmiIKHzuWWl42C0TfnK1ku4zAyLo0WhwN9BeH0noey91bEbvk9c LCPa/kMBGG+a+2Vx4uBpnEIAyOWPXpoKq8pmOmtp+z1JsCP8mfMmoIiIO0vwA4er ijbvRpcxgoqE5zli1EMt3YNb1i73auwbOooHm7+SQBxhaaOjpLDxMDysw2GS+7TE yFbLmeKKUzb8SzyAz68ePmAVgHiUJ30xXnoyx20wIlPSqRx8RNVB57lQIr7Nn2vY 4LoDe7Zvde/KXOMRRpQNAFcUZoGhrH6jOt86m7QmZPeyK9ofM0NCHPwVdPKL3pPG 7bjFKlLyQeioLo5E7+50gw4MkvN4kE70u+g4LtuypO8kmnNEGL0IKk5cvIBKRG5U PiYNAfCkOE0GVenV5cCz853ikoWNpQ9Q/RVLtENP8ZfnQLzjYPRUKrHzBxjoXxbL AE5NsHTMe3fTe6QqK09NuAsHjklaODnQxRrsBrRCm/eTyTId6QpMCd86CEO1whPR 7JqLgSxTan7pyUJnfTIuqh5UkAYnExH8Ga29cOrWFsZguB4QT7X9EcOPKnsvghpC Qwk+szrWiCx3t2ptRdh5eGhO8cM8a2bUXs9KUyjOgv0UA2OJ3E6vaWwesVGV7uY4 VFVtm32B2JXvEkDlFqnvp4D0K0VS+ZS+7uGQrvxCLHklqRoWHo8= =0Y/L -----END PGP SIGNATURE----- --WPfROjmZPpvou56U--