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

> -Original Message- > From: Justin Pryzby > Sent: Sunday, August 22, 2021 20:43 > To: Ranier Vilela > Cc: l...@laurent-hasson.com; Tom Lane ; 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

On Sun, Aug 22, 2021 at 08:44:34PM -0300, Ranier Vilela wrote: > > If there is any way I can help further... I am definitely not able to do a > > dev environment and local build, but if we have a windows developer > > reproducing the issue between 11 and 12, then that should help. If someone > > ma

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

Em dom., 22 de ago. de 2021 às 18:12, l...@laurent-hasson.com < l...@laurent-hasson.com> escreveu: > > >> -Original Message- >> From: Tom Lane >> Sent: Sunday, August 22, 2021 16:11 >> To: l...@laurent-hasson.com >> Cc: Justin Pryzby ; Ranier Vilela >> ; pgsq

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

Em dom., 22 de ago. de 2021 às 14:50, Tom Lane escreveu: > Justin Pryzby writes: > > This looks useful, thanks. It seems like maybe win64 builds are very > slow > > running this: > > > exec_stmt_block() / > > BeginInternalSubTransaction() / > > AbortSubTransaction() / > > reschedule_timeouts()

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

On 8/22/21 5:59 PM, l...@laurent-hasson.com wrote: > >> -Original Message- >> From: Andrew Dunstan >> Sent: Sunday, August 22, 2021 17:27 >> To: Tom Lane ; l...@laurent-hasson.com >> Cc: Justin Pryzby ; Ranier Vilela >> ; pgsql-performa...@postgresql.org >

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

> -Original Message- > From: Andrew Dunstan > Sent: Sunday, August 22, 2021 17:27 > To: Tom Lane ; l...@laurent-hasson.com > Cc: Justin Pryzby ; Ranier Vilela > ; pgsql-performa...@postgresql.org > Subject: Re: Big Performance drop of Exceptions in UDFs betwee

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

On 8/22/21 4:11 PM, Tom Lane wrote: > "l...@laurent-hasson.com" writes: >> I do have a Linux install of 13.3, and things work beautifully, so this is >> definitely a Windows thing here that started in V12. > It's good to have a box around it, but that's still a pretty large > box :-(. > > I'm h

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

> -Original Message- > From: Tom Lane > Sent: Sunday, August 22, 2021 16:11 > 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

"l...@laurent-hasson.com" writes: > I do have a Linux install of 13.3, and things work beautifully, so this is > definitely a Windows thing here that started in V12. It's good to have a box around it, but that's still a pretty large box :-(. I'm hoping that one of our Windows-using developers w

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

> -Original Message- > From: l...@laurent-hasson.com > Sent: Sunday, August 22, 2021 15:29 > To: Tom Lane > Cc: Justin Pryzby ; Ranier Vilela > ; pgsql-performa...@postgresql.org > Subject: RE: Big Performance drop of Exceptions in UDFs between V11.2 > a

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

> -Original Message- > From: Tom Lane > Sent: Sunday, August 22, 2021 15:24 > 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

"l...@laurent-hasson.com" writes: > So, now, in summary: > - I have tried V13.4, V12.3, 11.13, 11.2, 11.1 on several Windows VMs and my > personal laptop (no VM). > - All V11.x seem to behave uniformly. > - Starting with 12.3, I am experiencing the major slowdown in the "with > exceptions" scen

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

> -Original Message- > From: l...@laurent-hasson.com > Sent: Sunday, August 22, 2021 14:37 > To: Tom Lane ; Justin Pryzby > > Cc: Ranier Vilela ; pgsql- > performa...@postgresql.org > Subject: RE: Big Performance drop of Exceptions in UDFs between V11.2

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

> -Original Message- > From: Tom Lane > Sent: Sunday, August 22, 2021 13:51 > To: Justin Pryzby > Cc: Ranier Vilela ; l...@laurent-hasson.com; > 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

> -Original Message- > From: Justin Pryzby > Sent: Sunday, August 22, 2021 11:48 > To: Ranier Vilela > Cc: l...@laurent-hasson.com; Tom Lane ; pgsql- > performa...@postgresql.org > Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 > a

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

Justin Pryzby writes: > This looks useful, thanks. It seems like maybe win64 builds are very slow > running this: > exec_stmt_block() / > BeginInternalSubTransaction() / > AbortSubTransaction() / > reschedule_timeouts() / > schedule_alarm() / > setitimer() / > pg_timer_thread() / > WaitForSingl

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

On Sun, Aug 22, 2021 at 10:50:47AM -0300, Ranier Vilela wrote: > > Tried to check this with Very Sleepy at Windows 10 (bare metal). > > Not sure it can help if someone can guide how to test this better? > explain (analyze,buffers,COSTS,TIMING) select MAX(toFloat(a, null)) as "a" > from sampletest