pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feed[Beginner Question]What is query jumbling?
2+ messages / 2 participants
[nested] [flat]
* [Beginner Question]What is query jumbling?
@ 2023-07-17 03:23 Wen Yi <wen-yi@qq.com>
0 siblings, 1 reply; 2+ messages in thread
From: Wen Yi @ 2023-07-17 03:23 UTC (permalink / raw)
To: pgsql-general <pgsql-general@lists.postgresql.org>
Hi community,
I am reading the 'Generate code for query jumbling through gen_node_support.pl' (https://www.postgresql.org/message-id/E1pMk51-000puf-55%40gemulon.postgresql.org) to understand the principle of the postgres's node, but I really don't know the meaning of the word 'query jumbling'.
Can someone provide me some advice?
Thanks in advance!
Yours,
Wen Yi
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [Beginner Question]What is query jumbling?
@ 2023-07-17 10:59 Tomas Vondra <tomas.vondra@enterprisedb.com>
parent: Wen Yi <wen-yi@qq.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tomas Vondra @ 2023-07-17 10:59 UTC (permalink / raw)
To: Wen Yi <wen-yi@qq.com>; pgsql-general <pgsql-general@lists.postgresql.org>
On 7/17/23 05:23, Wen Yi wrote:
> Hi community,
> I am reading the 'Generate code for query jumbling through
> gen_node_support.pl'
> (https://www.postgresql.org/message-id/E1pMk51-000puf-55%40gemulon.postgresql.org) to understand the principle of the postgres's node, but I really don't know the meaning of the word 'query jumbling'.
>
> Can someone provide me some advice?
> Thanks in advance!
>
Stuff like this is usually explained somewhere in the code base, so "git
grep" is your friend. In this case it's probably good to read the
comment in src/backend/nodes/queryjumblefuncs.c which says:
* Normalization is implemented by fingerprinting queries, selectively
* serializing those fields of each query tree's nodes that are judged
* to be essential to the query. This is referred to as a query jumble.
So "jumbling" is a process to generate a "normalized" query.
regards
--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-07-17 10:59 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-07-17 03:23 [Beginner Question]What is query jumbling? Wen Yi <wen-yi@qq.com>
2023-07-17 10:59 ` Re: [Beginner Question]What is query jumbling? Tomas Vondra <tomas.vondra@enterprisedb.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox