Hello all, Any update on this issue? Thank you! Laurent. > -----Original Message----- > From: ldh@xxxxxxxxxxxxxxxxxx <ldh@xxxxxxxxxxxxxxxxxx> > Sent: Sunday, August 22, 2021 23:23 > To: Justin Pryzby <pryzby@xxxxxxxxxxxxx>; Ranier Vilela > <ranier.vf@xxxxxxxxx> > Cc: Tom Lane <tgl@xxxxxxxxxxxxx>; pgsql-performance@xxxxxxxxxxxxxx > Subject: RE: Big Performance drop of Exceptions in UDFs between V11.2 > and 13.4 > > > > > -----Original Message----- > > From: Justin Pryzby <pryzby@xxxxxxxxxxxxx> > > Sent: Sunday, August 22, 2021 20:43 > > To: Ranier Vilela <ranier.vf@xxxxxxxxx> > > Cc: ldh@xxxxxxxxxxxxxxxxxx; Tom Lane <tgl@xxxxxxxxxxxxx>; pgsql- > > performance@xxxxxxxxxxxxxx > > 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. >
