Re:PostgreSQL Performance on Raspberry Pi
by MuffinFlavored on Friday April 05, 2019 @10:20AM
(#19582745)
I think you're misreading your results lol
your -c30 is 41.5k
your -c10 is 26.89k, which smokes my 9k
edit: I just misread that and see you moved it to RAMdisk.
What would you like me to do to prove the test is fast because of the SOFTRaid?
maybe you can do fio write+sync benchmark?
http://uditagarwal.in/index.php/2018/05/19/comparing-io-benc...
I was never able to achive more than 3100 tps, even with -march=native -O3 -flto, large wal and shared_buffers, without selinux and THP - I was always bottlenecked by 1 progres process staying in IOWait.
I moved data directory to ramdisk and got: [pgbench -c10 -j 2]: progress: 60.0 s, 26819.3 tps, lat 0.371 ms stddev 0.119. with LA of mere 4.
[pgbench -c30 -j 2]: progress: 60.0 s, 41572.7 tps, lat 0.720 ms stddev 0.390
How do you guys get this crazy performance? Could this be that your RAID fsyncs are not really syncing?