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

Ranier Vilela <ranier.vf@gmail.com>

From: Ranier Vilela <ranier.vf@gmail.com>
To: "ldh@laurent-hasson.com" <ldh@laurent-hasson.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Justin Pryzby <pryzby@telsasoft.com>, "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2021-08-22T23:44:34Z
Lists: pgsql-performance
Em dom., 22 de ago. de 2021 às 18:12, ldh@laurent-hasson.com <
ldh@laurent-hasson.com> escreveu:

>
>
>    >  -----Original Message-----
>    >  From: Tom Lane <tgl@sss.pgh.pa.us>
>    >  Sent: Sunday, August 22, 2021 16:11
>    >  To: 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
>    >
>    >  "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.
>    >
>    >                    regards, tom lane
>
> Hello Tom,
>
> If there is any way I can help further... I am definitely not able to do a
> dev environment and local build, but if we have a windows developer
> reproducing the issue between 11 and 12, then that should help. If someone
> makes a debug build available to me, I can provide additional help based on
> that.
>
Please, download from this link (Google Drive):

https://drive.google.com/file/d/13kPbNmk54lR6t-lwcwi-63UdM55sA27t/view?usp=sharing

Postgres Debug (64 bits) HEAD.

regards,
Ranier Vilela