pgbench-suite AMD Ryzen 3 1200 testing with a Gigabyte AB350N-Gaming WIFI-CF (F23 BIOS) and ASUS NVIDIA GeForce GTX 1050 Ti 4096MB on Ubuntu 18.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/1810207-RA-PGBENCHSU71 .
pgbench-suite Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server Display Driver OpenGL Compiler File-System Screen Resolution ryzen1200_3.6Ghz_2733Mhz AMD Ryzen 3 1200 @ 3.60GHz (4 Cores) Gigabyte AB350N-Gaming WIFI-CF (F23 BIOS) AMD Family 17h 16384MB Samsung SSD 970 PRO 512GB ASUS NVIDIA GeForce GTX 1050 Ti 4096MB (1290/3504MHz) NVIDIA GP107GL HD Audio Q3279WG5B Realtek RTL8111/8168/8411 + Intel Wireless 3165 Ubuntu 18.04 4.15.0-36-lowlatency (x86_64) GNOME Shell 3.28.3 X Server 1.19.6 NVIDIA 390.87 4.6.0 GCC 7.3.0 ext4 2560x1440 OpenBenchmarking.org - --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic --without-cuda-driver -v - Scaling Governor: acpi-cpufreq ondemand - __user pointer sanitization + Full AMD retpoline IBPB + SSB disabled via prctl and seccomp
pgbench-suite pgbench: On-Disk - Normal Load - Read Only pgbench: On-Disk - Normal Load - Read Write pgbench: On-Disk - Single Thread - Read Only pgbench: Mostly RAM - Normal Load - Read Only pgbench: On-Disk - Single Thread - Read Write pgbench: Buffer Test - Normal Load - Read Only pgbench: Mostly RAM - Normal Load - Read Write pgbench: Buffer Test - Normal Load - Read Write pgbench: Mostly RAM - Single Thread - Read Only pgbench: On-Disk - Heavy Contention - Read Only pgbench: Buffer Test - Single Thread - Read Only pgbench: Mostly RAM - Single Thread - Read Write pgbench: On-Disk - Heavy Contention - Read Write pgbench: Buffer Test - Single Thread - Read Write pgbench: Mostly RAM - Heavy Contention - Read Only pgbench: Buffer Test - Heavy Contention - Read Only pgbench: Mostly RAM - Heavy Contention - Read Write pgbench: Buffer Test - Heavy Contention - Read Write ryzen1200_3.6Ghz_2733Mhz 31786.81 2159.29 3140.78 37361.48 340.05 54592.00 2349.71 3299.38 3634.36 29887.45 15302.83 347.43 4515.80 414.56 34420.63 53387.11 4872.75 5277.74 OpenBenchmarking.org
PostgreSQL pgbench Scaling: On-Disk - Test: Normal Load - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Normal Load - Mode: Read Only ryzen1200_3.6Ghz_2733Mhz 7K 14K 21K 28K 35K SE +/- 214.28, N = 3 31786.81 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: On-Disk - Test: Normal Load - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Normal Load - Mode: Read Write ryzen1200_3.6Ghz_2733Mhz 500 1000 1500 2000 2500 SE +/- 4.66, N = 3 2159.29 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: On-Disk - Test: Single Thread - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Only ryzen1200_3.6Ghz_2733Mhz 700 1400 2100 2800 3500 SE +/- 20.40, N = 3 3140.78 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only ryzen1200_3.6Ghz_2733Mhz 8K 16K 24K 32K 40K SE +/- 224.42, N = 3 37361.48 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: On-Disk - Test: Single Thread - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Write ryzen1200_3.6Ghz_2733Mhz 70 140 210 280 350 SE +/- 3.52, N = 3 340.05 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Normal Load - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Only ryzen1200_3.6Ghz_2733Mhz 12K 24K 36K 48K 60K SE +/- 79.71, N = 3 54592.00 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write ryzen1200_3.6Ghz_2733Mhz 500 1000 1500 2000 2500 SE +/- 14.57, N = 3 2349.71 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Normal Load - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Write ryzen1200_3.6Ghz_2733Mhz 700 1400 2100 2800 3500 SE +/- 5.01, N = 3 3299.38 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only ryzen1200_3.6Ghz_2733Mhz 800 1600 2400 3200 4000 SE +/- 35.43, N = 3 3634.36 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only ryzen1200_3.6Ghz_2733Mhz 6K 12K 18K 24K 30K SE +/- 242.75, N = 3 29887.45 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Single Thread - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Single Thread - Mode: Read Only ryzen1200_3.6Ghz_2733Mhz 3K 6K 9K 12K 15K SE +/- 125.37, N = 3 15302.83 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write ryzen1200_3.6Ghz_2733Mhz 80 160 240 320 400 SE +/- 1.05, N = 3 347.43 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write ryzen1200_3.6Ghz_2733Mhz 1000 2000 3000 4000 5000 SE +/- 14.42, N = 3 4515.80 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Single Thread - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Single Thread - Mode: Read Write ryzen1200_3.6Ghz_2733Mhz 90 180 270 360 450 SE +/- 1.23, N = 3 414.56 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only ryzen1200_3.6Ghz_2733Mhz 7K 14K 21K 28K 35K SE +/- 166.17, N = 3 34420.63 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only ryzen1200_3.6Ghz_2733Mhz 11K 22K 33K 44K 55K SE +/- 165.92, N = 3 53387.11 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write ryzen1200_3.6Ghz_2733Mhz 1000 2000 3000 4000 5000 SE +/- 15.49, N = 3 4872.75 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write ryzen1200_3.6Ghz_2733Mhz 1100 2200 3300 4400 5500 SE +/- 5.71, N = 3 5277.74 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
Phoronix Test Suite v10.8.4