Comments (4)
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.
Related Issues (20)
- support ipv6 by using luasocket HOT 1
- What should I do if error happens when using pg:query ? HOT 1
- Implement extended query protocol HOT 1
- attempt to call method 'keepalive' (a nil value) HOT 1
- [PostgreSQL 14.1] Why is the connection wrong and the encryption method is scram-sha-256? HOT 2
- It works in neovim!
- unable to read data from frontend HOT 4
- bad request on repeated requests HOT 3
- multi-hosts HOT 1
- pgmoon support automatic master-slave switch HOT 1
- Add locking to query functions HOT 1
- authentication exchange unsuccessful in postgresql 15 scram-sha-256 in scram_sha_256_auth
- lua entry thread aborted: runtime error: attempt to yield across C-call boundary HOT 2
- multiple statements in one query HOT 2
- Support all array types
- postgres:query() does not return error as 2. parameter
- Socket pool getreusedtimes function HOT 1
- Pool violation after v1.13 HOT 2
- Connection pooling outside of OpenResty?
- which pgmoon version can connect to postgresql 15 ?
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pgmoon.