> -----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.
