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

> -----Original Message-----
> From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
> Sent: Sunday, August 22, 2021 20:43
> To: Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>
> Cc: ldh(at)laurent-hasson(dot)com; Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>; pgsql-
> performance(at)postgresql(dot)org
> Subject: 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 makes a debug build available to me, I can provide
> > > additional help based on that.
> >
> > Please, download from this link (Google Drive):
> >
> > https://drive.google.com/file/d/13kPbNmk54lR6t-lwcwi-
> 63UdM55sA27t/view
> > ?usp=sharing
>
> Laurent gave a recipe to reproduce the problem, and you seemed to be
> able to reproduce it, so I think Laurent's part is done. The burden now
> lies with postgres developers to isolate the issue, and Andrew said he
> would bisect to look for the culprit commit.
>
> --
> Justin

Hello Ranier,
I am not sure what to do with that build. I am a Java/JavaScript guy these days. I haven't coded C/C++ in over 15 years now and I don't have a debugging environment 😊 If I can run the scenario I created and get a log file, that I can do if that helps.

Justin, I think I agree with you although I am concerned that none of you were able to truly reproduce the results I have now reproduced on plain base-line installs on 2 VMs (Windows Server 2012) and a laptop (Windows 10 pro), across multiple versions of the installer (11, 12 and 13).

In any case, i'll do my best to help. If you think you have a fix and it's in one dll or exe and I can just manually patch a 13.4 install and test again, I'll do that with pleasure.

Thank you,
Laurent.