Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 1706295-ASVA-170624683 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/1706295-ASVA-170624683&sro&gru .
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 989.50 167.13 191.60 93307.23 31.15 93604.64 445.39 328.59 22456.10 8236.50 22705.40 35.82 495.86 33.00 84719.68 86173.55 928.77 657.03 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 2017-06-28 19:59 bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow 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,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 4K 8K 12K 16K 20K SE +/- 115.77, N = 6 SE +/- 5.78, N = 6 SE +/- 5.56, N = 6 SE +/- 22.29, N = 6 SE +/- 78.88, N = 6 SE +/- 27.91, N = 6 SE +/- 5.89, N = 4 SE +/- 253.91, N = 6 SE +/- 18.63, N = 6 SE +/- 4.48, N = 6 SE +/- 5.31, N = 4 SE +/- 20.75, N = 6 SE +/- 517.42, N = 6 SE +/- 304.64, N = 4 SE +/- 641.31, N = 6 SE +/- 354.20, N = 6 SE +/- 17.78, N = 3 SE +/- 281.41, N = 5 SE +/- 273.32, N = 6 SE +/- 136.42, N = 3 SE +/- 2552.91, N = 6 SE +/- 4325.01, N = 6 SE +/- 991.78, N = 6 989.50 394.99 350.11 480.80 601.40 495.15 347.49 1097.82 316.91 332.38 331.00 481.75 8279.07 19742.34 8415.20 8222.94 7723.21 20477.31 6346.92 20162.02 8274.22 13809.96 9352.71 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 2017-06-28 19:59 bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow 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,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 200 400 600 800 1000 SE +/- 13.02, N = 6 SE +/- 3.38, N = 6 SE +/- 3.01, N = 6 SE +/- 5.25, N = 6 SE +/- 8.89, N = 6 SE +/- 2.00, N = 6 SE +/- 2.92, N = 6 SE +/- 11.59, N = 6 SE +/- 2.02, N = 6 SE +/- 13.00, N = 6 SE +/- 1.50, N = 3 SE +/- 10.96, N = 6 SE +/- 23.29, N = 6 SE +/- 17.70, N = 6 SE +/- 24.49, N = 6 SE +/- 29.22, N = 6 SE +/- 11.00, N = 6 SE +/- 37.54, N = 6 SE +/- 42.21, N = 6 SE +/- 16.22, N = 6 SE +/- 2.77, N = 6 SE +/- 1.11, N = 6 SE +/- 13.43, N = 6 167.13 106.26 137.41 179.22 150.23 78.00 79.88 203.95 94.05 280.53 94.41 149.00 645.95 796.36 861.65 496.86 152.55 277.43 1043.57 320.23 101.27 56.87 881.30 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 2017-06-28 19:59 bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow 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,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 600 1200 1800 2400 3000 SE +/- 1.98, N = 3 SE +/- 2.20, N = 6 SE +/- 1.40, N = 6 SE +/- 2.89, N = 6 SE +/- 4.32, N = 6 SE +/- 8.94, N = 6 SE +/- 1.76, N = 6 SE +/- 19.35, N = 6 SE +/- 1.20, N = 4 SE +/- 0.45, N = 3 SE +/- 0.23, N = 3 SE +/- 2.69, N = 6 SE +/- 38.51, N = 6 SE +/- 40.76, N = 5 SE +/- 34.84, N = 6 SE +/- 42.66, N = 6 SE +/- 47.87, N = 6 SE +/- 43.84, N = 6 SE +/- 19.47, N = 3 SE +/- 6.32, N = 3 SE +/- 3.90, N = 6 SE +/- 0.11, N = 3 SE +/- 68.16, N = 6 191.60 89.22 77.50 90.60 95.75 100.97 78.51 150.95 77.54 74.03 73.94 83.68 1619.90 2629.90 1663.56 1696.50 1716.87 2623.91 1421.21 2544.95 29.10 15.39 1844.51 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 bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow 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,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 20K 40K 60K 80K 100K SE +/- 241.83, N = 3 SE +/- 88.81, N = 3 SE +/- 241.90, N = 3 SE +/- 271.25, N = 3 SE +/- 196.73, N = 3 SE +/- 173.34, N = 3 SE +/- 353.33, N = 3 SE +/- 285.51, N = 3 SE +/- 278.01, N = 3 SE +/- 458.70, N = 3 SE +/- 265.65, N = 3 SE +/- 160.58, N = 3 SE +/- 340.40, N = 3 SE +/- 181.55, N = 3 SE +/- 273.67, N = 3 SE +/- 95.42, N = 3 SE +/- 367.20, N = 3 SE +/- 354.48, N = 3 SE +/- 234.84, N = 3 SE +/- 239.47, N = 3 SE +/- 224.24, N = 3 SE +/- 187.63, N = 3 SE +/- 98.15, N = 3 93307.23 69187.91 68898.64 68750.92 69221.97 68431.94 68605.16 68988.32 68972.72 68705.21 69132.36 69027.37 68533.55 68721.78 68515.65 68431.89 68475.70 68665.06 68419.47 68288.46 69098.07 68904.84 68348.05 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 2017-06-28 19:59 bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow 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,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 60 120 180 240 300 SE +/- 1.39, N = 6 SE +/- 0.36, N = 6 SE +/- 0.30, N = 3 SE +/- 0.99, N = 3 SE +/- 2.78, N = 6 SE +/- 5.21, N = 6 SE +/- 0.69, N = 6 SE +/- 4.69, N = 6 SE +/- 0.39, N = 3 SE +/- 0.56, N = 3 SE +/- 0.61, N = 6 SE +/- 2.59, N = 6 SE +/- 2.12, N = 6 SE +/- 2.10, N = 3 SE +/- 3.05, N = 3 SE +/- 4.14, N = 6 SE +/- 0.25, N = 3 SE +/- 0.51, N = 3 SE +/- 4.68, N = 6 SE +/- 1.53, N = 6 SE +/- 0.82, N = 3 SE +/- 1.95, N = 6 SE +/- 3.06, N = 4 31.15 23.01 63.37 66.35 61.80 22.13 29.15 89.21 21.65 70.36 23.28 63.43 116.52 261.81 198.94 180.52 29.80 43.21 225.93 74.96 44.90 20.99 197.86 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 bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow 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,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 20K 40K 60K 80K 100K SE +/- 168.43, N = 3 SE +/- 359.72, N = 3 SE +/- 658.62, N = 3 SE +/- 360.56, N = 3 SE +/- 1420.32, N = 3 SE +/- 263.15, N = 3 SE +/- 864.73, N = 3 SE +/- 1161.11, N = 3 SE +/- 892.84, N = 3 SE +/- 1401.16, N = 3 SE +/- 212.90, N = 3 SE +/- 414.51, N = 3 SE +/- 163.90, N = 3 SE +/- 664.13, N = 3 SE +/- 600.35, N = 3 SE +/- 677.98, N = 3 SE +/- 842.39, N = 3 SE +/- 678.12, N = 3 SE +/- 537.93, N = 3 SE +/- 908.41, N = 3 SE +/- 903.09, N = 3 SE +/- 344.69, N = 3 SE +/- 1146.43, N = 3 93604.64 78646.55 77521.60 79555.78 79764.80 77603.40 78959.40 79011.96 77598.54 78362.26 77237.63 78960.68 77873.82 76449.10 76681.77 78117.39 78414.43 76558.81 78498.80 76977.46 78665.06 78829.98 79021.37 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 2017-06-28 19:59 bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow 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,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 300 600 900 1200 1500 SE +/- 26.61, N = 6 SE +/- 8.44, N = 3 SE +/- 7.08, N = 3 SE +/- 9.78, N = 3 SE +/- 24.13, N = 6 SE +/- 20.18, N = 6 SE +/- 6.54, N = 6 SE +/- 28.49, N = 6 SE +/- 27.77, N = 6 SE +/- 52.12, N = 6 SE +/- 22.10, N = 6 SE +/- 31.95, N = 6 SE +/- 69.74, N = 6 SE +/- 54.49, N = 6 SE +/- 82.85, N = 6 SE +/- 64.39, N = 6 SE +/- 16.96, N = 6 SE +/- 2.10, N = 3 SE +/- 85.87, N = 6 SE +/- 13.93, N = 6 SE +/- 21.57, N = 6 SE +/- 4.76, N = 4 SE +/- 106.65, N = 6 445.39 504.98 722.40 948.14 786.32 156.17 198.92 800.05 464.00 1618.35 686.32 844.85 936.25 1367.92 1478.58 1182.25 363.90 402.51 1407.86 552.10 771.73 279.13 1420.27 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 2017-06-28 19:59 bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow 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,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 2K 4K 6K 8K 10K SE +/- 25.19, N = 6 SE +/- 8.78, N = 6 SE +/- 24.40, N = 6 SE +/- 7.66, N = 3 SE +/- 10.59, N = 3 SE +/- 16.88, N = 6 SE +/- 3.16, N = 6 SE +/- 9.68, N = 3 SE +/- 20.76, N = 6 SE +/- 73.28, N = 6 SE +/- 4.71, N = 3 SE +/- 17.28, N = 6 SE +/- 32.26, N = 6 SE +/- 36.07, N = 6 SE +/- 31.47, N = 6 SE +/- 26.15, N = 6 SE +/- 4.80, N = 6 SE +/- 4.33, N = 6 SE +/- 49.09, N = 6 SE +/- 14.99, N = 6 SE +/- 38.39, N = 3 SE +/- 6.82, N = 6 SE +/- 29.69, N = 6 328.59 391.39 802.34 769.99 793.59 96.84 65.85 756.62 376.19 4460.02 882.97 714.72 477.56 870.78 744.76 704.48 157.50 201.42 825.14 300.23 7796.79 245.41 691.83 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 bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow 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,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 5K 10K 15K 20K 25K SE +/- 120.51, N = 3 SE +/- 57.96, N = 3 SE +/- 319.38, N = 3 SE +/- 116.08, N = 3 SE +/- 42.19, N = 3 SE +/- 301.89, N = 3 SE +/- 163.79, N = 3 SE +/- 45.25, N = 3 SE +/- 378.36, N = 3 SE +/- 63.85, N = 3 SE +/- 107.00, N = 3 SE +/- 39.10, N = 3 SE +/- 145.21, N = 3 SE +/- 247.98, N = 3 SE +/- 122.72, N = 3 SE +/- 137.69, N = 3 SE +/- 107.38, N = 3 SE +/- 27.25, N = 3 SE +/- 35.40, N = 3 SE +/- 83.52, N = 3 SE +/- 162.74, N = 3 SE +/- 79.14, N = 3 SE +/- 148.23, N = 3 22456.10 21371.39 20863.27 21345.45 21525.05 21151.75 21279.28 21489.61 20979.40 21550.26 21432.19 21445.74 21043.97 20879.32 21176.86 20829.28 21208.74 21093.49 20951.10 20997.67 21474.24 21556.72 21042.27 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 2017-06-28 19:59 bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow 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,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 5K 10K 15K 20K 25K SE +/- 1182.96, N = 6 SE +/- 16.69, N = 6 SE +/- 8.79, N = 6 SE +/- 53.20, N = 6 SE +/- 178.69, N = 6 SE +/- 39.35, N = 6 SE +/- 8.27, N = 6 SE +/- 240.27, N = 6 SE +/- 9.05, N = 6 SE +/- 5.46, N = 3 SE +/- 2.52, N = 3 SE +/- 34.55, N = 6 SE +/- 941.62, N = 6 SE +/- 771.87, N = 6 SE +/- 913.62, N = 6 SE +/- 544.19, N = 6 SE +/- 3.48, N = 3 SE +/- 744.48, N = 6 SE +/- 73.98, N = 3 SE +/- 384.86, N = 3 SE +/- 13.34, N = 6 SE +/- 1.37, N = 3 SE +/- 4.58, N = 3 8236.50 552.71 472.32 626.15 861.74 652.21 470.73 2916.70 441.94 433.34 418.68 776.12 10505.61 21463.91 10887.11 8935.02 8135.81 21537.01 6063.60 22864.92 387.20 417.58 8136.97 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 2017-06-28 19:59 bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow 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,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 5K 10K 15K 20K 25K SE +/- 148.03, N = 3 SE +/- 192.02, N = 3 SE +/- 218.76, N = 3 SE +/- 77.34, N = 3 SE +/- 87.86, N = 3 SE +/- 230.73, N = 3 SE +/- 48.70, N = 3 SE +/- 62.77, N = 3 SE +/- 73.18, N = 3 SE +/- 44.16, N = 3 SE +/- 150.24, N = 3 SE +/- 82.65, N = 3 SE +/- 109.36, N = 3 SE +/- 124.91, N = 3 SE +/- 75.78, N = 3 SE +/- 103.07, N = 3 SE +/- 202.42, N = 3 SE +/- 232.89, N = 3 SE +/- 199.54, N = 3 SE +/- 123.84, N = 3 SE +/- 171.49, N = 3 SE +/- 134.13, N = 3 SE +/- 50.83, N = 3 22705.40 24127.63 24067.91 24229.96 23874.24 23938.98 24092.47 24073.67 24192.07 24302.63 24118.29 24208.31 23859.96 23997.25 23829.40 23747.12 23978.77 23904.58 23699.76 23914.45 24119.68 23964.56 23658.49 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 2017-06-28 19:59 bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow 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,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 200 400 600 800 1000 SE +/- 1.15, N = 6 SE +/- 2.21, N = 3 SE +/- 3.71, N = 3 SE +/- 18.02, N = 6 SE +/- 7.35, N = 6 SE +/- 4.92, N = 6 SE +/- 4.44, N = 6 SE +/- 1.70, N = 3 SE +/- 5.67, N = 6 SE +/- 46.58, N = 6 SE +/- 23.43, N = 6 SE +/- 10.57, N = 6 SE +/- 13.52, N = 6 SE +/- 6.33, N = 6 SE +/- 18.66, N = 6 SE +/- 13.36, N = 6 SE +/- 2.70, N = 6 SE +/- 1.48, N = 6 SE +/- 17.47, N = 6 SE +/- 4.33, N = 6 SE +/- 12.77, N = 6 SE +/- 4.92, N = 6 SE +/- 18.41, N = 6 35.82 117.53 214.49 225.64 215.30 39.38 46.61 201.78 111.47 951.96 251.38 209.57 171.74 361.22 264.81 248.26 66.49 66.82 263.07 115.24 459.26 135.04 262.64 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 2017-06-28 19:59 bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow 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,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 300 600 900 1200 1500 SE +/- 24.03, N = 6 SE +/- 3.18, N = 6 SE +/- 3.80, N = 3 SE +/- 2.65, N = 3 SE +/- 7.39, N = 6 SE +/- 9.63, N = 6 SE +/- 2.39, N = 6 SE +/- 20.82, N = 6 SE +/- 4.87, N = 6 SE +/- 8.49, N = 6 SE +/- 1.70, N = 3 SE +/- 8.88, N = 6 SE +/- 26.99, N = 6 SE +/- 39.30, N = 6 SE +/- 12.19, N = 3 SE +/- 76.70, N = 6 SE +/- 14.04, N = 6 SE +/- 26.75, N = 6 SE +/- 44.00, N = 6 SE +/- 18.32, N = 6 SE +/- 15.51, N = 6 SE +/- 3.05, N = 6 SE +/- 23.73, N = 6 495.86 217.77 197.12 258.12 239.40 180.50 164.73 467.98 195.49 304.93 196.92 293.57 1082.41 1222.51 1341.64 625.31 447.34 790.29 1551.38 682.19 212.19 180.52 1308.29 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 2017-06-28 19:59 bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow 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,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 500 1000 1500 2000 2500 SE +/- 1.35, N = 6 SE +/- 1.88, N = 3 SE +/- 16.31, N = 6 SE +/- 6.18, N = 6 SE +/- 4.28, N = 5 SE +/- 5.68, N = 6 SE +/- 0.79, N = 6 SE +/- 2.34, N = 3 SE +/- 7.51, N = 6 SE +/- 21.40, N = 3 SE +/- 20.62, N = 6 SE +/- 6.98, N = 6 SE +/- 12.53, N = 6 SE +/- 15.29, N = 6 SE +/- 19.53, N = 6 SE +/- 16.30, N = 6 SE +/- 5.54, N = 6 SE +/- 2.64, N = 6 SE +/- 21.76, N = 6 SE +/- 13.46, N = 6 SE +/- 45.26, N = 6 SE +/- 14.33, N = 6 SE +/- 17.15, N = 6 33.00 143.84 285.92 285.55 289.34 30.02 32.78 270.11 126.84 2160.69 302.40 269.88 171.73 367.21 288.41 278.43 65.83 77.73 311.66 125.32 2252.17 122.84 288.42 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 bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow 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,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 20K 40K 60K 80K 100K SE +/- 1222.64, N = 6 SE +/- 346.98, N = 3 SE +/- 10271.50, N = 6 SE +/- 873.00, N = 3 SE +/- 110.78, N = 3 SE +/- 809.91, N = 5 SE +/- 8949.19, N = 6 SE +/- 649.05, N = 3 SE +/- 9312.69, N = 6 SE +/- 481.02, N = 3 SE +/- 437.40, N = 3 SE +/- 270.78, N = 3 SE +/- 551.80, N = 3 SE +/- 3786.54, N = 6 SE +/- 2198.62, N = 6 SE +/- 2045.70, N = 6 SE +/- 857.52, N = 3 SE +/- 642.23, N = 3 SE +/- 667.86, N = 3 SE +/- 1544.48, N = 6 SE +/- 864.58, N = 6 SE +/- 837.83, N = 3 SE +/- 2735.87, N = 6 84719.68 57826.54 23133.34 59553.10 58144.94 57898.56 15179.52 57647.39 44878.87 58564.96 58360.52 58727.96 57059.61 51754.71 55695.46 55526.16 57908.50 58442.00 58797.71 59083.32 59677.98 58106.86 53077.35 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_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,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 20K 40K 60K 80K 100K SE +/- 370.23, N = 3 SE +/- 1261.90, N = 6 SE +/- 2141.87, N = 6 SE +/- 2975.06, N = 6 SE +/- 2219.46, N = 6 SE +/- 1328.76, N = 6 SE +/- 1102.28, N = 3 SE +/- 936.58, N = 3 SE +/- 1340.56, N = 6 SE +/- 2992.06, N = 6 SE +/- 2400.87, N = 6 SE +/- 182.09, N = 3 SE +/- 2095.61, N = 6 SE +/- 1633.90, N = 6 SE +/- 3267.18, N = 6 SE +/- 1765.40, N = 6 SE +/- 2037.87, N = 6 SE +/- 801.99, N = 3 SE +/- 2324.68, N = 6 SE +/- 1000.79, N = 6 SE +/- 1538.63, N = 6 SE +/- 1827.25, N = 6 SE +/- 1988.91, N = 6 86173.55 65558.26 64625.50 62967.07 60061.36 61354.61 61428.74 63223.74 59583.66 61830.83 60508.18 64438.64 61400.30 60854.15 64219.48 60428.81 60263.15 62560.36 62527.74 61212.91 59413.91 59202.29 62553.53 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 2017-06-28 19:59 bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow 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,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 500 1000 1500 2000 2500 SE +/- 18.25, N = 3 SE +/- 33.46, N = 6 SE +/- 82.09, N = 6 SE +/- 35.67, N = 6 SE +/- 133.61, N = 6 SE +/- 76.23, N = 6 SE +/- 16.00, N = 6 SE +/- 62.62, N = 6 SE +/- 76.71, N = 6 SE +/- 84.37, N = 6 SE +/- 62.15, N = 6 SE +/- 34.35, N = 6 SE +/- 141.45, N = 6 SE +/- 33.06, N = 3 SE +/- 139.20, N = 6 SE +/- 12.71, N = 3 SE +/- 44.27, N = 6 SE +/- 39.45, N = 6 SE +/- 134.32, N = 6 SE +/- 40.99, N = 6 SE +/- 226.19, N = 6 SE +/- 4.98, N = 3 SE +/- 154.00, N = 6 928.77 903.65 695.35 1141.40 1309.77 398.44 211.12 1347.57 340.92 1496.92 732.77 1162.39 1795.59 1880.67 2128.23 1753.10 666.53 881.87 2317.44 1004.38 1022.22 321.34 2205.65 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 2017-06-28 19:59 bcache io_default btrfs compress=lzo bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow 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,notreelog bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum bcache io_default btrfs defaults bcache io_default ext4 data=writeback,noatime,barrier=0,discard bcache io_default ext4 defaults bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum lvm io_default btrfs defaults lvm io_default ext4 data=writeback,noatime,barrier=0,discard lvm io_default ext4 defaults lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum 1200 2400 3600 4800 6000 SE +/- 14.69, N = 6 SE +/- 8.43, N = 6 SE +/- 36.75, N = 6 SE +/- 4.26, N = 3 SE +/- 16.21, N = 3 SE +/- 19.58, N = 6 SE +/- 11.43, N = 6 SE +/- 15.94, N = 3 SE +/- 16.83, N = 6 SE +/- 52.78, N = 3 SE +/- 199.68, N = 6 SE +/- 10.09, N = 3 SE +/- 27.90, N = 6 SE +/- 19.50, N = 3 SE +/- 30.07, N = 6 SE +/- 55.48, N = 6 SE +/- 9.21, N = 6 SE +/- 7.49, N = 6 SE +/- 46.96, N = 6 SE +/- 24.37, N = 6 SE +/- 119.98, N = 6 SE +/- 16.11, N = 6 SE +/- 53.22, N = 6 657.03 436.64 870.25 902.53 887.78 117.67 100.28 799.38 391.66 3689.62 651.34 798.86 554.24 1068.65 855.59 906.72 190.06 225.00 933.81 428.94 5579.31 272.22 897.73 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
Phoronix Test Suite v10.8.4