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

[l...@laurent-hasson.com]

   >  -----Original Message-----
   >  From: Tom Lane <t...@sss.pgh.pa.us>
   >  Sent: Saturday, August 28, 2021 15:51
   >  To: l...@laurent-hasson.com
   >  Cc: Andrew Dunstan <and...@dunslane.net>; Justin Pryzby
   >  <pry...@telsasoft.com>; Ranier Vilela <ranier...@gmail.com>; pgsql-
   >  performa...@postgresql.org
   >  Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2
   >  and 13.4
   >  
   >  "l...@laurent-hasson.com" <l...@laurent-hasson.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.