Horton
Menu

Re: Refactor query normalization into core query jumbling

Michael Paquier <michael@paquier.xyz>

View thread
From: Michael Paquier <michael@paquier.xyz>
To: Lukas Fittl <lukas@fittl.com>
Cc: Sami Imseih <samimseih@gmail.com>, zengman <zengman@halodbtech.com>, pgsql-hackers <pgsql-hackers@postgresql.org>, Julien Rouhaud <rjuju123@gmail.com>
Date: 2026-01-08T02:38:58Z
Lists: pgsql-hackers 
On Tue, Dec 30, 2025 at 01:31:30PM +0900, Michael Paquier wrote:
> Saying that, yes I think that you are right, we should be able to
> remove this dependency on JumbleState in
> pg_hint_plan_post_parse_analyze() and rely on the query ID.  I'm
> writing down a note about cleaning that on the HEAD branch of the
> module..

For the note, I have looked at that again and this improvement is
right, so I have pushed something to simplify the code:
https://github.com/ossc-db/pg_hint_plan/commit/3a63a56740e48e1d205294d5df6e198716718882

Thanks for the suggestion, Lukas.
--
Michael

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Mark JumbleState as a const in the post_parse_analyze hook

  2. Force standard_conforming_strings to always be ON.

  3. Move pg_stat_statements query jumbling to core.