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

On 8/22/21 5:59 PM, ldh@laurent-hasson.com wrote:
>
>    >  -----Original Message-----
>    >  From: Andrew Dunstan <andrew@dunslane.net>
>    >  Sent: Sunday, August 22, 2021 17:27
>    >  To: Tom Lane <tgl@sss.pgh.pa.us>; ldh@laurent-hasson.com
>    >  Cc: Justin Pryzby <pryzby@telsasoft.com>; Ranier Vilela
>    >  <ranier.vf@gmail.com>; pgsql-performance@postgresql.org
>    >  Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2
>    >  and 13.4
>    >  
>    >  
>    >  On 8/22/21 4:11 PM, Tom Lane wrote:
>    >  > "ldh@laurent-hasson.com" <ldh@laurent-hasson.com> writes:
>    >  >> I do have a Linux install of 13.3, and things work beautifully, so this is
>    >  definitely a Windows thing here that started in V12.
>    >  > It's good to have a box around it, but that's still a pretty large box
>    >  > :-(.
>    >  >
>    >  > I'm hoping that one of our Windows-using developers will see if they
>    >  > can reproduce this, and if so, try to bisect where it started.
>    >  > Not sure how to make further progress without that.
>    >  >
>    >  >
>    >  
>    >  
>    >  Can do. Assuming the assertion that it started in Release 12 is correct, I
>    >  should be able to find it by bisecting between the branch point for 12
>    >  and the tip of that branch. That's a little over 20 probes by my
>    >  calculation.
>    >  
>    >  
>    >  cheers
>    >  
>    >  
>    >  andrew
>    >  
>    >  
>    >  --
>    >  Andrew Dunstan
>    >  EDB: https://www.enterprisedb.com
>
>
> I tried it on 11.13 and 12.3. Is there a place where I could download 12.1 and 12.2 and test that? Is it worth it or
youthink you have all you need?
 
>


I think I have everything I need.


Step one will be to verify that the difference exists between the branch
point and the tip of release 12. Once that's done it will be a matter of
probing until the commit at fault is identified.


cheers


andrew



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