Re: libpq pipelineing - Mailing list pgsql-general

From Samuel Williams
Subject Re: libpq pipelineing
Date
Msg-id CAHkN8V-hVUESfNOgkT8WCcJfn_Ce-imasiAcVs0uePVkK=RMNw@mail.gmail.com
Whole thread Raw
In response to Re: libpq pipelineing  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: libpq pipelineing  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
> What about, as it says, sending multiple statements in a single sendQuery and then polling for multiple results?

I tried this, and even in single row streaming mode, I found that
there are cases where the results would not be streamed until all the
queries were sent.

From the users point of view, they may generate a loop sending
multiple queries and don't care about the result, so a pipeline/batch
processing is ideal to avoid RTT per loop iteration, if database
access is slow, this can be a significant source of latency.

Kind regards,
Samuel



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: libpq pipelineing
Next
From: "David G. Johnston"
Date:
Subject: Re: libpq pipelineing