Performance test about pgmoon HOT 4 CLOSED

There's not much info to work with there. Were keepalives used with pgmoon? As for the differences, lua-resty-postgres doesn't support MD5 authentication, SSL connections, async notifications, arrays, hstore, json/jsonb or work outside of an OpenResty context. ngx_postgres doesn't work directly with Lua as a native nginx module; ngx_postgres requires the use of nginx location handlers and output filters.

Could pgmoon be profiled and optimized further? Probably. However comparisons with the other implementations are very much apples vs oranges.

from pgmoon.

Thanks for the details. I am using OpenResty with MySQL and wanted to switch to PostgreSQL but was not sure about performance related to pgmoon and that's where I found this article. Have you compared pgmoon with other native drivers for performance?

from pgmoon.

I have not personally, no, so take anything I'm saying here with a grain of anecdotal salt.

DB query processing, drive I/O, and network latency have always dominated any benchmarks I've done in the past. There's always room for improvement, but I personally use solutions like pgbouncer to mitigate network effects like connection speed. Whether pgmoon or some other driver, connections to pgbouncer on localhost are wicked fast compared to anything else in the stack.

from pgmoon.

Closing old issues. I never wrote any benchmarks. In my experience this client library has never been a bottleneck in the apps I've worked on. Queries are going to be much slower than whatever raw throughput this library is capable of.

from pgmoon.