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

Hello all,

Any update on this issue?

Thank you!
Laurent.

> -----Original Message-----
> From: ldh(at)laurent-hasson(dot)com <ldh(at)laurent-hasson(dot)com>
> Sent: Sunday, August 22, 2021 23:23
> To: Justin Pryzby <pryzby(at)telsasoft(dot)com>; Ranier Vilela
> <ranier(dot)vf(at)gmail(dot)com>
> Cc: 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
>
>
>
> > -----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.
>