From: Tom Lane <tgl@sss.pgh.pa.us>
To: ldh@laurent-hasson.com <ldh@laurent-hasson.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Date: Sat, 21 Aug 2021 14:17:26 -0400
Message-ID: <2136207.1629569846@sss.pgh.pa.us> (raw)
In-Reply-To: <MN2PR15MB25607BDC72A325CA9B9D3E3385C29@MN2PR15MB2560.namprd15.prod.outlook.com>
References: <MN2PR15MB2560D77DFB58BD893E2EAAAD85C29@MN2PR15MB2560.namprd15.prod.outlook.com>
<MN2PR15MB2560AE2A878FBBE88DCFF33385C29@MN2PR15MB2560.namprd15.prod.outlook.com>
<2092859.1629558281@sss.pgh.pa.us>
<MN2PR15MB25607BDC72A325CA9B9D3E3385C29@MN2PR15MB2560.namprd15.prod.outlook.com>
"ldh@laurent-hasson.com" <ldh@laurent-hasson.com> writes:
> So you mean that on average, the 4x overhead of exceptions is around what you'd expect?
Doesn't surprise me any, no. Exception recovery has to clean up after
a wide variety of possible errors, with only minimal assumptions about
what the system state had been. So it's expensive. More to the point,
the overhead's been broadly the same for quite some time.
> As for results in general, yes, your numbers look pretty uniform across versions. On my end, comparing V11.2 vs V13.4 shows a much different picture!
I'm baffled why that should be so. I do not think any of the extensions
you mention add any exception-recovery overhead, especially not in
sessions that haven't used them.
As an additional test, I checked out 11.2 exactly, and got timings
that pretty much matched my previous test of v11 branch tip. So that
eliminates the theory that we broke something since 11.2 in a patch
that was also back-patched into that branch.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, ldh@laurent-hasson.com
Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
In-Reply-To: <2136207.1629569846@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox