From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Julien Rouhaud <rjuju123(at)gmail(dot)com>, "ldh(at)laurent-hasson(dot)com" <ldh(at)laurent-hasson(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 |
Date: | 2021-09-02 15:22:54 |
Message-ID: | 8276415b-5932-884f-e53f-13a3746a3a69@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On 8/31/21 1:55 PM, Andrew Dunstan wrote:
> On 8/31/21 11:37 AM, Julien Rouhaud wrote:
>> On Tue, Aug 31, 2021 at 10:51 PM ldh(at)laurent-hasson(dot)com
>> <ldh(at)laurent-hasson(dot)com> wrote:
>>> OK... I thought that track had been abandoned as per Julien's last message. Anyways, I'll be patient!
>>>
>> I just happened to have both standard installer and locally compiled
>> versions available, so I could confirm that I reproduced the problem
>> at least with the standard installer. Note that my message also said
>> " if default build on windows has NLS included". After looking a bit
>> more into the Windows build system, I confirm that NLS isn't included
>> by default so this is not the problem, as Andrew said.
>>
>> After installing gettext and a few other dependencies, adapting
>> config.pl I wish I could also confirm being able to reproduce the
>> problem on my build, but apparently I'm missing something as I can't
>> get any modification in config.pl have any effect. I'm not gonna
>> waste more time on that since Andrew is already in the middle of the
>> investigation.
>
>
> The culprit turns out to be the precise version of libiconv/libintl
> used. There is a slight difference between the versions used in the
> 11.13 installer and the 13.4 installer. We need to dig into performance
> more (e.g. why does the test take much longer on an NLS enabled build
> even when we are using 'initdb --no-locale'?) But I'm pretty confident
> now that this is the issue. I've started talks with our installer guys
> about fixing it.
>
>
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.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
Attachment | Content-Type | Size |
---|---|---|
image/png | 66.6 KB | |
image/png | 61.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Julien Rouhaud | 2021-09-02 15:34:23 | Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 |
Previous Message | Julien Rouhaud | 2021-09-01 05:14:24 | Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 |