Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.300.87.4.3\))
Subject: Re: Pipeline Mode vs Single Row Mode / Chunked Rows Mode
From: Daniel Frey <d.frey@gmx.de>
In-Reply-To: <68c8b6c6-ae2e-4875-a08e-e6a26a04678e@manitou-mail.org>
Date: Tue, 7 Jan 2025 16:28:37 +0100
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <77DCA104-4412-4960-8BE3-08F87274436E@gmx.de>
References: <68c8b6c6-ae2e-4875-a08e-e6a26a04678e@manitou-mail.org>
To: Daniel Verite <daniel@manitou-mail.org>
UI-OutboundReport: notjunk:1;M01:P0:wk/blqyKEaQ=;hM3JlXXRxMWmmnAsPKE2uGK62QI
 uhar4X3RgjZF+kTSN0ni3DJmMTNdQWulldsWObbZ2CQi8gpMx0e21gaMlr9dUevVKuj2PpujE
 Dw0lTMPNvkxdVAbjUvdRST2deP6/q0XvLzPMCKzERJHhCzxwr+NNzZqnOf+EG7MWknBBVii/l
 cN0/UfPfUF5jyitDAGcK7Ehl0pga5mlxZ2AAmK3UXIcffFT1rkD+Slhst2cLFatCS/pjYtK9D
 8+tZKVV9B+l11WVupglkfcr+DWZvFjUhCIWGj9iYsFvggva0uGatgPOD1RaJnT2aX2S21wnIL
 Hr3v9+o7M6Zp7HoSwqUgX+6wKsvzF5bXsDnaY8fYxjn6xtKs/3pho4XuFfdAR20Q771nybyBX
 cC6y3MH3L7vPmM2JbiGQkPn+woEejDKzRGWiiFsjrOekqdROd87vvY5EKANeMq/PbCTJMDm1N
 yeAAKalJtWh24m0wUuwACJBQLEUu5Q8KW1g5BX/2zyK/UZ9MGZT/DvWfmr1joUJC+uXErygbr
 JTJs+FrTrO3Om/V6yMv5zyYALJUI0MB59d79WFwN8opWRNr2urVkw5jOXn0hB2dPJhfA16nOZ
 UX9U2BfsFKnmEWnR3AqHy0ozymVkZ9fu12KiT0xW/ZRCeCFFFCiAGLI2j7/UsXh88NhkO1T99
 wNIPzmFXUPZiafzDEvkdO6mgAsGF9+nDgRxyikRZO0L3ERlOPS0ZwjYUE9IJ3uSygCu8fjydS
 GsTwFs11DEnS8mrqy6hPsj4VBfJo3cKHtNYLmzcuNvpqH3/WTK+AeBfqot1aVQaQ9ydXMeLz7
 R5oAH1lsmeZlysE5mUm5Vc5EUCBzc8n709qv6xakXCIsozW7/dfebvoAN7oxZcZ2rj/x/nIOL
 vvPnhLjlOvllesCyIG3Bx8uYk8iZXROnl2y4x72rDIxsMJUo5cAXOMFi5i5Z6XgeP/gYe4HWJ
 +RoVFRsAjDSjLIYO9am4QiJ9oHW2laaKpyHj1KKNRSaWgJwX6veQ4kJNbc7MyIM55n7pUeT1v
 nO3F5icyuutxpS6mtxN1ZExLekxPYZiGvunhEnUhZ1iLgVrl91+PslzMEabS6O+4XxVUh3/zQ
 zzwHpOAHNKWSnB+8PnsII+rDo/OWg6
Archived-At: <https://www.postgresql.org/message-id/77DCA104-4412-4960-8BE3-08F87274436E%40gmx.de>
Precedence: bulk

> On 6. Jan 2025, at 20:47, Daniel Verite <daniel@manitou-mail.org> =
wrote:
>=20
> Daniel Frey wrote:
>=20
>> I tried to understand the interaction between Pipeline Mode and
>> Single Row Mode / Chunked Rows Mode. It seems that it works
>> sometimes, but I don't get the feeling that it was deliberately
>> designed to work consistently
>=20
> It's supposed to work, and there are regression tests in
> src/test/modules/libpq_pipeline/libpq_pipeline.c [1]
> that exercise the single row mode and PQpipelineSync().
>=20
> You might want to compare your code workflow with how it's done in
> that file, and maybe submit a bug report with your test case if the
> conclusion is that your code should not error out.

Thank you for the link, I will need some time to investigate and to =
figure out what is different.

Best, Daniel