> -----Original Message----- > From: Tom Lane <tgl@xxxxxxxxxxxxx> > Sent: Saturday, August 28, 2021 15:51 > To: ldh@xxxxxxxxxxxxxxxxxx > Cc: Andrew Dunstan <andrew@xxxxxxxxxxxx>; Justin Pryzby > <pryzby@xxxxxxxxxxxxx>; Ranier Vilela <ranier.vf@xxxxxxxxx>; pgsql- > performance@xxxxxxxxxxxxxx > Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 > and 13.4 > > "ldh@xxxxxxxxxxxxxxxxxx" <ldh@xxxxxxxxxxxxxxxxxx> 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.
