Re: ECPG support for PQsetChunkedRowsMode()

From: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
To: "Tim Fors" <tim4stheenchanter(at)gmail(dot)com>
Cc: pgsql-interfaces(at)lists(dot)postgresql(dot)org
Subject: Re: ECPG support for PQsetChunkedRowsMode()
Date: 2025-11-19 18:44:31
Message-ID: 8a75aba0-de45-483a-8a53-95f48cfec9bd@manitou-mail.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Tim Fors wrote:

> The "chunked rows mode" appears to have been added to
> libpq in V17.
>
> 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]:
https://postgr.es/m/202bae70-f60d-4d24-a8d8-50b4ed638887@manitou-mail.org

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

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tim Fors 2025-11-21 21:35:51 Re: ECPG support for PQsetChunkedRowsMode()
Previous Message Tim Fors 2025-11-18 23:16:18 ECPG support for PQsetChunkedRowsMode()