Content-Type: text/plain; charset="iso-8859-15"
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Subject: Re: ECPG support for PQsetChunkedRowsMode()
From: "Daniel Verite" <daniel@manitou-mail.org>
To: "Tim Fors" <tim4stheenchanter@gmail.com>
Cc: pgsql-interfaces@lists.postgresql.org
In-Reply-To: 
 <CAOjiQ0C7g=0jmHQL2EZaGfn3qjJxVW+nO6OX6-me-Sa_f7yt=g@mail.gmail.com>
Date: Wed, 19 Nov 2025 19:44:31 +0100
Message-Id: <8a75aba0-de45-483a-8a53-95f48cfec9bd@manitou-mail.org>
Archived-At: 
 <https://www.postgresql.org/message-id/8a75aba0-de45-483a-8a53-95f48cfec9bd%40manitou-mail.org>
Precedence: bulk

	Tim Fors wrote:

> The "chunked rows mode" appears to have been added to
> libpq in V17.
>=20
> Does ECPG support this mode

No. It's not clear how it would fit. This mode implies the use
of PQsendQuery(), which does not seem to have an equivalent in
ECPG.

>  are there plans to do so in the near future?

Postgres as a project does not have a roadmap, but
what's being worked on at any point in time can
generally be tracked at https://commitfest.postgresql.org


> Also, is there any data available on performance improvements that
> one might see by using this mode?

In [1], the time to retrieve rows by psql was compared between the
the chunked rows mode and the cursor-based implementation, the
latter being what would typically be used by an ECPG app.


[1]:=20
https://postgr.es/m/202bae70-f60d-4d24-a8d8-50b4ed638887@manitou-mail.org


Best regards,
--=20
Daniel V=E9rit=E9=20
https://postgresql.verite.pro/