libpq: Request Pipelining/Batching status ?

Started by Matthieu Garriguesover 5 years ago2 messages
#1Matthieu Garrigues
matthieu.garrigues@gmail.com

Hi all,

Do you know what is the status of Request Pipelining and/or Batching in
libpq ?

I could see that I'm not the first one to think about it, I see an item in
the todolist:
https://web.archive.org/web/20200125013930/https://wiki.postgresql.org/wiki/Todo

And a thread here:
https://www.postgresql-archive.org/PATCH-Batch-pipelining-support-for-libpq-td5904551i80.html

And a patch here:
https://2ndquadrant.github.io/postgres/libpq-batch-mode.html

Seems like this boost performances a lot, drogon, a c++ framework
outperform all
other web framework thanks to this fork:
https://www.techempower.com/benchmarks/#section=data-r19&hw=ph&test=update
https://github.com/TechEmpower/FrameworkBenchmarks/issues/5502

It would be nice to have it it the official libpq so we don't have to use
an outdated fork
to have this feature.
Is anybody working on it ? is there lots of work to finalize this patch ?

Thanks in advance,
Matthieu

#2Matthieu Garrigues
matthieu.garrigues@gmail.com
In reply to: Matthieu Garrigues (#1)
Re: libpq: Request Pipelining/Batching status ?

Did my message made it to the mailing list ? or not yet ?

Matthieu Garrigues

On Fri, Jul 10, 2020 at 5:08 PM Matthieu Garrigues <
matthieu.garrigues@gmail.com> wrote:

Show quoted text

Hi all,

Do you know what is the status of Request Pipelining and/or Batching in
libpq ?

I could see that I'm not the first one to think about it, I see an item in
the todolist:

https://web.archive.org/web/20200125013930/https://wiki.postgresql.org/wiki/Todo

And a thread here:

https://www.postgresql-archive.org/PATCH-Batch-pipelining-support-for-libpq-td5904551i80.html

And a patch here:
https://2ndquadrant.github.io/postgres/libpq-batch-mode.html

Seems like this boost performances a lot, drogon, a c++ framework
outperform all
other web framework thanks to this fork:
https://www.techempower.com/benchmarks/#section=data-r19&amp;hw=ph&amp;test=update
https://github.com/TechEmpower/FrameworkBenchmarks/issues/5502

It would be nice to have it it the official libpq so we don't have to use
an outdated fork
to have this feature.
Is anybody working on it ? is there lots of work to finalize this patch ?

Thanks in advance,
Matthieu