Re: compute_query_id and pg_stat_statements - Mailing list pgsql-hackers

From Tom Lane
Subject Re: compute_query_id and pg_stat_statements
Date
Msg-id 1787238.1620956822@sss.pgh.pa.us
Whole thread Raw
In response to Re: compute_query_id and pg_stat_statements  (Julien Rouhaud <rjuju123@gmail.com>)
Responses Re: compute_query_id and pg_stat_statements
List pgsql-hackers
Julien Rouhaud <rjuju123@gmail.com> writes:
> On Fri, May 14, 2021 at 3:12 AM Bruce Momjian <bruce@momjian.us> wrote:
>> I was surprised it was ~2%.

> Just to be clear, the 2% was a worst case scenario, ie. a very fast
> read-only query on small data returning a single row.  As soon as you
> get something more realistic / expensive the overhead goes away.

Of course, for plenty of people that IS the realistic scenario that
they care about max performance for.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: OOM in spgist insert
Next
From: Justin Pryzby
Date:
Subject: Re: PG 14 release notes, first draft