> -----Original Message----- > From: Andrew Dunstan <andrew@xxxxxxxxxxxx> > Sent: Thursday, September 2, 2021 13:00 > To: Julien Rouhaud <rjuju123@xxxxxxxxx> > Cc: ldh@xxxxxxxxxxxxxxxxxx; Tom Lane <tgl@xxxxxxxxxxxxx>; Ranier > Vilela <ranier.vf@xxxxxxxxx>; Justin Pryzby <pryzby@xxxxxxxxxxxxx>; > pgsql-performance@xxxxxxxxxxxxxx > 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@xxxxxxxxxxxx> 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.
