RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
ldh@laurent-hasson.com <ldh@laurent-hasson.com>
From: "ldh@laurent-hasson.com" <ldh@laurent-hasson.com>
To: Andrew Dunstan <andrew@dunslane.net>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: Justin Pryzby <pryzby@telsasoft.com>, Ranier Vilela <ranier.vf@gmail.com>, "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2021-08-22T21:59:00Z
Lists: pgsql-performance
> -----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 you think you have all you need? Thanks, Laurent.