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

> -----Original Message-----
> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Sent: Saturday, August 28, 2021 15:51
> To: ldh(at)laurent-hasson(dot)com
> Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>; Justin Pryzby
> <pryzby(at)telsasoft(dot)com>; Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>; pgsql-
> performance(at)postgresql(dot)org
> Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2
> and 13.4
>
> "ldh(at)laurent-hasson(dot)com" <ldh(at)laurent-hasson(dot)com> writes:
> > SET lc_messages = 'C';
> > show lc_messages; --> OK 'C'
>
> > explain (analyze,buffers,COSTS,TIMING) select MAX(toFloat(b, null)) as
> > "b" from sampletest ...
> > Execution Time: 175.600 ms
>
> > explain (analyze,buffers,COSTS,TIMING) select MAX(toFloat(a, null)) as
> > "a" from sampletest ...
> > Execution Time: 88031.585 ms
>
> > Doesn't seem to make a difference unless I misunderstood what you
> were asking for regarding the locale?
>
> Hmm. This suggests that whatever effect Andrew found with NLS is
> actually not the explanation for your problem. So I'm even more
> confused than before.
>
> regards, tom lane

I am so sorry to hear... So, curious on my end: is this something that you are not able to reproduce on your environments? On my end, I did reproduce it on different VMs and my local laptop, across windows Server 2012 and Windows 10, so I'd figure it would be pretty easy to reproduce?

Thank you!
Laurent.