Horton

Optimize Query jumble

David Rowley <drowley@postgresql.org>

View on postgr.es
Commit: ad9a23bc4f51eea829ee99c7d9940b7ac9f523e3
Author: David Rowley <drowley@postgresql.org>
Date: 2025-03-27T05:34:34Z
Releases: 18.0 
Optimize Query jumble

f31aad9b0 adjusted query jumbling so it no longer ignores NULL nodes
during the jumble.  This added some overhead.  Here we tune a few
things to make jumbling faster again.  This makes jumbling perform
similar or even slightly faster than prior to that change.

Author: David Rowley <dgrowleyml@gmail.com>
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Discussion: https://postgr.es/m/CAApHDvreP04nhTKuYsPw0F-YN+4nr4f=L72SPeFb81jfv+2c7w@mail.gmail.com

Files

PathChange+/−
src/backend/nodes/queryjumblefuncs.c modified +95 −9

Discussion