Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mLq4H-00043N-CS for pgsql-performance@arkaria.postgresql.org; Thu, 02 Sep 2021 17:00:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mLq4G-0007VI-2K for pgsql-performance@arkaria.postgresql.org; Thu, 02 Sep 2021 17:00:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mLq4F-0007V9-QO for pgsql-performance@lists.postgresql.org; Thu, 02 Sep 2021 16:59:59 +0000 Received: from relay8-d.mail.gandi.net ([217.70.183.201]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mLq4C-0007Jx-S2 for pgsql-performance@postgresql.org; Thu, 02 Sep 2021 16:59:59 +0000 Received: (Authenticated sender: adsend@dunslane.net) by relay8-d.mail.gandi.net (Postfix) with ESMTPSA id D459E1BF208; Thu, 2 Sep 2021 16:59:53 +0000 (UTC) Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 To: Julien Rouhaud Cc: "ldh@laurent-hasson.com" , Tom Lane , Ranier Vilela , Justin Pryzby , "pgsql-performance@postgresql.org" References: <1177685.1630253948@sss.pgh.pa.us> <68e654db-f345-7665-7f3e-25713de730ba@dunslane.net> <6c68ee84-a4b7-7935-3804-49c6d69a0052@dunslane.net> <8276415b-5932-884f-e53f-13a3746a3a69@dunslane.net> From: Andrew Dunstan Message-ID: <7ff352d4-4879-5181-eb89-8a2046f928e6@dunslane.net> Date: Thu, 2 Sep 2021 12:59:51 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.4.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 9/2/21 11:34 AM, Julien Rouhaud wrote: > On Thu, Sep 2, 2021 at 11:22 PM Andrew Dunstan 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