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

> -----Original Message-----
> From: Andrew Dunstan <andrew(at)dunslane(dot)net>
> Sent: Tuesday, August 31, 2021 09:40
> To: ldh(at)laurent-hasson(dot)com; Julien Rouhaud <rjuju123(at)gmail(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
> Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2
> and 13.4
>
>
> On 8/30/21 10:18 PM, ldh(at)laurent-hasson(dot)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 installer and the issue
> disappeared!!! I think this is proof that it's not my personal
> environment, nor something intrinsic in 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

OK... I thought that track had been abandoned as per Julien's last message. Anyways, I'll be patient!

Thank you for all the work.
Laurent.