Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Date: 2021-08-21 18:04:49
Message-ID: 2135629.1629569089@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Mladen Gogala <gogala(dot)mladen(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2021-08-21 18:17:26 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Previous Message ldh@laurent-hasson.com 2021-08-21 16:01:16 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4