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

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: [survey] New "Stable" QueryId based on normalized query text
Дата
Msg-id CAOBaU_ZW=58F7BcLqANM9gxgBK6ZwuF+CsB1EB41k2tuRrcUvQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [survey] New "Stable" QueryId based on normalized query text  (Jim Finnerty <jfinnert@amazon.com>)
Ответы Re: [survey] New "Stable" QueryId based on normalized query text  (legrand legrand <legrand_legrand@hotmail.com>)
Список pgsql-hackers
On Mon, Aug 12, 2019 at 2:40 PM Jim Finnerty <jfinnert@amazon.com> wrote:
>
> If hashing names instead of using OIDs is too expensive for some workload,
> then that workload would need to be able to turn statement hashing off.  So
> it needs to be optional, just like queryId is optionally computed today.
> For many cases the extra overhead of hashing object names is small compared
> to optimization time plus execution time.

Are you suggesting a fallback to oid based queryid or to entirely
disable queryid generation?

How would that work with pg_stat_statements or similar extension?



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Evgeniy Efimkin
Дата:
Сообщение: Re: [survey] New "Stable" QueryId based on normalized query text
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: [survey] New "Stable" QueryId based on normalized query text