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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Дата
Msg-id 2135629.1629569089@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4  (Mladen Gogala <gogala.mladen@gmail.com>)
Ответы RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4  ("ldh@laurent-hasson.com" <ldh@laurent-hasson.com>)
Список 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 по дате отправления:

Предыдущее
От: "ldh@laurent-hasson.com"
Дата:
Сообщение: RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4