PostgreSQL Benchmark pgbench Linux Intel Xeon E3-1245 v5 testing with a MSI C236A WORKSTATION (MS-7998) v1.0 and Intel HD P530 (Skylake GT2) 3072MB on Ubuntu 17.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/1703013-RI-POSTGRESQ15 .
PostgreSQL Benchmark pgbench Linux Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server Display Driver OpenGL Compiler File-System Screen Resolution Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) Intel Xeon E3-1245 v5 @ 3.90GHz (8 Cores) MSI C236A WORKSTATION (MS-7998) v1.0 Intel Skylake 32768MB 120GB Samsung SSD 850 Intel HD P530 (Skylake GT2) 3072MB (1150MHz) Realtek ALC1150 DELL P2415Q Intel Connection Ubuntu 17.04 4.10.0-8-generic (x86_64) Unity 7.5.0 X Server 1.18.4 modesetting 1.18.4 4.5 Mesa 13.0.4 GCC 6.3.0 20161229 ext4 3840x2160 OpenBenchmarking.org - --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 - Scaling Governor: intel_pstate powersave
PostgreSQL Benchmark pgbench Linux 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 Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 196080.24 620.32 33699.05 112875.86 157.74 120318.56 2348.89 3648.45 20941.52 183925.50 21564.91 243.08 608.72 388.67 96588.00 106414.33 2644.52 3735.72 OpenBenchmarking.org
PostgreSQL pgbench Scaling: On-Disk - Test: Normal Load - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: On-Disk - Test: Normal Load - Mode: Read Only Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 40K 80K 120K 160K 200K SE +/- 1073.73, N = 3 196080.24 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -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 9.4.3 Scaling: On-Disk - Test: Normal Load - Mode: Read Write Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 130 260 390 520 650 SE +/- 0.09, N = 3 620.32 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -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 9.4.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Only Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 7K 14K 21K 28K 35K SE +/- 267.29, N = 3 33699.05 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -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 9.4.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 20K 40K 60K 80K 100K SE +/- 383.77, N = 3 112875.86 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -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 9.4.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Write Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 30 60 90 120 150 SE +/- 1.42, N = 3 157.74 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -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 9.4.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Only Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 30K 60K 90K 120K 150K SE +/- 400.71, N = 3 120318.56 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -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 9.4.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 500 1000 1500 2000 2500 SE +/- 19.55, N = 3 2348.89 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -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 9.4.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Write Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 800 1600 2400 3200 4000 SE +/- 59.91, N = 3 3648.45 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -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 9.4.3 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 4K 8K 12K 16K 20K SE +/- 237.97, N = 3 20941.52 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -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 9.4.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 40K 80K 120K 160K 200K SE +/- 4233.88, N = 6 183925.50 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -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 9.4.3 Scaling: Buffer Test - Test: Single Thread - Mode: Read Only Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 5K 10K 15K 20K 25K SE +/- 274.03, N = 3 21564.91 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -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 9.4.3 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 50 100 150 200 250 SE +/- 17.29, N = 6 243.08 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -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 9.4.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 130 260 390 520 650 SE +/- 0.40, N = 3 608.72 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -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 9.4.3 Scaling: Buffer Test - Test: Single Thread - Mode: Read Write Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 80 160 240 320 400 SE +/- 2.90, N = 3 388.67 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -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 9.4.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 20K 40K 60K 80K 100K SE +/- 1038.87, N = 3 96588.00 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -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 9.4.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 20K 40K 60K 80K 100K SE +/- 183.66, N = 3 106414.33 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -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 9.4.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 600 1200 1800 2400 3000 SE +/- 101.59, N = 6 2644.52 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -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 9.4.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 800 1600 2400 3200 4000 SE +/- 231.08, N = 6 3735.72 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
Phoronix Test Suite v10.8.4