RE: [survey] New "Stable" QueryId based on normalized query text - Mailing list pgsql-hackers

From Tsunakawa, Takayuki
Subject RE: [survey] New "Stable" QueryId based on normalized query text
Date
Msg-id 0A3221C70F24FB45833433255569204D1FBE20A4@G01JPEXMBYT05
Whole thread Raw
In response to [survey] New "Stable" QueryId based on normalized query text  (legrand legrand <legrand_legrand@hotmail.com>)
Responses Re: [survey] New "Stable" QueryId based on normalized query text
RE: [survey] New "Stable" QueryId based on normalized query text
List pgsql-hackers
From: legrand legrand [mailto:legrand_legrand@hotmail.com]
> There are many projects that use alternate QueryId
> distinct from the famous pg_stat_statements jumbling algorithm.

I'd like to welcome the standard QueryID that DBAs and extension developers can depend on.  Are you surveying the needs
foryou to develop the QueryID that can meet as many needs as possible?
 


> needs.1: stable accross different databases,

Does this mean different database clusters, not different databases in a single database cluster?


needs.5: minimal overhead to calculate
needs.6: doesn't change across database server restarts
needs.7: same value on both the primary and standby?


> norm.9: comments aware

Is this to distinguish queries that have different comments for optimizer hints?  If yes, I agree.


Regards
Takayuki Tsunakawa




pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Proposal to suppress errors thrown by to_reg*()
Next
From: Amit Langote
Date:
Subject: Re: speeding up planning with partitions