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

On 8/22/21 5:59 PM, ldh(at)laurent-hasson(dot)com wrote:
>
> > -----Original Message-----
> > From: Andrew Dunstan <andrew(at)dunslane(dot)net>
> > Sent: Sunday, August 22, 2021 17:27
> > To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>; ldh(at)laurent-hasson(dot)com
> > Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>; Ranier Vilela
> > <ranier(dot)vf(at)gmail(dot)com>; pgsql-performance(at)postgresql(dot)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(at)laurent-hasson(dot)com" <ldh(at)laurent-hasson(dot)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 you think 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