From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mladen Gogala <gogala.mladen@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Date: Sat, 21 Aug 2021 14:04:49 -0400
Message-ID: <2135629.1629569089@sss.pgh.pa.us> (raw)
In-Reply-To: <01186dcc-bf1e-0c25-b6e6-9a1c6b52d226@gmail.com>
References: <MN2PR15MB2560D77DFB58BD893E2EAAAD85C29@MN2PR15MB2560.namprd15.prod.outlook.com>
<MN2PR15MB2560AE2A878FBBE88DCFF33385C29@MN2PR15MB2560.namprd15.prod.outlook.com>
<2092859.1629558281@sss.pgh.pa.us>
<01186dcc-bf1e-0c25-b6e6-9a1c6b52d226@gmail.com>
Mladen Gogala <gogala.mladen@gmail.com> writes:
> I know that 14 is a beta version but the performance is significantly
> worse than v13 (I assume it's 13.4). Head revision is better than v14
> but still worse than v13. Can you expand a bit on the difference?
[ shrug... ] I don't see any meaningful differences between those
numbers --- they're within 3% or so across versions, which is less
than the margin of error considering I wasn't trying to control
for outside effects like CPU speed stepping. Microbenchmarks like
this one are notoriously noisy. Maybe there's some real difference
there, but these numbers aren't to be trusted that much.
What I was looking for was some evidence matching Laurent's report of
the exception-recovery path being 500X slower than non-exception.
That would have been obvious even with the sloppiest of measurements
... but I'm not seeing it.
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, gogala.mladen@gmail.com, pgsql-performance@lists.postgresql.org
Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
In-Reply-To: <2135629.1629569089@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