| 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 |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
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.
[1]https://github.com/2ndQuadrant/postgres/tree/dev/libpq-async-batch
Regards,
Aya Iwata
FUJITSU
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Pipelining-batch-support-for-libpq-v3.patch | application/octet-stream | 83.7 KB |
| 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 |