Horton
Menu

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ranier Vilela <ranier.vf@gmail.com>
Cc: "ldh@laurent-hasson.com" <ldh@laurent-hasson.com>, Andrew Dunstan <andrew@dunslane.net>, Justin Pryzby <pryzby@telsasoft.com>, "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2021-08-29T13:35:05Z
Lists: pgsql-performance 
Ranier Vilela <ranier.vf@gmail.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