Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Date
Msg-id 2135629.1629569089@sss.pgh.pa.us
Whole thread Raw
In response to Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4  (Mladen Gogala <gogala.mladen@gmail.com>)
Responses RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
List pgsql-performance
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



pgsql-performance by date:

Previous
From: "ldh@laurent-hasson.com"
Date:
Subject: RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Next
From: Tom Lane
Date:
Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4