Content-Type: multipart/mixed; boundary="------------QivfROu5lVC1RrlTGQXUnDkV"
Message-ID: <79e2f903-8bb0-4fc9-840c-f30d878d2327@postgrespro.ru>
Date: Thu, 12 Oct 2023 11:00:22 +0300
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Content-Language: en-US
To: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
From: "Anton A. Melnikov" <a.melnikov@postgrespro.ru>
Subject: Some performance degradation in REL_16 vs REL_15
Archived-At: <https://www.postgresql.org/message-id/79e2f903-8bb0-4fc9-840c-f30d878d2327%40postgrespro.ru>
Precedence: bulk

This is a multi-part message in MIME format.
--------------QivfROu5lVC1RrlTGQXUnDkV
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Greetengs!

Found that simple test pgbench -c20 -T20 -j8 gives approximately
for REL_15_STABLE at 5143f76:  336+-1 TPS
and
for REL_16_STABLE at 4ac7635f: 324+-1 TPS

The performance drop is approximately 3,5%  while the corrected standard deviation is only 0.3%.
See the raw_data.txt attached.

How do you think, is there any cause for concern here?

And is it worth spending time bisecting for the commit where this degradation may have occurred?

Would be glad for any comments and concerns.

With the best regards,

-- 
Anton A. Melnikov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--------------QivfROu5lVC1RrlTGQXUnDkV
Content-Type: text/plain; charset=UTF-8; name="raw_data.txt"
Content-Disposition: attachment; filename="raw_data.txt"
Content-Transfer-Encoding: base64

UkVMXzE1X1NUQUJMRSBhdCA1MTQzZjc2LCBUUFMKMzM2LjYzOTc2NQozMzQuMzc2ODAxCjMz
NC45NjMxMjEKMzM2LjIzNjY2CjMzNS42OTg2NzMKClJFTF8xNl9TVEFCTEUgYXQgNGFjNzYz
NWYsIFRQUwozMjQuMzczNjk1CjMyMy4xNjg2MjIKMzIzLjcyODY1MgozMjUuNzk5OTAxCjMy
NC44MTc1OQoK

--------------QivfROu5lVC1RrlTGQXUnDkV--