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.
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 1703013-RI-POSTGRESQ15 Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) Processor: Intel Xeon E3-1245 v5 @ 3.90GHz (8 Cores), Motherboard: MSI C236A WORKSTATION (MS-7998) v1.0, Chipset: Intel Skylake, Memory: 32768MB, Disk: 120GB Samsung SSD 850, Graphics: Intel HD P530 (Skylake GT2) 3072MB (1150MHz), Audio: Realtek ALC1150, Monitor: DELL P2415Q, Network: Intel Connection
OS: Ubuntu 17.04, Kernel: 4.10.0-8-generic (x86_64), Desktop: Unity 7.5.0, Display Server: X Server 1.18.4, Display Driver: modesetting 1.18.4, OpenGL: 4.5 Mesa 13.0.4, Compiler: GCC 6.3.0 20161229, File-System: ext4, Screen Resolution: 3840x2160
Compiler Notes: --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 -vProcessor Notes: Scaling Governor: intel_pstate powersave
PostgreSQL Benchmark pgbench Linux OpenBenchmarking.org Phoronix Test Suite 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 Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server Display Driver OpenGL Compiler File-System Screen Resolution PostgreSQL Benchmark Pgbench Linux Performance System Logs - --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: Buffer Test - Heavy Contention - Read Write pgbench: Mostly RAM - Heavy Contention - Read Write pgbench: Buffer Test - Heavy Contention - Read Only pgbench: Mostly RAM - Heavy Contention - Read Only pgbench: Buffer Test - Single Thread - Read Write pgbench: On-Disk - Heavy Contention - Read Write pgbench: Mostly RAM - Single Thread - Read Write pgbench: Buffer Test - Single Thread - Read Only pgbench: On-Disk - Heavy Contention - Read Only pgbench: Mostly RAM - Single Thread - Read Only pgbench: Buffer Test - Normal Load - Read Write pgbench: Mostly RAM - Normal Load - Read Write pgbench: Buffer Test - Normal Load - Read Only pgbench: On-Disk - Single Thread - Read Write pgbench: Mostly RAM - Normal Load - Read Only pgbench: On-Disk - Single Thread - Read Only pgbench: On-Disk - Normal Load - Read Write pgbench: On-Disk - Normal Load - Read Only Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) 3735.72 2644.52 106414.33 96588.00 388.67 608.72 243.08 21564.91 183925.50 20941.52 3648.45 2348.89 120318.56 157.74 112875.86 33699.05 620.32 196080.24 OpenBenchmarking.org
PostgreSQL pgbench 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Intel Xeon E3-1245 v5 - Intel HD P530 (Skylake GT2) Processor: Intel Xeon E3-1245 v5 @ 3.90GHz (8 Cores), Motherboard: MSI C236A WORKSTATION (MS-7998) v1.0, Chipset: Intel Skylake, Memory: 32768MB, Disk: 120GB Samsung SSD 850, Graphics: Intel HD P530 (Skylake GT2) 3072MB (1150MHz), Audio: Realtek ALC1150, Monitor: DELL P2415Q, Network: Intel Connection
OS: Ubuntu 17.04, Kernel: 4.10.0-8-generic (x86_64), Desktop: Unity 7.5.0, Display Server: X Server 1.18.4, Display Driver: modesetting 1.18.4, OpenGL: 4.5 Mesa 13.0.4, Compiler: GCC 6.3.0 20161229, File-System: ext4, Screen Resolution: 3840x2160
Compiler Notes: --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 -vProcessor Notes: Scaling Governor: intel_pstate powersave
Testing initiated at 28 February 2017 22:05 by user phoronix.