Re:PostgreSQL Performance on Raspberry Pi
by elamje on Thursday April 04, 2019 @12:37PM
(#19574287)
So the performance was lower on the server than the pi?
[ Parent
| on HN ]
Not sure how you're seeing that.
From the article it says the incremental reporting (every 60 seconds) were:
> progress: 540.0 s, 171.8 tps, lat 55.105 ms stddev 946.851
> progress: 600.0 s, 24.6 tps, lat 435.693 ms stddev 2945.727
> progress: 660.0 s, 405.8 tps, lat 24.108 ms stddev 134.692
So they were getting between 24.6 and 405.8 transactions per second.
On the server, he's seeing:
> progress: 60.0 s, 9192.5 tps, lat 1.088 ms stddev 0.924
So the server is doing 9192.5 transactions per second. The test wasn't run as long, but the server is showing much lower latency and standard deviation, as well.
Re:PostgreSQL Performance on Raspberry Pi
by MuffinFlavored on Thursday April 04, 2019 @12:47PM
(#19574411)
No. The article claims about ~200 TPS. I was able to pull ~9k TPS.