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