Feedback-ID: i0fe9450f:Fastmail
Date: Wed, 19 Mar 2025 11:28:54 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Jelte Fennema-Nio <postgres@jeltef.nl>
Cc: Anthonin Bonnefoy <anthonin.bonnefoy@datadoghq.com>,
	Daniel Verite <daniel@manitou-mail.org>,
	PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Add Pipelining support in psql
Message-ID: <Z9or5qJwixm_PDC-@paquier.xyz>
References: 
 <CAGECzQRe3pHYvEAZz5Nv9AKzS2nYFLKEfgQCgd5Gr54Um5UFHg@mail.gmail.com>
 <d8aa9cb9-2fa1-464e-b1f1-63a68924b95f@manitou-mail.org>
 <CAO6_Xqq4JEHRaGyC=r+dpi0Ejbp2P3aUo-KfR2NuipCvE-o_ZA@mail.gmail.com>
 <Z9jDU_v_eGbZNkCU@paquier.xyz>
 <CAO6_Xqo=fNh0KCRZG7T18OZfjiabeL-t4C6mkXsz-3dAZ1YwTA@mail.gmail.com>
 <CAGECzQS=nVLg0VpPrWCQT3ANFhC6iR=p8Oe6edgqGDUUCGLiwg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="EZsoJ2vbZMS5ztzX"
Content-Disposition: inline
In-Reply-To: 
 <CAGECzQS=nVLg0VpPrWCQT3ANFhC6iR=p8Oe6edgqGDUUCGLiwg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/Z9or5qJwixm_PDC-%40paquier.xyz>
Precedence: bulk


--EZsoJ2vbZMS5ztzX
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Tue, Mar 18, 2025 at 10:27:38AM +0100, Jelte Fennema-Nio wrote:
> One thing that comes to mind that I think would be quite useful and
> pretty easy to implement if we have this functionality within a
> pipeline: An \extended command. That puts psql in "extended protocol
> mode" (without enabling pipelining). In "extended protocol mode" all
> queries would automatically be sent using PQsendQueryParams. That
> would remove the need to use \bind anymore outside of a pipeline
> either.

How does that help when passing parameter values?  \bind is here to be
able to pass down parameter values to queries that are prepared, so we
cannot bypass it as the parameter values need to be passed to the
\bind meta-command itself.

Perhaps an \extended command that behaves outside a pipeline makes
sense to force the use of queries without parameters to use the
extended mode, but I cannot get much excited about the concept knowing
all the meta-commands we have now (not talking about the pipeline
part, which is different, as we can treat queries in batches).
--
Michael

--EZsoJ2vbZMS5ztzX
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmfaK+YACgkQnvQgOdby
QH2LkA/9EPDK2GNhrNqlq9LaWOwB7sIUo2aG3/FuZtA/QK+Y03fCKj0ObhDRjZwh
HkJ9e+6sjXJXH+e32FXOk1xKqyJuYKarKDtFXY3rm7rmdItYNlaiCXr9UGHtukL+
klMYYsjwgoBuZQlGOnTtAxkx6a5+xOez8KbMdbuQRp2yBWTnujIVNOBlLWv8Kpgt
fBTY8WVY8kmyyzP8vIu1E7JT2q7ALfVni0CESvA+Qxa0zc2Il4GLReNE3jrppfta
TDclTQ1f5J5QoIRffOJUMJ3nBdpmqKP032sa+W5ZTCovUDa2F+17BEwb5fRfVk3n
M6kH2tkkqJbKZQLoGVCgUmYD6HBQEF5PplyzqZS8sPKHlBoypg65hsgyWMPCVzAy
MBF0t8EPcjU+A2PVmxhR9nvJN0Ac5x0eWEVKF+mgOiSQyRQ4we2UkhUfU5Tec2QL
+ElA4tU5gJK2+gZSHwyCkoSTr7879tkwolNyk2vYYFL4nqUC95WOodnl8a4Xfi8N
IFuqRpwoLR02bKWSIlIPMQOOrtM8xDA18Wnmml7NCmGEdm2OlCf1ocVlLM2J0fNo
Q4VOXt5FLXUbyG0FdNo8+kVY2PpbwkGIfebfL1mlR1s1MZGCwYFV/6R0Ip/H2ss8
RxN4RdfgT5B9j1xVhXNiayrbxdHD3ITJG3aRMJIhHV2TjZlR7yM=
=yHBg
-----END PGP SIGNATURE-----

--EZsoJ2vbZMS5ztzX--