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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>
Cc: "ldh(at)laurent-hasson(dot)com" <ldh(at)laurent-hasson(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, 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-08-29 13:35:05
Message-ID: 1124170.1630244105@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Ranier Vilela <ranier(dot)vf(at)gmail(dot)com> writes:
> I retested this case with HEAD, and it seems to me that NLS does affect it.

Sure, there's no question that message translation will have *some* cost.
But on my machine it is an incremental tens-of-percent kind of cost,
and that is the result you're getting as well. So it's not very clear
where these factor-of-several-hundred differences are coming from.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ranier Vilela 2021-08-29 14:00:44 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Previous Message Ranier Vilela 2021-08-29 12:53:57 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4