Postgres Pro
Downloads
Home   >   mailing lists

Re: PG15 beta1 sort performance regression due to Generation context change - Mailing list pgsql-hackers

From Jonathan S. Katz
Subject Re: PG15 beta1 sort performance regression due to Generation context change
Date
Msg-id 04bad170-4ef8-4540-4dea-1e0fea73067c@postgresql.org
Whole thread Raw
In response to PG15 beta1 sort performance regression due to Generation context change  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-hackers
Tree view 
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
Attachment

pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: allow building trusted languages without the untrusted versions
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: Enforce "max_wal_size/ min_wal_size must be at least twice wal_segment_size" limit while setting GUCs