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@laurent-hasson.com <ldh@laurent-hasson.com>
   >  Sent: Sunday, August 22, 2021 23:23
   >  To: Justin Pryzby <pryzby@telsasoft.com>; Ranier Vilela
   >  <ranier.vf@gmail.com>
   >  Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-performance@postgresql.org
   >  Subject: RE: Big Performance drop of Exceptions in UDFs between V11.2
   >  and 13.4
   >  
   >  
   >  
   >     >  -----Original Message-----
   >     >  From: Justin Pryzby <pryzby@telsasoft.com>
   >     >  Sent: Sunday, August 22, 2021 20:43
   >     >  To: Ranier Vilela <ranier.vf@gmail.com>
   >     >  Cc: ldh@laurent-hasson.com; Tom Lane <tgl@sss.pgh.pa.us>; pgsql-
   >     >  performance@postgresql.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.
   >