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

2021-08-26 Thread [email protected]
Hello all,

Any update on this issue?

Thank you!
Laurent.

   >  -Original Message-
   >  From: [email protected] 
   >  Sent: Sunday, August 22, 2021 23:23
   >  To: Justin Pryzby ; Ranier Vilela
   >  
   >  Cc: Tom Lane ; [email protected]
   >  Subject: RE: Big Performance drop of Exceptions in UDFs between V11.2
   >  and 13.4
   >  
   >  
   >  
   > >  -Original Message-
   > >  From: Justin Pryzby 
   > >  Sent: Sunday, August 22, 2021 20:43
   > >  To: Ranier Vilela 
   > >  Cc: [email protected]; Tom Lane ; pgsql-
   > >  [email protected]
   > >  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.
   >  



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

2021-08-26 Thread Andrew Dunstan


On 8/26/21 10:47 AM, [email protected] wrote:
> Hello all,
>
> Any update on this issue?



Please don't top-post.


We are working on the issue. Please be patient.


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com





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

2021-08-26 Thread [email protected]


   >  -Original Message-
   >  From: Andrew Dunstan 
   >  Sent: Thursday, August 26, 2021 12:39
   >  To: [email protected]; Justin Pryzby ;
   >  Ranier Vilela 
   >  Cc: Tom Lane ; [email protected]
   >  Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2
   >  and 13.4
   >  
   >  
   >  On 8/26/21 10:47 AM, [email protected] wrote:
   >  > Hello all,
   >  >
   >  > Any update on this issue?
   >  
   >  
   >  
   >  Please don't top-post.
   >  
   >  
   >  We are working on the issue. Please be patient.
   >  
   >  
   >  cheers
   >  
   >  
   >  andrew
   >  
   >  --
   >  Andrew Dunstan
   >  EDB: https://www.enterprisedb.com


OK... Outlook automatically top posts and I forgot.

I am being patient.

Thanks,
Laurent.