Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
От | Andrew Dunstan |
---|---|
Тема | Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 |
Дата | |
Msg-id | 7ff352d4-4879-5181-eb89-8a2046f928e6@dunslane.net обсуждение исходный текст |
Ответ на | Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 (Julien Rouhaud <rjuju123@gmail.com>) |
Ответы |
RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
|
Список | pgsql-performance |
On 9/2/21 11:34 AM, Julien Rouhaud wrote: > On Thu, Sep 2, 2021 at 11:22 PM Andrew Dunstan <andrew@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-getlocaleinfoa 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
В списке pgsql-performance по дате отправления: