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

From: Jim Finnerty <jfinnert(at)amazon(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [survey] New "Stable" QueryId based on normalized query text
Date: 2019-08-12 12:40:24
Message-ID: 1565613624729-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

-----
Jim Finnerty, AWS, Amazon Aurora PostgreSQL
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Evgeniy Efimkin 2019-08-12 12:52:19 Re: [survey] New "Stable" QueryId based on normalized query text
Previous Message Robert Haas 2019-08-12 12:11:50 Re: block-level incremental backup