fastcgipp icon indicating copy to clipboard operation
fastcgipp copied to clipboard

postgres pipline query

Open d4wae89d498 opened this issue 3 years ago • 1 comments

Hello, 2 days ago, async-batch patch aka. pipline mode was added to postgresql master, this what allow ultra high performances for both lithium and drogon on techempower, excpect that they were using an old fork of libpq. Now that this feature is beeing added officially, maybe implementing it would be a good idea ?

See this commit https://github.com/postgres/postgres/commit/acb7e4eb6b1c614c68a62fb3a6a5bba1af0a2659

old doc about that feature : https://2ndquadrant.github.io/postgres/libpq-batch-mode.html

see drogon issue: https://github.com/an-tao/drogon/issues/526

Or maybe i'm wrong once again, let me know.

I can help you working on it.

Thank you really much for your super nice repo. Deserve more stars.

d4wae89d498 avatar Mar 17 '21 17:03 d4wae89d498

Yeah this would fit very nicely into the way fastcgi++ currently does it's PostgreSQL business. The Connection class implements it's own queue of sorts and this could effectively replace it. We'll leave this issue open as a reminder.

eddic avatar Mar 20 '21 22:03 eddic