Pgbenching Intel Xeon E3-1280 v5 testing with a MSI C236A WORKSTATION (MS-7998) v1.0 and Sapphire AMD Radeon RX 470/480 4096MB on Ubuntu 17.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/1710150-PTS-PGBENCHI09 .
Pgbenching Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server Display Driver OpenGL Compiler File-System Screen Resolution Pgbench PostgreSQL 10.0 Intel Xeon E3-1280 v5 @ 4.00GHz (8 Cores) MSI C236A WORKSTATION (MS-7998) v1.0 Intel Skylake 16384MB 256GB TOSHIBA-RD400 Sapphire AMD Radeon RX 470/480 4096MB Realtek ALC1150 ASUS PB278 Intel Connection Ubuntu 17.04 4.10.0-33-generic (x86_64) Unity 7.5.0 X Server 1.19.3 modesetting 1.19.3 4.5 Mesa 17.0.7 Gallium 0.4 (LLVM 4.0.0) GCC 6.3.0 20170406 ext4 2560x1440 OpenBenchmarking.org Compiler Details - --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,ada,c++,java,go,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-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-arch-directory=amd64 --with-default-libstdcxx-abi=new --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic -v Processor Details - Scaling Governor: intel_pstate powersave
Pgbenching pgbench: On-Disk - Normal Load - Read Only pgbench: Mostly RAM - Normal Load - Read Only 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: Buffer Test - Single Thread - Read Only pgbench: Mostly RAM - Single Thread - 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 Pgbench PostgreSQL 10.0 183911.38 183200.35 119952.57 1121.40 3235.79 32273.43 21514.98 181.51 270.12 159022.71 106983.64 1132.75 4475.47 170535.70 0.22 112278.78 0.11 3291.67 0.03 20690.11 0.01 265.24 0.18 113250.00 0.09 4706.70 OpenBenchmarking.org
PostgreSQL pgbench Scaling: On-Disk - Test: Normal Load - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: On-Disk - Test: Normal Load - Mode: Read Only Pgbench PostgreSQL 10.0 40K 80K 120K 160K 200K SE +/- 587.23, N = 3 SE +/- 1000.67, N = 3 183911.38 170535.70 -fpic -fPIC -lpthread 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only Pgbench PostgreSQL 10.0 40K 80K 120K 160K 200K SE +/- 500.24, N = 3 SE +/- 0.00, N = 3 183200.35 0.22 -fpic 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Normal Load - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Only Pgbench PostgreSQL 10.0 30K 60K 90K 120K 150K SE +/- 328.76, N = 3 SE +/- 220.85, N = 3 119952.57 112278.78 -fpic -fPIC -lpthread 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write Pgbench PostgreSQL 10.0 200 400 600 800 1000 SE +/- 6.80, N = 3 SE +/- 0.00, N = 3 1121.40 0.11 -fpic 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Normal Load - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Write Pgbench PostgreSQL 10.0 700 1400 2100 2800 3500 SE +/- 50.41, N = 4 SE +/- 45.21, N = 3 3235.79 3291.67 -fpic -fPIC -lpthread 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only Pgbench PostgreSQL 10.0 7K 14K 21K 28K 35K SE +/- 320.89, N = 3 SE +/- 0.00, N = 3 32273.43 0.03 -fpic 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Single Thread - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Buffer Test - Test: Single Thread - Mode: Read Only Pgbench PostgreSQL 10.0 5K 10K 15K 20K 25K SE +/- 51.59, N = 3 SE +/- 139.47, N = 3 21514.98 20690.11 -fpic -fPIC -lpthread 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write Pgbench PostgreSQL 10.0 40 80 120 160 200 SE +/- 0.83, N = 3 SE +/- 0.00, N = 3 181.51 0.01 -fpic 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Single Thread - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Buffer Test - Test: Single Thread - Mode: Read Write Pgbench PostgreSQL 10.0 60 120 180 240 300 SE +/- 2.01, N = 3 SE +/- 3.06, N = 3 270.12 265.24 -fpic -fPIC -lpthread 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only Pgbench PostgreSQL 10.0 30K 60K 90K 120K 150K SE +/- 3078.66, N = 3 SE +/- 0.00, N = 3 159022.71 0.18 -fpic 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only Pgbench PostgreSQL 10.0 20K 40K 60K 80K 100K SE +/- 274.83, N = 3 SE +/- 468.12, N = 3 106983.64 113250.00 -fpic -fPIC -lpthread 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write Pgbench PostgreSQL 10.0 200 400 600 800 1000 SE +/- 5.42, N = 3 SE +/- 0.00, N = 3 1132.75 0.09 -fpic 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write Pgbench PostgreSQL 10.0 1000 2000 3000 4000 5000 SE +/- 83.57, N = 3 SE +/- 78.37, N = 3 4475.47 4706.70 -fpic -fPIC -lpthread 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
Phoronix Test Suite v10.8.4