public inbox for pgsql-interfaces@postgresql.org
help / color / mirror / Atom feedFrom: Daniel Verite <daniel@manitou-mail.org>
To: Tim Fors <tim4stheenchanter@gmail.com>
Cc: pgsql-interfaces@lists.postgresql.org
Subject: Re: ECPG support for PQsetChunkedRowsMode()
Date: Wed, 19 Nov 2025 19:44:31 +0100
Message-ID: <8a75aba0-de45-483a-8a53-95f48cfec9bd@manitou-mail.org> (raw)
In-Reply-To: <CAOjiQ0C7g=0jmHQL2EZaGfn3qjJxVW+nO6OX6-me-Sa_f7yt=g@mail.gmail.com>
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/
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: daniel@manitou-mail.org, tim4stheenchanter@gmail.com, pgsql-interfaces@lists.postgresql.org
Subject: Re: ECPG support for PQsetChunkedRowsMode()
In-Reply-To: <8a75aba0-de45-483a-8a53-95f48cfec9bd@manitou-mail.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox