Re: benchmark results comparing versions 15.2 and 16 - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: benchmark results comparing versions 15.2 and 16
Date
Msg-id ZFxu+IWkQpJhZkB3@paquier.xyz
Whole thread Raw
In response to Re: benchmark results comparing versions 15.2 and 16  (Andres Freund <andres@anarazel.de>)
Responses Re: benchmark results comparing versions 15.2 and 16
List pgsql-hackers
On Tue, May 09, 2023 at 09:48:24AM -0700, Andres Freund wrote:
> On 2023-05-08 12:11:17 -0700, Andres Freund wrote:
>> I can reproduce a significant regression due to f193883fc of a workload just
>> running
>> SELECT CURRENT_TIMESTAMP;
>>
>> A single session running it on my workstation via pgbench -Mprepared gets
>> before:
>> tps = 89359.128359 (without initial connection time)
>> after:
>> tps = 83843.585152 (without initial connection time)
>>
>> Obviously this is an extreme workload, but that nevertheless seems too large
>> to just accept...
>
> Added an open item for this.

Thanks for the report, I'll come back to it and look at it at the
beginning of next week.  In the worst case, that would mean a revert
of this refactoring, I assume.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Redundant strlen(query) in get_rel_infos
Next
From: Masahiko Sawada
Date:
Subject: Re: walsender performance regression due to logical decoding on standby changes