News for hackers. Stuff that matters.
Re:PostgreSQL Performance on Raspberry Pi by altmind on Thursday April 04, 2019 @10:16PM (#19579059)
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?

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?

Re:PostgreSQL Performance on Raspberry Pi by altmind on Friday April 05, 2019 @12:13PM (#19583965)
maybe you can do fio write+sync benchmark? http://uditagarwal.in/index.php/2018/05/19/comparing-io-benc...