Re: [PATCH] Optionally record Plan IDs to track plan changes for a query

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Sami Imseih <samimseih(at)gmail(dot)com>
Cc: Lukas Fittl <lukas(at)fittl(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Marko M <marko(at)pganalyze(dot)com>
Subject: Re: [PATCH] Optionally record Plan IDs to track plan changes for a query
Date: 2025-02-05 00:12:14
Message-ID: Z6Ks3ta5089DXiPc@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Feb 04, 2025 at 05:14:48PM -0600, Sami Imseih wrote:
> Here are my high-level thoughts on this:
> 1. rename queryjumblefuncs.c to jumblefuncs.c

If these APIs are used for somethings else than Query structure, yes,
the renaming makes sense.

> 2. move the query jumbling related code to parser/analyze.c,
> since query jumbling occurs there during parsing.

Not sure about this one. It depends on how much is changed. As long
as everything related to the nodes stays in src/backend/nodes/,
perhaps that's OK.

> 3. Rewrite the comments in the new jumblefuncs.c to
> make it clear the intention of this infrastructure; that
> it is used to jumble nodes for query or plan trees.

Seems to me that this could be done before 2, as well.

> I can work on this if you agree.

I'd welcome an extra patch to rework a bit the format of the comments
for the Plan nodes, to ease the addition of pg_node_attr(), making any
proposed patches more readable.
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2025-02-05 00:19:22 Re: Adding facility for injection points (or probe points?) for more advanced tests
Previous Message Andres Freund 2025-02-05 00:04:00 Re: meson missing test dependencies