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&grr&rdt .
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: Buffer Test - Heavy Contention - Read Write pgbench: Mostly RAM - Heavy Contention - Read Write pgbench: Buffer Test - Heavy Contention - Read Only pgbench: Mostly RAM - Heavy Contention - Read Only pgbench: Buffer Test - Single Thread - Read Write pgbench: On-Disk - Heavy Contention - Read Write pgbench: Mostly RAM - Single Thread - Read Write pgbench: Buffer Test - Single Thread - Read Only pgbench: On-Disk - Heavy Contention - Read Only pgbench: Mostly RAM - Single Thread - Read Only pgbench: Buffer Test - Normal Load - Read Write pgbench: Mostly RAM - Normal Load - Read Write pgbench: Buffer Test - Normal Load - Read Only pgbench: On-Disk - Single Thread - Read Write pgbench: Mostly RAM - Normal Load - Read Only pgbench: On-Disk - Single Thread - Read Only pgbench: On-Disk - Normal Load - Read Write pgbench: On-Disk - Normal Load - Read Only 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 428.94 1004.38 61212.91 59083.32 125.32 682.19 115.24 23914.45 22864.92 20997.67 300.23 552.10 76977.46 74.96 68288.46 2544.95 320.23 20162.02 391.66 340.92 59583.66 44878.87 126.84 195.49 111.47 24192.07 441.94 20979.40 376.19 464.00 77598.54 21.65 68972.72 77.54 94.05 316.91 554.24 1795.59 61400.30 57059.61 171.73 1082.41 171.74 23859.96 10505.61 21043.97 477.56 936.25 77873.82 116.52 68533.55 1619.90 645.95 8279.07 436.64 903.65 65558.26 57826.54 143.84 217.77 117.53 24127.63 552.71 21371.39 391.39 504.98 78646.55 23.01 69187.91 89.22 106.26 394.99 855.59 2128.23 64219.48 55695.46 288.41 1341.64 264.81 23829.40 10887.11 21176.86 744.76 1478.58 76681.77 198.94 68515.65 1663.56 861.65 8415.20 902.53 1141.40 62967.07 59553.10 285.55 258.12 225.64 24229.96 626.15 21345.45 769.99 948.14 79555.78 66.35 68750.92 90.60 179.22 480.80 897.73 2205.65 62553.53 53077.35 288.42 1308.29 262.64 23658.49 8136.97 21042.27 691.83 1420.27 79021.37 197.86 68348.05 1844.51 881.30 9352.71 798.86 1162.39 64438.64 58727.96 269.88 293.57 209.57 24208.31 776.12 21445.74 714.72 844.85 78960.68 63.43 69027.37 83.68 149.00 481.75 906.72 1753.10 60428.81 55526.16 278.43 625.31 248.26 23747.12 8935.02 20829.28 704.48 1182.25 78117.39 180.52 68431.89 1696.50 496.86 8222.94 887.78 1309.77 60061.36 58144.94 289.34 239.40 215.30 23874.24 861.74 21525.05 793.59 786.32 79764.80 61.80 69221.97 95.75 150.23 601.40 933.81 2317.44 62527.74 58797.71 311.66 1551.38 263.07 23699.76 6063.60 20951.10 825.14 1407.86 78498.80 225.93 68419.47 1421.21 1043.57 6346.92 799.38 1347.57 63223.74 57647.39 270.11 467.98 201.78 24073.67 2916.70 21489.61 756.62 800.05 79011.96 89.21 68988.32 150.95 203.95 1097.82 1068.65 1880.67 60854.15 51754.71 367.21 1222.51 361.22 23997.25 21463.91 20879.32 870.78 1367.92 76449.10 261.81 68721.78 2629.90 796.36 19742.34 870.25 695.35 64625.50 23133.34 285.92 197.12 214.49 24067.91 472.32 20863.27 802.34 722.40 77521.60 63.37 68898.64 77.50 137.41 350.11 190.06 666.53 60263.15 57908.50 65.83 447.34 66.49 23978.77 8135.81 21208.74 157.50 363.90 78414.43 29.80 68475.70 1716.87 152.55 7723.21 117.67 398.44 61354.61 57898.56 30.02 180.50 39.38 23938.98 652.21 21151.75 96.84 156.17 77603.40 22.13 68431.94 100.97 78.00 495.15 225.00 881.87 62560.36 58442.00 77.73 790.29 66.82 23904.58 21537.01 21093.49 201.42 402.51 76558.81 43.21 68665.06 2623.91 277.43 20477.31 100.28 211.12 61428.74 15179.52 32.78 164.73 46.61 24092.47 470.73 21279.28 65.85 198.92 78959.40 29.15 68605.16 78.51 79.88 347.49 272.22 321.34 59202.29 58106.86 122.84 180.52 135.04 23964.56 417.58 21556.72 245.41 279.13 78829.98 20.99 68904.84 15.39 56.87 13809.96 651.34 732.77 60508.18 58360.52 302.40 196.92 251.38 24118.29 418.68 21432.19 882.97 686.32 77237.63 23.28 69132.36 73.94 94.41 331.00 5579.31 1022.22 59413.91 59677.98 2252.17 212.19 459.26 24119.68 387.20 21474.24 7796.79 771.73 78665.06 44.90 69098.07 29.10 101.27 8274.22 3689.62 1496.92 61830.83 58564.96 2160.69 304.93 951.96 24302.63 433.34 21550.26 4460.02 1618.35 78362.26 70.36 68705.21 74.03 280.53 332.38 657.03 928.77 86173.55 84719.68 33.00 495.86 35.82 22705.40 8236.50 22456.10 328.59 445.39 93604.64 31.15 93307.23 191.60 167.13 989.50 OpenBenchmarking.org
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 +/- 14.69, 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 657.03 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 +/- 18.25, N = 3 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 928.77 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 +/- 370.23, 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 86173.55 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 +/- 1222.64, N = 6 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 84719.68 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 +/- 1.35, 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 33.00 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 +/- 24.03, 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 495.86 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 +/- 1.15, 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 35.82 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 +/- 148.03, 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 22705.40 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 +/- 1182.96, 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 8236.50 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 +/- 120.51, 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 22456.10 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 +/- 25.19, 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 328.59 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 +/- 26.61, 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 445.39 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 +/- 168.43, 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 93604.64 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.39, 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 31.15 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 +/- 241.83, 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 93307.23 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 +/- 1.98, N = 3 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 191.60 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 +/- 13.02, 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 167.13 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
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 +/- 115.77, 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 989.50 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic
Phoronix Test Suite v10.8.4