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

From Julien Rouhaud
Subject Re: [survey] New "Stable" QueryId based on normalized query text
Date
Msg-id CAOBaU_ZW=58F7BcLqANM9gxgBK6ZwuF+CsB1EB41k2tuRrcUvQ@mail.gmail.com
Whole thread Raw
In response to Re: [survey] New "Stable" QueryId based on normalized query text  (Jim Finnerty <jfinnert@amazon.com>)
Responses Re: [survey] New "Stable" QueryId based on normalized query text  (legrand legrand <legrand_legrand@hotmail.com>)
List 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 by date:

Previous
From: Evgeniy Efimkin
Date:
Subject: Re: [survey] New "Stable" QueryId based on normalized query text
Next
From: Julien Rouhaud
Date:
Subject: Re: [survey] New "Stable" QueryId based on normalized query text