| From: | David Rowley <drowley(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Optimize Query jumble |
| Date: | 2025-03-27 05:35:20 |
| Message-ID: | E1txftg-001D5C-0r@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
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(at)gmail(dot)com>
Reviewed-by: Michael Paquier <michael(at)paquier(dot)xyz>
Discussion: https://postgr.es/m/CAApHDvreP04nhTKuYsPw0F-YN+4nr4f=L72SPeFb81jfv+2c7w@mail.gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/ad9a23bc4f51eea829ee99c7d9940b7ac9f523e3
Modified Files
--------------
src/backend/nodes/queryjumblefuncs.c | 104 ++++++++++++++++++++++++++++++++---
1 file changed, 95 insertions(+), 9 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2025-03-27 07:03:36 | pgsql: libpq: Add TAP tests for service files and names |
| Previous Message | David Rowley | 2025-03-27 05:23:24 | pgsql: Fix query jumbling to account for NULL nodes |