Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 - Mailing list pgsql-performance

From Andrew Dunstan
Subject Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Date
Msg-id 68e654db-f345-7665-7f3e-25713de730ba@dunslane.net
Whole thread Raw
In response to RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4  ("ldh@laurent-hasson.com" <ldh@laurent-hasson.com>)
Responses RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
List pgsql-performance
On 8/30/21 10:18 PM, ldh@laurent-hasson.com wrote:
>    >  I see on https://www.postgresql.org/download/ that there is a different
>    >  installer from 2ndQuadrant. I am going to try that one and see what I
>    >  come up with. Are there any other "standard" distros of Postgres that I
>    >  could try out?
>    >  
>    >  I found out I could download Visual Studio community edition so I am
>    >  trying this, but may not have the time to get through a build any time
>    >  soon as per my unfamiliarity with the process. I'll follow Ranier's steps
>    >  and see if that gets me somewhere.
>    >  
>    >  Thank you,
>    >  Laurent.
>
>
> Hello all,
>
> I think I had a breakthrough. I tried to create a local build and wasn't able to. But I downloaded the 2nd Quadrant
installerand the issue disappeared!!! I think this is proof that it's not my personal environment, nor something
intrinsicin the codebase, but definitely something in the standard EDB installer.
 
>
>

No, you're on the wrong track. As I reported earlier, I have reproduced
this issue with a vanilla build which has no installer involvement
whatsoever.

I'm pretty sure the reason you are not seeing this with the 2ndQuadrant
installer is quite simple: it wasn't build with NLS support.

Let me repeat what I said earlier. I will get to the bottom of this.
Please be patient and stop running after red herrings.


cheers


andrew


--
Andrew Dunstan
EDB: https://www.enterprisedb.com




pgsql-performance by date:

Previous
From: "Michel SALAIS"
Date:
Subject: RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Next
From: "ldh@laurent-hasson.com"
Date:
Subject: RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4