5 ms·
I tried to replicate this benchmark on threadripper 2950x, 16 cores, 32gb 3000mhz 14cl, samsung 860 nvme, XFS. I was never able to achive more than 3100 tps, e
by altmind 8y ago
I tried to replicate this benchmark on threadripper 2950x, 16 cores, 32gb 3000mhz 14cl, samsung 860 nvme, XFS.
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?
- MuffinFlavored 8y agoI 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?
- altmind 8y agomaybe you can do fio write+sync benchmark? http://uditagarwal.in/index.php/2018/05/19/comparing-io-benchmarks-fio-iozone-and-bonnie/ http://uditagarwal.in/index.php/2018/05/19/comparing-io-benc...