RE: minimizing pg_stat_statements performance overhead

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Raymond Martin <ramarti(at)microsoft(dot)com>
Cc: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: RE: minimizing pg_stat_statements performance overhead
Date: 2019-07-15 21:03:45
Message-ID: alpine.DEB.2.21.1907152302410.8986@lancre
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Hello Raymond,

>> Sure, it definitely makes sense to reduce the overhead when the extension is disabled. I wanted to understand the source of performance issue, and your explanations where not enough for reproducing it.
> Thanks again Fabien. I am attaching the patch to this email in the hope of getting it approved during the next commit fest.
> I will continue trying to find a simple performance test to exemplify the performance degradation that I have seen with more complex workloads.

Patch applies and compiles cleanly. Global and local make check ok.

The patch adds an early exit in one of the hook when pgss is not enabled
on a given query. This seems to be a long time oversight of some earlier
additions which only had some (small or large depending) performance
impact.

About the comment "...and" -> "... and" (add a space)

Otherwise all is well.

--
Fabien.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2019-07-15 21:05:30 Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS)
Previous Message Fabien COELHO 2019-07-15 21:00:55 Re: Patch to document base64 encoding