node-postgres on TechEmpower/FrameworkBenchmarks

[cesco69]

https://github.com/TechEmpower/FrameworkBenchmarks is a poupular nodejs benchmark:

This project provides representative performance measures across a wide field of web application frameworks.

I have noticied that most of the frameworks use postgres.js probabily because it claim to be the faster postgres client (I have also discussed here #3391 )

My suggestion is to mantains the nodejs benchmark https://github.com/TechEmpower/FrameworkBenchmarks/tree/master/frameworks/JavaScript/nodejs and take it updated with last version an improve it with:

• pg-native
• prepared statement

The goal is promote pg is better!

[brianc]

Yeah the misinformation from postgres.js is pretty unfortunate. If anyone wants to do a benchmark between the two librarys and contribute it here I'm happy to pay them to do it. Please email me at brian.m.carlson@gmail.com. I personally don't have interest in trying to "compete" with another open source project, felt pretty annoyed when that project came out w/ those benchmarks, and just don't want to engage. But it is probably important to get the truth out. For example, my friend works at a major cloud provider (cannot share name of company) and they switched from postgres.js to node-postgres on their backplane routing infrastructure and saw their throughput numbers DOUBLE and latency numbers be cut in half. Just goes to show marketing rules all. I am not sad there is another postgres driver for node, for sure, I just don't like the whole "the fastest ....bla bla" shit when its not that simple.

[nigrosimone]

Done! An honest benchmark https://github.com/nigrosimone/postgres-benchmarks

summary
  brianc/node-postgres (pg-native)
   1.13x faster than brianc/node-postgres (pg)
   1.25x faster than porsager/postgres (postgres)

My two cents

Both node-postgres and postgres,js are pretty close, no differece in real world. Just pg-native is a bit faster!

Running benchmarks... --iterations=50000
GC is exposed
Poll size: 10
Dependencies versions:
{
  "pg": "^8.16.3",
  "pg-native": "^3.5.2",
  "postgres": "^3.4.7"
}
Database connectivity verified
clk: ~3.06 GHz
cpu: Intel(R) Core(TM) i7-1065G7 CPU @ 1.30GHz
runtime: node 24.7.0 (x64-linux)

benchmark                       avg (min … max) p75 / p99    (min … top 1%)
----------------------------------------------- -------------------------------
brianc/node-postgres (pg-native) 161.73 µs/iter 159.26 µs   █
                          (113.45 µs … 1.01 ms) 391.13 µs   █
                        (  6.93 kb …   2.07 mb)  11.93 kb ▁▄█▆▃▂▂▂▂▂▁▁▁▁▁▁▁▁▁▁▁

brianc/node-postgres (pg)        183.02 µs/iter 197.19 µs  █
                          (129.61 µs … 1.77 ms) 402.29 µs  █▅▃
                        (  1.80 kb …   1.93 mb)  15.46 kb ▁███▆▅▅▄▃▃▂▂▂▂▁▁▁▁▁▁▁

porsager/postgres (postgres)     202.32 µs/iter 220.90 µs  █
                          (140.51 µs … 1.22 ms) 436.25 µs  █▆▄
                        (  4.90 kb …   1.10 mb)  13.97 kb ▁████▇▆▄▃▃▃▂▂▂▂▁▁▁▁▁▁

summary
  brianc/node-postgres (pg-native)
   1.13x faster than brianc/node-postgres (pg)
   1.25x faster than porsager/postgres (postgres)

PS:

• Do not parse command complete info unless accessed #3511 in benchmark has a little performance improvements
• I have published a post https://dev.to/nigrosimone/benchmarking-postgresql-drivers-in-nodejs-node-postgres-vs-postgresjs-17kl