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

2021-08-28 Thread l...@laurent-hasson.com
> -Original Message- > From: Tom Lane > Sent: Saturday, August 28, 2021 15:51 > To: l...@laurent-hasson.com > Cc: Andrew Dunstan ; Justin Pryzby > ; Ranier Vilela ; pgsql- > performa...@postgresql.org > Subject: Re: Big Performance drop of Exceptions in U

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

2021-08-28 Thread Tom Lane
"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

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

2021-08-28 Thread l...@laurent-hasson.com
> -Original Message- > From: Tom Lane > Sent: Friday, August 27, 2021 13:43 > To: l...@laurent-hasson.com > Cc: Justin Pryzby ; Ranier Vilela > ; pgsql-performa...@postgresql.org > 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 l...@laurent-hasson.com
> -Original Message- > From: Tom Lane > Sent: Friday, August 27, 2021 13:43 > To: l...@laurent-hasson.com > Cc: Justin Pryzby ; Ranier Vilela > ; pgsql-performa...@postgresql.org > Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 > an