Re: ECPG support for PQsetChunkedRowsMode() - Mailing list pgsql-interfaces

From Daniel Verite
Subject Re: ECPG support for PQsetChunkedRowsMode()
Date
Msg-id 8a75aba0-de45-483a-8a53-95f48cfec9bd@manitou-mail.org
Whole thread Raw
In response to ECPG support for PQsetChunkedRowsMode()  (Tim Fors <tim4stheenchanter@gmail.com>)
List 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/



pgsql-interfaces by date:

Previous
From: Tim Fors
Date:
Subject: ECPG support for PQsetChunkedRowsMode()