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