Re: PG15 beta1 sort performance regression due to Generation context change

From: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>
To: David Rowley <dgrowleyml(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PG15 beta1 sort performance regression due to Generation context change
Date: 2022-05-24 00:49:32
Message-ID: 04bad170-4ef8-4540-4dea-1e0fea73067c@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 5/20/22 1:56 AM, David Rowley wrote:
> Hackers,
>
> Over the past few days I've been gathering some benchmark results
> together to show the sort performance improvements in PG15 [1].

> So it basically looks like I discovered a very bad case that causes a
> significant slowdown. Yet other cases that are not an exact power of
> 2 stand to gain significantly from this change.
>
> I'm unsure exactly what I should do about this right now.

While this is being actively investigated, I added this into open items.

Thanks,

Jonathan

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro Horiguchi 2022-05-24 01:19:53 Re: Enforce "max_wal_size/ min_wal_size must be at least twice wal_segment_size" limit while setting GUCs
Previous Message Nathan Bossart 2022-05-24 00:04:27 Re: allow building trusted languages without the untrusted versions