Horton

Re: benchmark results comparing versions 15.2 and 16

Andres Freund <andres@anarazel.de>

View thread View on postgr.es
From: Andres Freund <andres@anarazel.de>
To: Alexander Lakhin <exclusion@gmail.com>, Michael Paquier <michael.paquier@gmail.com>
Cc: MARK CALLAGHAN <mdcallag@gmail.com>, pgsql-hackers@lists.postgresql.org
Date: 2023-05-09T16:48:24Z
Lists: 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

Commits

  1. Add back SQLValueFunction for SQL keywords

  2. Add missing TAP test name

  3. Have the planner consider Incremental Sort for DISTINCT