> -----Original Message----- > From: Andrew Dunstan <and...@dunslane.net> > Sent: Thursday, September 2, 2021 13:00 > To: Julien Rouhaud <rjuju...@gmail.com> > Cc: l...@laurent-hasson.com; Tom Lane <t...@sss.pgh.pa.us>; Ranier > Vilela <ranier...@gmail.com>; Justin Pryzby <pry...@telsasoft.com>; > pgsql-performa...@postgresql.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 > <and...@dunslane.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.