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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1pywAn-0001OQ-9w
	for pgsql-hackers@arkaria.postgresql.org; Tue, 16 May 2023 15:01:09 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1pyw9o-00036O-2O
	for pgsql-hackers@arkaria.postgresql.org; Tue, 16 May 2023 15:00:08 +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 <exclusion@gmail.com>)
	id 1pyw9n-00036F-O1
	for pgsql-hackers@lists.postgresql.org; Tue, 16 May 2023 15:00:07 +0000
Received: from mail-lf1-x135.google.com ([2a00:1450:4864:20::135])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <exclusion@gmail.com>)
	id 1pyw9k-0009pN-NX
	for pgsql-hackers@lists.postgresql.org; Tue, 16 May 2023 15:00:07 +0000
Received: by mail-lf1-x135.google.com with SMTP id 2adb3069b0e04-4f2510b2b98so12312007e87.3
        for <pgsql-hackers@lists.postgresql.org>; Tue, 16 May 2023 08:00:05 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20221208; t=1684249203; x=1686841203;
        h=content-transfer-encoding:in-reply-to:from:references:cc:to
         :content-language:subject:user-agent:mime-version:date:message-id
         :from:to:cc:subject:date:message-id:reply-to;
        bh=LgMcO5ERCF8yYsjkQwCxNggortwC7z64qPNl9hRa5y4=;
        b=FRgw2D8qmWU1fYduUvbyPnjgqKS0pP7ODlVl6ENEtomwiB8CZSQRZRDdwun2wpegqu
         3OkyXsWljkVz9qZ3ovLFNeYithn7DN8EfAwCjAtBYW9jCdgb+WeLwAvdRe0z46Rh07VV
         ZY6JeE0k1C6E6fjE/lIrHx5na1jSVCgcUv7OKyJ5H7YeJvQgiUAnlT3xqdY6QzMeRQK/
         2sZ+BbwHGI2eGsALImdBVy7r9Rkyu26UkZaCPqJ28iiduncrLrrBYDf6PGFhtI2MuOMJ
         KhceUA+NGccX7+u0isGbcF8WEzeI+0bmLZMwOEiDnH5KUr112Y0NAtldcPVf5CHcAIVq
         m06w==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20221208; t=1684249203; x=1686841203;
        h=content-transfer-encoding:in-reply-to:from:references:cc:to
         :content-language:subject:user-agent:mime-version:date:message-id
         :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to;
        bh=LgMcO5ERCF8yYsjkQwCxNggortwC7z64qPNl9hRa5y4=;
        b=b4ryIKod9wFXXPtcM7dKuzMfo/ASZ8EJgowOVA66ykmSqMeinmPKXLK+OmSKyoerB4
         Wdt+QJ/e8Ovsjd00jSKf+D7poeLH/0MctWHsXRlzBcOxm3oYQm0H4ZDTGp/6p2Hz48hP
         UAYZ1qQi6K2Gw8881gGLZwpYr43is3EmpgFXtOesEThmddoLHCPWHFdkcoDk2U5kUHRM
         twMziA74whgbTdla/ynK6XWVbPNkiyHwM7RX4oLL+QfDtC0E5UZtQtWOHRewBEIzSGzJ
         qy/kFBCXoSE6lwPXAsd50OQcUxBtVwFItqUANB4wolJDoCWuI3uUaqTavw1Q1nlgjaJO
         AOcA==
X-Gm-Message-State: AC+VfDzFvrgEecGWjDo4RqH5JxEkC4AzuJFUldYulpWTvFfVa5EgGrU8
	aNQyhtZpiAIuvEyYHTInnaA=
X-Google-Smtp-Source: ACHHUZ6X3W2vSGKW+E5XRFLE9fRZQgEeEV2NNdfA08x0fDwIijsAf/EuDwnAokUu7cHNzsoUgavwcw==
X-Received: by 2002:ac2:5d6e:0:b0:4d6:d0a0:8313 with SMTP id h14-20020ac25d6e000000b004d6d0a08313mr6319267lft.10.1684249203286;
        Tue, 16 May 2023 08:00:03 -0700 (PDT)
Received: from [1.0.0.7] ([81.23.166.126])
        by smtp.gmail.com with ESMTPSA id q5-20020ac25285000000b004f268571daasm2188147lfm.211.2023.05.16.08.00.01
        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);
        Tue, 16 May 2023 08:00:02 -0700 (PDT)
Message-ID: <62b9850a-4c95-26c2-0aeb-d1d00434a13b@gmail.com>
Date: Tue, 16 May 2023 18:00:00 +0300
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.4.2
Subject: Re: benchmark results comparing versions 15.2 and 16
Content-Language: en-US
To: Michael Paquier <michael@paquier.xyz>, Andres Freund <andres@anarazel.de>
Cc: MARK CALLAGHAN <mdcallag@gmail.com>, pgsql-hackers@lists.postgresql.org
References: <CAFbpF8N4bVFZ+eyWFj_+fZXZFSayk2kJVtZnouUVKGHudiDrSw@mail.gmail.com>
 <b32bed1b-0746-9b20-1472-4bdc9ca66d52@gmail.com>
 <20230508191117.v6475ip6hxpwukss@awork3.anarazel.de>
 <20230509164824.wtfn5aoggj4rcz67@awork3.anarazel.de>
 <ZFxu+IWkQpJhZkB3@paquier.xyz> <ZGHBGE45jKW8FEpe@paquier.xyz>
From: Alexander Lakhin <exclusion@gmail.com>
In-Reply-To: <ZGHBGE45jKW8FEpe@paquier.xyz>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
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>
Archived-At: <https://www.postgresql.org/message-id/62b9850a-4c95-26c2-0aeb-d1d00434a13b%40gmail.com>
Precedence: bulk

15.05.2023 08:20, Michael Paquier wrote:
> I am not going to let that hang in the air with beta1 getting released
> next week, though, so attached are two patches to revert the change
> (these would be combined, just posted this way for clarity).

I can confirm that the patches improve (restore) performance for my test:
pgbench -i benchdb
pgbench -c 10 -T 300 benchdb

tps (over three runs):
HEAD (08c45ae23):
10238.441580, 10697.202119, 10706.764703

HEAD with the patches:
11134.510118, 11176.554996, 11150.338488

f193883fc~1 (240e0dbac)
11082.561388, 11233.604446, 11087.071768

15.3 (8382864eb)
11328.699555, 11128.057883, 11057.934392

Best regards,
Alexander