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

2021-08-28 Thread [email protected]
> -Original Message- > From: Tom Lane > Sent: Friday, August 27, 2021 13:43 > To: [email protected] > Cc: Justin Pryzby ; Ranier Vilela > ; [email protected] > Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 > an

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

2021-08-28 Thread [email protected]
> -Original Message- > From: Tom Lane > Sent: Friday, August 27, 2021 13:43 > To: [email protected] > Cc: Justin Pryzby ; Ranier Vilela > ; [email protected] > Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 > an

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

2021-08-28 Thread Tom Lane
"[email protected]" 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

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

2021-08-28 Thread [email protected]
> -Original Message- > From: Tom Lane > Sent: Saturday, August 28, 2021 15:51 > To: [email protected] > Cc: Andrew Dunstan ; Justin Pryzby > ; Ranier Vilela ; pgsql- > [email protected] > Subject: Re: Big Performance drop of Exceptions in U