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

From Andres Freund
Subject Re: benchmark results comparing versions 15.2 and 16
Date
Msg-id 20230509164824.wtfn5aoggj4rcz67@awork3.anarazel.de
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
Hi,

On 2023-05-08 12:11:17 -0700, Andres Freund wrote:
> Hi,
> 
> On 2023-05-08 16:00:01 +0300, Alexander Lakhin wrote:
> > This difference is confirmed by multiple test runs. `git bisect` for this
> > regression pointed at f193883fc.
> 
> 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.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: psql \watch 2nd argument: iteration count
Next
From: MARK CALLAGHAN
Date:
Subject: Re: benchmark results comparing versions 15.2 and 16