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

From: "ldh(at)laurent-hasson(dot)com" <ldh(at)laurent-hasson(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>, Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Date: 2021-08-22 21:59:00
Message-ID: MN2PR15MB2560DD5D72E834B11D84D12E85C39@MN2PR15MB2560.namprd15.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> -----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?

Thanks,
Laurent.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Dunstan 2021-08-22 22:11:32 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Previous Message Andrew Dunstan 2021-08-22 21:26:30 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4