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