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