Re: PATCH: Batch/pipelining support for libpq

From: "Iwata, Aya" <iwata(dot)aya(at)jp(dot)fujitsu(dot)com>
To: 'Craig Ringer' <craig(at)2ndquadrant(dot)com>
Cc: "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Daniel Verite <daniel(at)manitou-mail(dot)org>, "Dmitry Igrishin" <dmitigr(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, "Manuel Kniep" <m(dot)kniep(at)web(dot)de>, "fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp" <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>, Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PATCH: Batch/pipelining support for libpq
Date: 2017-02-14 07:27:56
Message-ID: 71E660EB361DF14299875B198D4CE54227789C1F@g01jpexmbkw01
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


On 18 November 2016 at 08:18, Craig Ringer wrote:

>At this point I doubt I'll be able to

>get update it again in time for v10, so anyone who wants to adopt it

>is welcome.

I am interested in pipeline/batch support for ECPG, and found this thread.

I updated Craig's patch [1] to apply this one to HEAD. Moreover, I fixed an easy typo.

First, I'm changing PQqueriesInBatch() to work as documented.

After that, I plan to reflect contents of reviews in the patch.

On Mon, Oct 3, 2016 at 11:52 PM, Daniel Verite wrote:

> Wouldn't pgbench benefit from it?

> It was mentioned some time ago [1], in relationship to the

> \into construct, how client-server latency was important enough to

> justify the use of a "\;" separator between statements, to send them

> as a group.


> But with the libpq batch API, maybe this could be modernized

> with meta-commands like this:

> \startbatch

> ...

> \endbatch

I'm planning to work on meta-commands to support batch mode after committing this patch successfully.



Aya Iwata


Attachment Content-Type Size
0001-Pipelining-batch-support-for-libpq-v3.patch application/octet-stream 83.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2017-02-14 07:40:47 Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless)
Previous Message Amit Langote 2017-02-14 07:07:46 Re: Documentation improvements for partitioning