MIME-Version: 1.0
From: Joseph Hammerman <joe.hammerman@datadoghq.com>
Date: Mon, 8 Jul 2024 15:26:23 -0700
Message-ID: <CAHs7QM8VJ1pAYR7zdJ9GwbXhVbJEUnLw+sM=bMNNrXFMvaji8g@mail.gmail.com>
Subject: SQL: Chaining versus Pipelining
To: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e5ecf2061cc3e71c"
Archived-At: <https://www.postgresql.org/message-id/CAHs7QM8VJ1pAYR7zdJ9GwbXhVbJEUnLw%2BsM%3DbMNNrXFMvaji8g%40mail.gmail.com>
Precedence: bulk

--000000000000e5ecf2061cc3e71c
Content-Type: text/plain; charset="UTF-8"

Hi PgSQL general mailing lists,

In Postgres Weekly, I encountered this
<https://bugfactory.io/articles/using-transaction-chaining-to-reduce-server-round-trips/>
interesting article. The documentation
<https://www.postgresql.org/docs/current/plpgsql-transactions.html> on the
use of AND CHAIN is here. A co-worker is interested in the difference
between chaining and using the pipelining
<https://www.postgresql.org/docs/current/libpq-pipeline-mode.html> syntax.

They look pretty similar to me; it could be that one implementation is PG
specific and not part of the SQL standard or something. Can anyone shed any
light for us?

Thanks in advance for any assistance anyone can provide,
Joseph Hammerman

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

<div dir=3D"ltr">Hi PgSQL general mailing=C2=A0lists,<div><br></div><div>In=
 Postgres Weekly, I encountered <a href=3D"https://bugfactory.io/articles/u=
sing-transaction-chaining-to-reduce-server-round-trips/">this</a> interesti=
ng article. The <a href=3D"https://www.postgresql.org/docs/current/plpgsql-=
transactions.html">documentation</a> on the use of AND CHAIN is here. A co-=
worker is interested in the difference between=C2=A0chaining and using the =
<a href=3D"https://www.postgresql.org/docs/current/libpq-pipeline-mode.html=
">pipelining</a>=C2=A0syntax.</div><div><br></div><div>They look pretty sim=
ilar to me; it could be that one implementation is PG specific and not part=
 of the SQL standard or something. Can anyone shed any light for us?</div><=
div><br></div><div>Thanks in advance for any assistance anyone can provide,=
</div><div>Joseph Hammerman</div></div>

--000000000000e5ecf2061cc3e71c--