Horton

Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: David Rowley <dgrowleyml@gmail.com>
Cc: Sami Imseih <samimseih@gmail.com>, Ivan Bykov <I.Bykov@modernsys.ru>, pgsql-hackers@postgresql.org
Date: 2025-03-24T06:50:46Z
Lists: pgsql-hackers 
On Mon, Mar 24, 2025 at 07:42:21PM +1300, David Rowley wrote:
> Can you share which patch you tested here?  There are many patches on
> this thread and I don't want to make assumptions about which one these
> are the results for.

The patch tested is the latest one that has been posted on this
thread, for a comparison of HEAD at 8a3e4011f02d and this 0001 (no
0002 which was forcing a loop to make the jumbling heavier):
https://www.postgresql.org/message-id/Z9z85Ui5lPkPn2hq@paquier.xyz

The message holding the patch tested is the one I've replied to when
posting the results shared here:
https://www.postgresql.org/message-id/Z-DB83o5AZmgnvnA@paquier.xyz
--
Michael

Commits

  1. Optimize Query jumble