pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andrew Dunstan <andrew@dunslane.net>
To: Julien Rouhaud <rjuju123@gmail.com>
Cc: ldh@laurent-hasson.com <ldh@laurent-hasson.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Ranier Vilela <ranier.vf@gmail.com>
Cc: Justin Pryzby <pryzby@telsasoft.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Date: Thu, 2 Sep 2021 12:59:51 -0400
Message-ID: <7ff352d4-4879-5181-eb89-8a2046f928e6@dunslane.net> (raw)
In-Reply-To: <CAOBaU_bxyh-V0_JWi6P9ttypc4YmdvVw_FGLEnTcw37W695-TA@mail.gmail.com>
References: <MN2PR15MB2560AE2A878FBBE88DCFF33385C29@MN2PR15MB2560.namprd15.prod.outlook.com>
	<CAEudQAo75GRW3jMsJLXcN1ufXj=BTdkeO5cA_3yqHHJkCWqVag@mail.gmail.com>
	<MN2PR15MB25605C2D5D70A6EAF99B5F6085CA9@MN2PR15MB2560.namprd15.prod.outlook.com>
	<1177685.1630253948@sss.pgh.pa.us>
	<MN2PR15MB2560B122A49C4C06483183D785CB9@MN2PR15MB2560.namprd15.prod.outlook.com>
	<CAOBaU_bYtEDWwj+6-RsGkikP3xKmq=J8TBrOqUrw7h8CVoAVuA@mail.gmail.com>
	<MN2PR15MB25604A1E1EBBFDB13A736BB385CB9@MN2PR15MB2560.namprd15.prod.outlook.com>
	<MN2PR15MB256056461A0DC961388ECFA985CC9@MN2PR15MB2560.namprd15.prod.outlook.com>
	<68e654db-f345-7665-7f3e-25713de730ba@dunslane.net>
	<MN2PR15MB2560702C8328CE277CCEE4BF85CC9@MN2PR15MB2560.namprd15.prod.outlook.com>
	<CAOBaU_aqbiG9rFtoGUdEY2NvAcoKizKsfOY3V1VDqrRxeLiTXQ@mail.gmail.com>
	<6c68ee84-a4b7-7935-3804-49c6d69a0052@dunslane.net>
	<8276415b-5932-884f-e53f-13a3746a3a69@dunslane.net>
	<CAOBaU_bxyh-V0_JWi6P9ttypc4YmdvVw_FGLEnTcw37W695-TA@mail.gmail.com>


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






view thread (78+ messages)  latest in thread

Message-ID: <7ff352d4-4879-5181-eb89-8a2046f928e6@dunslane.net>
Permalink:  ../7ff352d4-4879-5181-eb89-8a2046f928e6@dunslane.net/
Also on:    postgresql.org/message-id/7ff352d4-4879-5181-eb89-8a2046f928e6@dunslane.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: andrew@dunslane.net, rjuju123@gmail.com, ldh@laurent-hasson.com, tgl@sss.pgh.pa.us, ranier.vf@gmail.com, pryzby@telsasoft.com
  Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
  In-Reply-To: <7ff352d4-4879-5181-eb89-8a2046f928e6@dunslane.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox