Re: Pipeline Mode vs Single Row Mode / Chunked Rows Mode

From: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
To: "Daniel Frey" <d(dot)frey(at)gmx(dot)de>
Cc: "pgsql-general" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Pipeline Mode vs Single Row Mode / Chunked Rows Mode
Date: 2025-01-06 19:47:38
Message-ID: 68c8b6c6-ae2e-4875-a08e-e6a26a04678e@manitou-mail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Daniel Frey wrote:

> 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

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().

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.

[1]
https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/modules/libpq_pipeline/libpq_pipeline.c

Best regards,
--
Daniel Vérité
https://postgresql.verite.pro/
Twitter: @DanielVerite

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2025-01-06 20:06:21 Re: Will PQsetSingleRowMode get me results faster?
Previous Message Daniel Verite 2025-01-06 19:25:26 Re: Will PQsetSingleRowMode get me results faster?