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

> -----Original Message-----
> From: Andrew Dunstan <andrew(at)dunslane(dot)net>
> Sent: Thursday, September 2, 2021 13:00
> To: Julien Rouhaud <rjuju123(at)gmail(dot)com>
> Cc: ldh(at)laurent-hasson(dot)com; Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>; Ranier
> Vilela <ranier(dot)vf(at)gmail(dot)com>; Justin Pryzby <pryzby(at)telsasoft(dot)com>;
> pgsql-performance(at)postgresql(dot)org
> Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2
> and 13.4
>
>
> On 9/2/21 11:34 AM, Julien Rouhaud wrote:
> > On Thu, Sep 2, 2021 at 11:22 PM Andrew Dunstan
> <andrew(at)dunslane(dot)net> wrote:
> >> Here are a couple of pictures of profiles made with a tool called
> >> sleepy. The bad profile is from release 13.4 built with the latest
> >> gettext, built with vcpkg. The good profile is the same build but
> >> using the intl-8.dll copied from the release 11.13 installer. The
> >> good run takes about a minute. The bad run takes about 30 minutes.
> >>
> >>
> >> I'm not exactly sure what the profiles tell us.
> > Isn't GetLocaleInfoA suspicious? Especially since the doc [1] says
> > that it shouldn't be called anymore unless you want to have
> > compatibility with OS from more than a decade ago?
> >
> > [1]
> > https://docs.microsoft.com/en-us/windows/win32/api/winnls/nf-
> winnls-ge
> > tlocaleinfoa
>
> Possibly, but the profile doesn't show it as having a great impact.
>
> Maybe surrounding code is affected.
>
> cheers
>
> andrew
>
>
> --
> Andrew Dunstan
> EDB: https://www.enterprisedb.com

Hello all,

Any further update or guidance on this issue at this time?

Thank you,
Laurent.