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