Feedback-ID: i0fe9450f:Fastmail
Date: Thu, 6 Mar 2025 13:20:37 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Daniel Verite <daniel@manitou-mail.org>
Cc: Anthonin Bonnefoy <anthonin.bonnefoy@datadoghq.com>,
	Jelte Fennema-Nio <postgres@jeltef.nl>,
	PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Add Pipelining support in psql
Message-ID: <Z8kilUVjYAHko17g@paquier.xyz>
References: <CAO6_Xqroaof=Gu_NCg4bZfpdgwOjNW9fg753cuuts-FBnv9UGw@mail.gmail.com>
 <a96682c3-9505-456f-b5c7-1b9d1e6303b4@manitou-mail.org>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="n/6zslLqSbSesMwz"
Content-Disposition: inline
In-Reply-To: <a96682c3-9505-456f-b5c7-1b9d1e6303b4@manitou-mail.org>
Archived-At: <https://www.postgresql.org/message-id/Z8kilUVjYAHko17g%40paquier.xyz>
Precedence: bulk


--n/6zslLqSbSesMwz
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Wed, Mar 05, 2025 at 03:25:12PM +0100, Daniel Verite wrote:
> 	Anthonin Bonnefoy wrote:
>> I do see the idea to make it easier to convert existing scripts into
>> using pipelining. The main focus of the initial implementation was
>> more on protocol regression tests with psql, so that's not necessarily
>> something I had in mind.
>=20
> Understood. Yet pipelining can accelerate considerably certain scripts
> when client-server latency is an issue. We should expect end users to
> benefit from it too.

That was not a test case we had in mind originally here, but if it is
possible to keep the implementation simple while supporting your
demand, well, let's do it.  If it's not that straight-forward, let's
use the new meta-command, forbidding \g and \gx based on your
arguments from upthread.
--
Michael

--n/6zslLqSbSesMwz
Content-Type: application/pgp-signature; name="signature.asc"

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

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmfJIpUACgkQnvQgOdby
QH3v4Q//UrvJaUFNoS4cwypR8feGZKT0KSxi+UNSLfPAefuHhSDpJELADRRsRDWg
N/hxRIAefSjatoG6IwWsVUkkN40DlObAOQMZwaJvFlIVyNuL+vBmsWr22D6XSSHx
qa3AiAW6wMCA7wKTvr3sUA4zWo3nyOrF8adLTX5mkhlCmH7ur+ETKFvEb3pZEUrV
mrlf4gip8z3G1Cfgf2it2mzC0Dh6kt1L5Fd40yH3rvMrGTJhiH0nF6BbC6cWrFVZ
fGEGgH6ZnTLGKsdZ7c6aX9QvUASUWewiIc+oEJo/0RmnV9pzCUGbjxRue1lLwxyJ
SpQj5F+NySMrRVySMU0WxL6C05FBjB23KGbOlhJm6CW34G18UcnkM4+Q3zDasijN
r7Uwb3WFnLdi5DXv4n+FiNOex00Wp1igFiAR+e2ssYXoPMtwwJwHR6H4YjaGVmSo
HDWbDeVF2zyx7FA49rIZzcjsHMyPEZMeDKHWhB3rGhSRqBBW7zS87ND+byNKydkS
pzCOlAZtcnImIbMBRH0ft+rkTAwb94RvZI6jGucbIYc1E8fHaATyunFSMIOf0A+o
oNDPBZ9MlOLn2EsHVf6oYCAW48A4jBd5cFhcay7Mo2mQF2CPL2L5UJvE1gGjUXU2
BKfxatdk9Z+vXzkfOkOyCrstb3nEvwnnHPSXUaW0DEjSGVs37Bs=
=0sfn
-----END PGP SIGNATURE-----

--n/6zslLqSbSesMwz--