MIME-Version: 1.0
References: <CACsoHGCWgBJ4BKLtC=Q305WBEM+K2fj3BmzvEVYEGRg896QOYg@mail.gmail.com>
 <3628359.1731076788@sss.pgh.pa.us>
In-Reply-To: <3628359.1731076788@sss.pgh.pa.us>
From: =?UTF-8?Q?Micha=C5=82_Albrycht?= <michalalbrycht@gmail.com>
Date: Fri, 8 Nov 2024 18:44:40 +0100
Message-ID: <CACsoHGCsXBYbv__t2xDVxth1EroBTsO=SnfJror4HCy-XtN4Lg@mail.gmail.com>
Subject: Re: Why plpython functions increase transaction counter much more
 then plpgsql functions?
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000d5a30206266a4efd"
Archived-At: <https://www.postgresql.org/message-id/CACsoHGCsXBYbv__t2xDVxth1EroBTsO%3DSnfJror4HCy-XtN4Lg%40mail.gmail.com>
Precedence: bulk

--000000000000d5a30206266a4efd
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

>
> A quick look at PLy_spi_execute_query shows that it runs each command
> in a subtransaction.  It pretty much has to, because the coding rules
> for a Python method don't permit it to just longjmp out of the Python
> interpreter, so it has to set up a subtransaction so it can catch any
> error.  In this example, each subtransaction will consume an XID.
>
> That makes sense. Thank you very much.
Regards,

Micha=C5=82 Albrycht

--000000000000d5a30206266a4efd
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_quote"><blockquote class=3D"gmail_quot=
e" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204)=
;padding-left:1ex">A quick look at PLy_spi_execute_query shows that it runs=
 each command<br>
in a subtransaction.=C2=A0 It pretty much has to, because the coding rules<=
br>
for a Python method don&#39;t permit it to just longjmp out of the Python<b=
r>
interpreter, so it has to set up a subtransaction so it can catch any<br>
error.=C2=A0 In this example, each subtransaction will consume an XID.<br><=
br></blockquote><div>That makes sense. Thank you very much.</div><div>Regar=
ds,</div><div><br></div><div>Micha=C5=82 Albrycht=C2=A0</div></div></div>

--000000000000d5a30206266a4efd--