postgresql postgresql
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 1705252-RI-POSTGRESQ94 postgresql Processor: AMD Ryzen 7 1700 Eight-Core @ 3.80GHz (16 Cores), Motherboard: MSI X370 SLI PLUS (MS-7A33) v2.0, Chipset: AMD Device 1450, Memory: 2 x 16384 MB DDR4-1333MHz CMK32GX4M2A2400C16, Disk: 512GB TOSHIBA-RD400, Graphics: MSI NVIDIA GeForce GTX 960 2048MB (1189/3505MHz), Audio: NVIDIA Device 0fba, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 17.04, Kernel: 4.10.0-21-generic (x86_64), Desktop: LXDE 0.9.3, Display Server: X Server 1.19.3, Display Driver: NVIDIA 375.39, Vulkan: 1.0.24, Compiler: GCC 6.3.0 20170406, File-System: ext4, Screen Resolution: 1920x1080
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 -v
postgresql OpenBenchmarking.org Phoronix Test Suite AMD Ryzen 7 1700 Eight-Core @ 3.80GHz (16 Cores) MSI X370 SLI PLUS (MS-7A33) v2.0 AMD Device 1450 2 x 16384 MB DDR4-1333MHz CMK32GX4M2A2400C16 512GB TOSHIBA-RD400 MSI NVIDIA GeForce GTX 960 2048MB (1189/3505MHz) NVIDIA Device 0fba Realtek RTL8111/8168/8411 Ubuntu 17.04 4.10.0-21-generic (x86_64) LXDE 0.9.3 X Server 1.19.3 NVIDIA 375.39 1.0.24 GCC 6.3.0 20170406 ext4 1920x1080 Processor Motherboard Chipset Memory Disk Graphics Audio Network OS Kernel Desktop Display Server Display Driver Vulkan Compiler File-System Screen Resolution Postgresql Benchmarks 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
postgresql pgbench: On-Disk - Normal Load - Read Write pgbench: Mostly RAM - Normal Load - Read Write pgbench: Buffer Test - Normal Load - Read Write pgbench: On-Disk - Heavy Contention - Read Write pgbench: Mostly RAM - Heavy Contention - Read Write pgbench: Buffer Test - Heavy Contention - Read Write postgresql 3480.16 4270.66 4480.47 1967.93 1995.67 2851.29 OpenBenchmarking.org
PostgreSQL pgbench OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: On-Disk - Test: Normal Load - Mode: Read Write postgresql 700 1400 2100 2800 3500 SE +/- 57.58, N = 3 3480.16 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write postgresql 900 1800 2700 3600 4500 SE +/- 62.30, N = 5 4270.66 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Write postgresql 1000 2000 3000 4000 5000 SE +/- 27.03, N = 3 4480.47 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write postgresql 400 800 1200 1600 2000 SE +/- 286.01, N = 6 1967.93 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write postgresql 400 800 1200 1600 2000 SE +/- 59.00, N = 6 1995.67 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write postgresql 600 1200 1800 2400 3000 SE +/- 84.85, N = 6 2851.29 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
postgresql Processor: AMD Ryzen 7 1700 Eight-Core @ 3.80GHz (16 Cores), Motherboard: MSI X370 SLI PLUS (MS-7A33) v2.0, Chipset: AMD Device 1450, Memory: 2 x 16384 MB DDR4-1333MHz CMK32GX4M2A2400C16, Disk: 512GB TOSHIBA-RD400, Graphics: MSI NVIDIA GeForce GTX 960 2048MB (1189/3505MHz), Audio: NVIDIA Device 0fba, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 17.04, Kernel: 4.10.0-21-generic (x86_64), Desktop: LXDE 0.9.3, Display Server: X Server 1.19.3, Display Driver: NVIDIA 375.39, Vulkan: 1.0.24, Compiler: GCC 6.3.0 20170406, File-System: ext4, Screen Resolution: 1920x1080
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 -v
Testing initiated at 25 May 2017 00:54 by user root.