Horton
Menu

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

Julien Rouhaud <rjuju123@gmail.com>

View thread
From: Julien Rouhaud <rjuju123@gmail.com>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: "ldh@laurent-hasson.com" <ldh@laurent-hasson.com>, Tom Lane <tgl@sss.pgh.pa.us>, Ranier Vilela <ranier.vf@gmail.com>, Justin Pryzby <pryzby@telsasoft.com>, "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2021-09-02T15:34:23Z
Lists: pgsql-performance 
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