On 8/22/21 5:59 PM, ldh@xxxxxxxxxxxxxxxxxx wrote: > > > -----Original Message----- > > From: Andrew Dunstan <andrew@xxxxxxxxxxxx> > > Sent: Sunday, August 22, 2021 17:27 > > To: Tom Lane <tgl@xxxxxxxxxxxxx>; ldh@xxxxxxxxxxxxxxxxxx > > Cc: Justin Pryzby <pryzby@xxxxxxxxxxxxx>; Ranier Vilela > > <ranier.vf@xxxxxxxxx>; pgsql-performance@xxxxxxxxxxxxxx > > 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@xxxxxxxxxxxxxxxxxx" <ldh@xxxxxxxxxxxxxxxxxx> 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
