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: "ldh@laurent-hasson.com" <ldh@laurent-hasson.com>
Cc: Justin Pryzby <pryzby@telsasoft.com>, Ranier Vilela <ranier.vf@gmail.com>, "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2021-08-27T17:43:25Z
Lists: pgsql-performance 
"ldh@laurent-hasson.com" <ldh@laurent-hasson.com> writes:
> That being said, do you have any suggestion how I could circumvent the
> issue altogether?

Based on Andrew's report, it seems like you might be able to work around
it for the time being by disabling message translations, i.e.
	SET lc_messages = 'C';
Even if that's not acceptable in your work environment, it would be useful
to verify that you see an improvement from it.

			regards, tom lane