Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 1706298-ASVA-170624646 pgall_1 - Phoronix Test Suite pgall_1 try to find the best setup for postgres over the dm-cache-bcache-btrfs-zfs field
HTML result view exported from: https://openbenchmarking.org/result/1706298-ASVA-170624646&grt&sor .
pgall_1 Processor Motherboard Chipset Memory Disk Graphics Audio Network OS Kernel Display Server Display Driver Compiler File-System Screen Resolution lvm io_default btrfs defaults bcache io_default btrfs defaults lvm io_default btrfs compress=lzo bcache io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default ext4 defaults bcache io_default ext4 defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 data=writeback,noatime,barrier=0,discard 2017-06-28 19:59 Intel Core i5-4590 @ 3.70GHz (4 Cores) MSI Z97-G43 (MS-7816) v3.0 Intel 4th Gen Core DRAM 2048MB 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550 Intel HD 4600 (1150MHz) Intel Xeon E3-1200 v3/4th Realtek RTL8111/8168/8411 Ubuntu 16.04 4.4.0-21-generic (x86_64) X Server 1.18.3 intel 2.99.917 GCC 5.4.0 20160609 overlayfs 2560x1440 Intel Core i7-4770 @ 3.90GHz (8 Cores) MSI H87-G43 (MS-7816) v1.0 32768MB 2 x 240GB INTEL SSDSC2BW24 + 2 x 2000GB Western Digital WD2000FYYZ-0 Intel Xeon E3-1200 v3/4th Gen Core IGP Debian 8.8 4.9.0-0.bpo.3-amd64 (x86_64) GCC 4.9.2 btrfs OpenBenchmarking.org Compiler Details - lvm io_default btrfs defaults: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - bcache io_default btrfs defaults: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - lvm io_default btrfs compress=lzo: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - bcache io_default btrfs compress=lzo: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - lvm io_default ext4 defaults: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - bcache io_default ext4 defaults: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - lvm io_default ext4 data=writeback,noatime,barrier=0,discard: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - bcache io_default ext4 data=writeback,noatime,barrier=0,discard: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --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 --enable-plugin --enable-shared --enable-threads=posix --host=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-tune=generic -v - 2017-06-28 19:59: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --enable-checking=release --enable-clocale=gnu --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,c++,java,go,d,fortran,objc,obj-c++ --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i586 --with-arch-directory=amd64 --with-multilib-list=m32,m64,mx32 --with-tune=generic -v Processor Details - Scaling Governor: intel_pstate powersave
pgall_1 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 lvm io_default btrfs defaults bcache io_default btrfs defaults lvm io_default btrfs compress=lzo bcache io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default ext4 defaults bcache io_default ext4 defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 data=writeback,noatime,barrier=0,discard 2017-06-28 19:59 20162.02 320.23 2544.95 68288.46 74.96 76977.46 552.10 300.23 20997.67 22864.92 23914.45 115.24 682.19 125.32 59083.32 61212.91 1004.38 428.94 316.91 94.05 77.54 68972.72 21.65 77598.54 464.00 376.19 20979.40 441.94 24192.07 111.47 195.49 126.84 44878.87 59583.66 340.92 391.66 8279.07 645.95 1619.90 68533.55 116.52 77873.82 936.25 477.56 21043.97 10505.61 23859.96 171.74 1082.41 171.73 57059.61 61400.30 1795.59 554.24 394.99 106.26 89.22 69187.91 23.01 78646.55 504.98 391.39 21371.39 552.71 24127.63 117.53 217.77 143.84 57826.54 65558.26 903.65 436.64 8415.20 861.65 1663.56 68515.65 198.94 76681.77 1478.58 744.76 21176.86 10887.11 23829.40 264.81 1341.64 288.41 55695.46 64219.48 2128.23 855.59 480.80 179.22 90.60 68750.92 66.35 79555.78 948.14 769.99 21345.45 626.15 24229.96 225.64 258.12 285.55 59553.10 62967.07 1141.40 902.53 9352.71 881.30 1844.51 68348.05 197.86 79021.37 1420.27 691.83 21042.27 8136.97 23658.49 262.64 1308.29 288.42 53077.35 62553.53 2205.65 897.73 481.75 149.00 83.68 69027.37 63.43 78960.68 844.85 714.72 21445.74 776.12 24208.31 209.57 293.57 269.88 58727.96 64438.64 1162.39 798.86 8222.94 496.86 1696.50 68431.89 180.52 78117.39 1182.25 704.48 20829.28 8935.02 23747.12 248.26 625.31 278.43 55526.16 60428.81 1753.10 906.72 601.40 150.23 95.75 69221.97 61.80 79764.80 786.32 793.59 21525.05 861.74 23874.24 215.30 239.40 289.34 58144.94 60061.36 1309.77 887.78 6346.92 1043.57 1421.21 68419.47 225.93 78498.80 1407.86 825.14 20951.10 6063.60 23699.76 263.07 1551.38 311.66 58797.71 62527.74 2317.44 933.81 1097.82 203.95 150.95 68988.32 89.21 79011.96 800.05 756.62 21489.61 2916.70 24073.67 201.78 467.98 270.11 57647.39 63223.74 1347.57 799.38 19742.34 796.36 2629.90 68721.78 261.81 76449.10 1367.92 870.78 20879.32 21463.91 23997.25 361.22 1222.51 367.21 51754.71 60854.15 1880.67 1068.65 350.11 137.41 77.50 68898.64 63.37 77521.60 722.40 802.34 20863.27 472.32 24067.91 214.49 197.12 285.92 23133.34 64625.50 695.35 870.25 7723.21 152.55 1716.87 68475.70 29.80 78414.43 363.90 157.50 21208.74 8135.81 23978.77 66.49 447.34 65.83 57908.50 60263.15 666.53 190.06 495.15 78.00 100.97 68431.94 22.13 77603.40 156.17 96.84 21151.75 652.21 23938.98 39.38 180.50 30.02 57898.56 61354.61 398.44 117.67 20477.31 277.43 2623.91 68665.06 43.21 76558.81 402.51 201.42 21093.49 21537.01 23904.58 66.82 790.29 77.73 58442.00 62560.36 881.87 225.00 347.49 79.88 78.51 68605.16 29.15 78959.40 198.92 65.85 21279.28 470.73 24092.47 46.61 164.73 32.78 15179.52 61428.74 211.12 100.28 13809.96 56.87 15.39 68904.84 20.99 78829.98 279.13 245.41 21556.72 417.58 23964.56 135.04 180.52 122.84 58106.86 59202.29 321.34 272.22 331.00 94.41 73.94 69132.36 23.28 77237.63 686.32 882.97 21432.19 418.68 24118.29 251.38 196.92 302.40 58360.52 60508.18 732.77 651.34 8274.22 101.27 29.10 69098.07 44.90 78665.06 771.73 7796.79 21474.24 387.20 24119.68 459.26 212.19 2252.17 59677.98 59413.91 1022.22 5579.31 332.38 280.53 74.03 68705.21 70.36 78362.26 1618.35 4460.02 21550.26 433.34 24302.63 951.96 304.93 2160.69 58564.96 61830.83 1496.92 3689.62 2089.02 352.36 262.85 98855.56 45.64 98601.19 608.06 511.74 22640.51 4410.96 23079.38 52.55 692.10 51.63 85568.67 91384.00 1314.64 1122.20 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 lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs defaults lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum 2017-06-28 19:59 bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_default btrfs defaults 4K 8K 12K 16K 20K SE +/- 281.41, N = 5 SE +/- 136.42, N = 3 SE +/- 304.64, N = 4 SE +/- 4325.01, N = 6 SE +/- 991.78, N = 6 SE +/- 641.31, N = 6 SE +/- 517.42, N = 6 SE +/- 2552.91, N = 6 SE +/- 354.20, N = 6 SE +/- 17.78, N = 3 SE +/- 273.32, N = 6 SE +/- 238.78, N = 6 SE +/- 253.91, N = 6 SE +/- 78.88, N = 6 SE +/- 27.91, N = 6 SE +/- 20.75, N = 6 SE +/- 22.29, N = 6 SE +/- 5.78, N = 6 SE +/- 5.56, N = 6 SE +/- 5.89, N = 4 SE +/- 4.48, N = 6 SE +/- 5.31, N = 4 SE +/- 18.63, N = 6 20477.31 20162.02 19742.34 13809.96 9352.71 8415.20 8279.07 8274.22 8222.94 7723.21 6346.92 2089.02 1097.82 601.40 495.15 481.75 480.80 394.99 350.11 347.49 332.38 331.00 316.91 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
PostgreSQL pgbench Scaling: On-Disk - Test: Normal Load - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: On-Disk - Test: Normal Load - Mode: Read Write lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag 2017-06-28 19:59 lvm io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_default btrfs compress=lzo lvm io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_default btrfs defaults bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default ext4 defaults 200 400 600 800 1000 SE +/- 42.21, N = 6 SE +/- 13.43, N = 6 SE +/- 24.49, N = 6 SE +/- 17.70, N = 6 SE +/- 23.29, N = 6 SE +/- 29.22, N = 6 SE +/- 19.59, N = 6 SE +/- 16.22, N = 6 SE +/- 13.00, N = 6 SE +/- 37.54, N = 6 SE +/- 11.59, N = 6 SE +/- 5.25, N = 6 SE +/- 11.00, N = 6 SE +/- 8.89, N = 6 SE +/- 10.96, N = 6 SE +/- 3.01, N = 6 SE +/- 3.38, N = 6 SE +/- 2.77, N = 6 SE +/- 1.50, N = 3 SE +/- 2.02, N = 6 SE +/- 2.92, N = 6 SE +/- 2.00, N = 6 SE +/- 1.11, N = 6 1043.57 881.30 861.65 796.36 645.95 496.86 352.36 320.23 280.53 277.43 203.95 179.22 152.55 150.23 149.00 137.41 106.26 101.27 94.41 94.05 79.88 78.00 56.87 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
PostgreSQL pgbench Scaling: On-Disk - Test: Single Thread - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Only lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum 2017-06-28 19:59 bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs defaults bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults 600 1200 1800 2400 3000 SE +/- 40.76, N = 5 SE +/- 43.84, N = 6 SE +/- 6.32, N = 3 SE +/- 68.16, N = 6 SE +/- 47.87, N = 6 SE +/- 42.66, N = 6 SE +/- 34.84, N = 6 SE +/- 38.51, N = 6 SE +/- 19.47, N = 3 SE +/- 11.30, N = 6 SE +/- 19.35, N = 6 SE +/- 8.94, N = 6 SE +/- 4.32, N = 6 SE +/- 2.89, N = 6 SE +/- 2.20, N = 6 SE +/- 2.69, N = 6 SE +/- 1.76, N = 6 SE +/- 1.20, N = 4 SE +/- 1.40, N = 6 SE +/- 0.45, N = 3 SE +/- 0.23, N = 3 SE +/- 3.90, N = 6 SE +/- 0.11, N = 3 2629.90 2623.91 2544.95 1844.51 1716.87 1696.50 1663.56 1619.90 1421.21 262.85 150.95 100.97 95.75 90.60 89.22 83.68 78.51 77.54 77.50 74.03 73.94 29.10 15.39 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
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 2017-06-28 19:59 bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_default btrfs compress=lzo bcache io_default ext4 defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults lvm io_default ext4 defaults bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs defaults 20K 40K 60K 80K 100K SE +/- 173.33, N = 3 SE +/- 196.73, N = 3 SE +/- 88.81, N = 3 SE +/- 265.65, N = 3 SE +/- 224.24, N = 3 SE +/- 160.58, N = 3 SE +/- 285.51, N = 3 SE +/- 278.01, N = 3 SE +/- 187.63, N = 3 SE +/- 241.90, N = 3 SE +/- 271.25, N = 3 SE +/- 181.55, N = 3 SE +/- 458.70, N = 3 SE +/- 354.48, N = 3 SE +/- 353.33, N = 3 SE +/- 340.40, N = 3 SE +/- 273.67, N = 3 SE +/- 367.20, N = 3 SE +/- 173.34, N = 3 SE +/- 95.42, N = 3 SE +/- 234.84, N = 3 SE +/- 98.15, N = 3 SE +/- 239.47, N = 3 98855.56 69221.97 69187.91 69132.36 69098.07 69027.37 68988.32 68972.72 68904.84 68898.64 68750.92 68721.78 68705.21 68665.06 68605.16 68533.55 68515.65 68475.70 68431.94 68431.89 68419.47 68348.05 68288.46 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
PostgreSQL pgbench Scaling: On-Disk - Test: Single Thread - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Write lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag 2017-06-28 19:59 lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default ext4 defaults bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs defaults lvm io_default ext4 defaults 60 120 180 240 300 SE +/- 2.10, N = 3 SE +/- 4.68, N = 6 SE +/- 3.05, N = 3 SE +/- 3.06, N = 4 SE +/- 4.14, N = 6 SE +/- 2.12, N = 6 SE +/- 4.69, N = 6 SE +/- 1.53, N = 6 SE +/- 0.56, N = 3 SE +/- 0.99, N = 3 SE +/- 2.59, N = 6 SE +/- 0.30, N = 3 SE +/- 2.78, N = 6 SE +/- 1.65, N = 6 SE +/- 0.82, N = 3 SE +/- 0.51, N = 3 SE +/- 0.25, N = 3 SE +/- 0.69, N = 6 SE +/- 0.61, N = 6 SE +/- 0.36, N = 6 SE +/- 5.21, N = 6 SE +/- 0.39, N = 3 SE +/- 1.95, N = 6 261.81 225.93 198.94 197.86 180.52 116.52 89.21 74.96 70.36 66.35 63.43 63.37 61.80 45.64 44.90 43.21 29.80 29.15 23.28 23.01 22.13 21.65 20.99 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
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 2017-06-28 19:59 bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default ext4 defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default btrfs compress=lzo lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs defaults bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_default ext4 defaults lvm io_default btrfs defaults lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow 20K 40K 60K 80K 100K SE +/- 249.33, N = 3 SE +/- 1420.32, N = 3 SE +/- 360.56, N = 3 SE +/- 1146.43, N = 3 SE +/- 1161.11, N = 3 SE +/- 414.51, N = 3 SE +/- 864.73, N = 3 SE +/- 344.69, N = 3 SE +/- 903.09, N = 3 SE +/- 359.72, N = 3 SE +/- 537.93, N = 3 SE +/- 842.39, N = 3 SE +/- 1401.16, N = 3 SE +/- 677.98, N = 3 SE +/- 163.90, N = 3 SE +/- 263.15, N = 3 SE +/- 892.84, N = 3 SE +/- 658.62, N = 3 SE +/- 212.90, N = 3 SE +/- 908.41, N = 3 SE +/- 600.35, N = 3 SE +/- 678.12, N = 3 SE +/- 664.13, N = 3 98601.19 79764.80 79555.78 79021.37 79011.96 78960.68 78959.40 78829.98 78665.06 78646.55 78498.80 78414.43 78362.26 78117.39 77873.82 77603.40 77598.54 77521.60 77237.63 76977.46 76681.77 76558.81 76449.10 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
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 bcache io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_default ext4 defaults 2017-06-28 19:59 lvm io_default btrfs defaults bcache io_default btrfs compress=lzo bcache io_default btrfs defaults lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default ext4 defaults bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog 300 600 900 1200 1500 SE +/- 52.12, N = 6 SE +/- 82.85, N = 6 SE +/- 106.65, N = 6 SE +/- 85.87, N = 6 SE +/- 54.49, N = 6 SE +/- 64.39, N = 6 SE +/- 9.78, N = 3 SE +/- 69.74, N = 6 SE +/- 31.95, N = 6 SE +/- 28.49, N = 6 SE +/- 24.13, N = 6 SE +/- 21.57, N = 6 SE +/- 7.08, N = 3 SE +/- 22.10, N = 6 SE +/- 39.59, N = 6 SE +/- 13.93, N = 6 SE +/- 8.44, N = 3 SE +/- 27.77, N = 6 SE +/- 2.10, N = 3 SE +/- 16.96, N = 6 SE +/- 4.76, N = 4 SE +/- 6.54, N = 6 SE +/- 20.18, N = 6 1618.35 1478.58 1420.27 1407.86 1367.92 1182.25 948.14 936.25 844.85 800.05 786.32 771.73 722.40 686.32 608.06 552.10 504.98 464.00 402.51 363.90 279.13 198.92 156.17 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
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 lvm io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 2017-06-28 19:59 lvm io_default btrfs compress=lzo bcache io_default btrfs compress=lzo bcache io_default btrfs defaults lvm io_default btrfs defaults lvm io_default ext4 defaults lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow 2K 4K 6K 8K 10K SE +/- 38.39, N = 3 SE +/- 73.28, N = 6 SE +/- 4.71, N = 3 SE +/- 36.07, N = 6 SE +/- 49.09, N = 6 SE +/- 24.40, N = 6 SE +/- 10.59, N = 3 SE +/- 7.66, N = 3 SE +/- 9.68, N = 3 SE +/- 31.47, N = 6 SE +/- 17.28, N = 6 SE +/- 26.15, N = 6 SE +/- 29.69, N = 6 SE +/- 30.01, N = 6 SE +/- 32.26, N = 6 SE +/- 8.78, N = 6 SE +/- 20.76, N = 6 SE +/- 14.99, N = 6 SE +/- 6.82, N = 6 SE +/- 4.33, N = 6 SE +/- 4.80, N = 6 SE +/- 16.88, N = 6 SE +/- 3.16, N = 6 7796.79 4460.02 882.97 870.78 825.14 802.34 793.59 769.99 756.62 744.76 714.72 704.48 691.83 511.74 477.56 391.39 376.19 300.23 245.41 201.42 157.50 96.84 65.85 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
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 2017-06-28 19:59 lvm io_default ext4 defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default ext4 defaults bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=lzo lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs defaults bcache io_default btrfs defaults lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag 5K 10K 15K 20K 25K SE +/- 79.83, N = 3 SE +/- 79.14, N = 3 SE +/- 63.85, N = 3 SE +/- 42.19, N = 3 SE +/- 45.25, N = 3 SE +/- 162.74, N = 3 SE +/- 39.10, N = 3 SE +/- 107.00, N = 3 SE +/- 57.96, N = 3 SE +/- 116.08, N = 3 SE +/- 163.79, N = 3 SE +/- 107.38, N = 3 SE +/- 122.72, N = 3 SE +/- 301.89, N = 3 SE +/- 27.25, N = 3 SE +/- 145.21, N = 3 SE +/- 148.23, N = 3 SE +/- 83.52, N = 3 SE +/- 378.36, N = 3 SE +/- 35.40, N = 3 SE +/- 247.98, N = 3 SE +/- 319.38, N = 3 SE +/- 137.69, N = 3 22640.51 21556.72 21550.26 21525.05 21489.61 21474.24 21445.74 21432.19 21371.39 21345.45 21279.28 21208.74 21176.86 21151.75 21093.49 21043.97 21042.27 20997.67 20979.40 20951.10 20879.32 20863.27 20829.28 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
PostgreSQL pgbench Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only lvm io_default btrfs defaults lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum 2017-06-28 19:59 bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults lvm io_default ext4 defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard 5K 10K 15K 20K 25K SE +/- 384.86, N = 3 SE +/- 744.48, N = 6 SE +/- 771.87, N = 6 SE +/- 913.62, N = 6 SE +/- 941.62, N = 6 SE +/- 544.19, N = 6 SE +/- 4.58, N = 3 SE +/- 3.48, N = 3 SE +/- 73.98, N = 3 SE +/- 378.72, N = 6 SE +/- 240.27, N = 6 SE +/- 178.69, N = 6 SE +/- 34.55, N = 6 SE +/- 39.35, N = 6 SE +/- 53.20, N = 6 SE +/- 16.69, N = 6 SE +/- 8.79, N = 6 SE +/- 8.27, N = 6 SE +/- 9.05, N = 6 SE +/- 5.46, N = 3 SE +/- 2.52, N = 3 SE +/- 1.37, N = 3 SE +/- 13.34, N = 6 22864.92 21537.01 21463.91 10887.11 10505.61 8935.02 8136.97 8135.81 6063.60 4410.96 2916.70 861.74 776.12 652.21 626.15 552.71 472.32 470.73 441.94 433.34 418.68 417.58 387.20 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
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 bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default btrfs compress=lzo lvm io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default ext4 defaults bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs defaults lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 2017-06-28 19:59 5K 10K 15K 20K 25K SE +/- 44.16, N = 3 SE +/- 77.34, N = 3 SE +/- 82.65, N = 3 SE +/- 73.18, N = 3 SE +/- 192.02, N = 3 SE +/- 171.49, N = 3 SE +/- 150.24, N = 3 SE +/- 48.70, N = 3 SE +/- 62.77, N = 3 SE +/- 218.76, N = 3 SE +/- 124.91, N = 3 SE +/- 202.42, N = 3 SE +/- 134.13, N = 3 SE +/- 230.73, N = 3 SE +/- 123.84, N = 3 SE +/- 232.89, N = 3 SE +/- 87.86, N = 3 SE +/- 109.36, N = 3 SE +/- 75.78, N = 3 SE +/- 103.07, N = 3 SE +/- 199.54, N = 3 SE +/- 50.83, N = 3 SE +/- 187.82, N = 3 24302.63 24229.96 24208.31 24192.07 24127.63 24119.68 24118.29 24092.47 24073.67 24067.91 23997.25 23978.77 23964.56 23938.98 23914.45 23904.58 23874.24 23859.96 23829.40 23747.12 23699.76 23658.49 23079.38 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
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 bcache io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default ext4 defaults lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default ext4 defaults bcache io_default btrfs compress=lzo lvm io_default btrfs defaults bcache io_default btrfs defaults lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog 2017-06-28 19:59 bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog 200 400 600 800 1000 SE +/- 46.58, N = 6 SE +/- 12.77, N = 6 SE +/- 6.33, N = 6 SE +/- 18.66, N = 6 SE +/- 17.47, N = 6 SE +/- 18.41, N = 6 SE +/- 23.43, N = 6 SE +/- 13.36, N = 6 SE +/- 18.02, N = 6 SE +/- 7.35, N = 6 SE +/- 3.71, N = 3 SE +/- 10.57, N = 6 SE +/- 1.70, N = 3 SE +/- 13.52, N = 6 SE +/- 4.92, N = 6 SE +/- 2.21, N = 3 SE +/- 4.33, N = 6 SE +/- 5.67, N = 6 SE +/- 1.48, N = 6 SE +/- 2.70, N = 6 SE +/- 3.97, N = 6 SE +/- 4.44, N = 6 SE +/- 4.92, N = 6 951.96 459.26 361.22 264.81 263.07 262.64 251.38 248.26 225.64 215.30 214.49 209.57 201.78 171.74 135.04 117.53 115.24 111.47 66.82 66.49 52.55 46.61 39.38 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
PostgreSQL pgbench Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.6.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow 2017-06-28 19:59 lvm io_default btrfs defaults lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_default btrfs compress=lzo lvm io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_default ext4 defaults bcache io_default btrfs defaults lvm io_default ext4 defaults bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow 300 600 900 1200 1500 SE +/- 44.00, N = 6 SE +/- 12.19, N = 3 SE +/- 23.73, N = 6 SE +/- 39.30, N = 6 SE +/- 26.99, N = 6 SE +/- 26.75, N = 6 SE +/- 52.69, N = 6 SE +/- 18.32, N = 6 SE +/- 76.70, N = 6 SE +/- 20.82, N = 6 SE +/- 14.04, N = 6 SE +/- 8.49, N = 6 SE +/- 8.88, N = 6 SE +/- 2.65, N = 3 SE +/- 7.39, N = 6 SE +/- 3.18, N = 6 SE +/- 15.51, N = 6 SE +/- 3.80, N = 3 SE +/- 1.70, N = 3 SE +/- 4.87, N = 6 SE +/- 3.05, N = 6 SE +/- 9.63, N = 6 SE +/- 2.39, N = 6 1551.38 1341.64 1308.29 1222.51 1082.41 790.29 692.10 682.19 625.31 467.98 447.34 304.93 293.57 258.12 239.40 217.77 212.19 197.12 196.92 195.49 180.52 180.50 164.73 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
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 lvm io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default ext4 defaults bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo bcache io_default btrfs compress=lzo bcache io_default btrfs defaults lvm io_default btrfs defaults lvm io_default ext4 defaults lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog 2017-06-28 19:59 bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog 500 1000 1500 2000 2500 SE +/- 45.26, N = 6 SE +/- 21.40, N = 3 SE +/- 15.29, N = 6 SE +/- 21.76, N = 6 SE +/- 20.62, N = 6 SE +/- 4.28, N = 5 SE +/- 17.15, N = 6 SE +/- 19.53, N = 6 SE +/- 16.31, N = 6 SE +/- 6.18, N = 6 SE +/- 16.30, N = 6 SE +/- 2.34, N = 3 SE +/- 6.98, N = 6 SE +/- 12.53, N = 6 SE +/- 1.88, N = 3 SE +/- 7.51, N = 6 SE +/- 13.46, N = 6 SE +/- 14.33, N = 6 SE +/- 2.64, N = 6 SE +/- 5.54, N = 6 SE +/- 4.27, N = 6 SE +/- 0.79, N = 6 SE +/- 5.68, N = 6 2252.17 2160.69 367.21 311.66 302.40 289.34 288.42 288.41 285.92 285.55 278.43 270.11 269.88 171.73 143.84 126.84 125.32 122.84 77.73 65.83 51.63 32.78 30.02 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
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 2017-06-28 19:59 lvm io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default ext4 defaults bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default ext4 defaults lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs compress=lzo bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_default btrfs defaults bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow 20K 40K 60K 80K 100K SE +/- 1090.39, N = 3 SE +/- 864.58, N = 6 SE +/- 873.00, N = 3 SE +/- 1544.48, N = 6 SE +/- 667.86, N = 3 SE +/- 270.78, N = 3 SE +/- 481.02, N = 3 SE +/- 642.23, N = 3 SE +/- 437.40, N = 3 SE +/- 110.78, N = 3 SE +/- 837.83, N = 3 SE +/- 857.52, N = 3 SE +/- 809.91, N = 5 SE +/- 346.98, N = 3 SE +/- 649.05, N = 3 SE +/- 551.80, N = 3 SE +/- 2198.62, N = 6 SE +/- 2045.70, N = 6 SE +/- 2735.87, N = 6 SE +/- 3786.54, N = 6 SE +/- 9312.69, N = 6 SE +/- 10271.50, N = 6 SE +/- 8949.19, N = 6 85568.67 59677.98 59553.10 59083.32 58797.71 58727.96 58564.96 58442.00 58360.52 58144.94 58106.86 57908.50 57898.56 57826.54 57647.39 57059.61 55695.46 55526.16 53077.35 51754.71 44878.87 23133.34 15179.52 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
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 2017-06-28 19:59 bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs defaults lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow bcache io_default ext4 defaults lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults 20K 40K 60K 80K 100K SE +/- 1308.68, N = 3 SE +/- 1261.90, N = 6 SE +/- 2141.87, N = 6 SE +/- 182.09, N = 3 SE +/- 3267.18, N = 6 SE +/- 936.58, N = 3 SE +/- 2975.06, N = 6 SE +/- 801.99, N = 3 SE +/- 1988.91, N = 6 SE +/- 2324.68, N = 6 SE +/- 2992.06, N = 6 SE +/- 1102.28, N = 3 SE +/- 2095.61, N = 6 SE +/- 1328.76, N = 6 SE +/- 1000.79, N = 6 SE +/- 1633.90, N = 6 SE +/- 2400.87, N = 6 SE +/- 1765.40, N = 6 SE +/- 2037.87, N = 6 SE +/- 2219.46, N = 6 SE +/- 1340.56, N = 6 SE +/- 1538.63, N = 6 SE +/- 1827.25, N = 6 91384.00 65558.26 64625.50 64438.64 64219.48 63223.74 62967.07 62560.36 62553.53 62527.74 61830.83 61428.74 61400.30 61354.61 61212.91 60854.15 60508.18 60428.81 60263.15 60061.36 59583.66 59413.91 59202.29 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
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 lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum 2017-06-28 19:59 bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default btrfs defaults bcache io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default ext4 defaults bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs defaults lvm io_default ext4 defaults bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow 500 1000 1500 2000 2500 SE +/- 134.32, N = 6 SE +/- 154.00, N = 6 SE +/- 139.20, N = 6 SE +/- 33.06, N = 3 SE +/- 141.45, N = 6 SE +/- 12.71, N = 3 SE +/- 84.37, N = 6 SE +/- 62.62, N = 6 SE +/- 93.39, N = 6 SE +/- 133.61, N = 6 SE +/- 34.35, N = 6 SE +/- 35.67, N = 6 SE +/- 226.19, N = 6 SE +/- 40.99, N = 6 SE +/- 33.46, N = 6 SE +/- 39.45, N = 6 SE +/- 62.15, N = 6 SE +/- 82.09, N = 6 SE +/- 44.27, N = 6 SE +/- 76.23, N = 6 SE +/- 76.71, N = 6 SE +/- 4.98, N = 3 SE +/- 16.00, N = 6 2317.44 2205.65 2128.23 1880.67 1795.59 1753.10 1496.92 1347.57 1314.64 1309.77 1162.39 1141.40 1022.22 1004.38 903.65 881.87 732.77 695.35 666.53 398.44 340.92 321.34 211.12 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
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 lvm io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 data=writeback,noatime,barrier=0,discard 2017-06-28 19:59 lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum bcache io_default ext4 defaults lvm io_default btrfs compress=lzo bcache io_default btrfs compress=lzo lvm io_default btrfs defaults bcache io_default btrfs defaults lvm io_default ext4 defaults lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow 1200 2400 3600 4800 6000 SE +/- 119.98, N = 6 SE +/- 52.78, N = 3 SE +/- 46.75, N = 6 SE +/- 19.50, N = 3 SE +/- 46.96, N = 6 SE +/- 55.48, N = 6 SE +/- 4.26, N = 3 SE +/- 53.22, N = 6 SE +/- 16.21, N = 3 SE +/- 36.75, N = 6 SE +/- 30.07, N = 6 SE +/- 15.94, N = 3 SE +/- 10.09, N = 3 SE +/- 199.68, N = 6 SE +/- 27.90, N = 6 SE +/- 8.43, N = 6 SE +/- 24.37, N = 6 SE +/- 16.83, N = 6 SE +/- 16.11, N = 6 SE +/- 7.49, N = 6 SE +/- 9.21, N = 6 SE +/- 19.58, N = 6 SE +/- 11.43, N = 6 5579.31 3689.62 1122.20 1068.65 933.81 906.72 902.53 897.73 887.78 870.25 855.59 799.38 798.86 651.34 554.24 436.64 428.94 391.66 272.22 225.00 190.06 117.67 100.28 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
Phoronix Test Suite v10.8.4