RE: [survey] New "Stable" QueryId based on normalized query text

Поиск
Список
Период
Сортировка
От Tsunakawa, Takayuki
Тема RE: [survey] New "Stable" QueryId based on normalized query text
Дата
Msg-id 0A3221C70F24FB45833433255569204D1FBE20A4@G01JPEXMBYT05
обсуждение исходный текст
Ответ на [survey] New "Stable" QueryId based on normalized query text  (legrand legrand <legrand_legrand@hotmail.com>)
Ответы Re: [survey] New "Stable" QueryId based on normalized query text
RE: [survey] New "Stable" QueryId based on normalized query text
Список 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 по дате отправления:

Предыдущее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: Proposal to suppress errors thrown by to_reg*()
Следующее
От: Amit Langote
Дата:
Сообщение: Re: speeding up planning with partitions