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&grr&sor&rro.

pgall_1ProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDisplay ServerDisplay DriverCompilerFile-SystemScreen Resolutionlvm io_default btrfs defaultsbcache io_default btrfs defaultslvm io_default btrfs compress=lzobcache io_default btrfs compress=lzolvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default ext4 defaultsbcache io_default ext4 defaultslvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 data=writeback,noatime,barrier=0,discard1. xl03 lzo 64Intel Core i5-4590 @ 3.70GHz (4 Cores)MSI Z97-G43 (MS-7816) v3.0Intel 4th Gen Core DRAM2048MB2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550Intel HD 4600 (1150MHz)Intel Xeon E3-1200 v3/4thRealtek RTL8111/8168/8411Ubuntu 16.044.4.0-21-generic (x86_64)X Server 1.18.3intel 2.99.917GCC 5.4.0 20160609overlayfs2560x1440Intel Core i7-4770 @ 3.90GHz (8 Cores)MSI H87-G43 (MS-7816) v1.032768MB2 x 240GB INTEL SSDSC2CW24 + 2 x 2000GB Western Digital WD2000FYYZ-0Intel Xeon E3-1200 v3/4th Gen Core IGPDebian 8.84.9.0-0.bpo.3-amd64 (x86_64)GCC 4.9.2btrfsOpenBenchmarking.orgCompiler 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 -vProcessor Details- Scaling Governor: intel_pstate powersave

pgall_1pgbench: Buffer Test - Heavy Contention - Read Writepgbench: Mostly RAM - Heavy Contention - Read Writepgbench: Buffer Test - Heavy Contention - Read Onlypgbench: Mostly RAM - Heavy Contention - Read Onlypgbench: Buffer Test - Single Thread - Read Writepgbench: On-Disk - Heavy Contention - Read Writepgbench: Mostly RAM - Single Thread - Read Writepgbench: Buffer Test - Single Thread - Read Onlypgbench: On-Disk - Heavy Contention - Read Onlypgbench: Mostly RAM - Single Thread - Read Onlypgbench: Buffer Test - Normal Load - Read Writepgbench: Mostly RAM - Normal Load - Read Writepgbench: Buffer Test - Normal Load - Read Onlypgbench: On-Disk - Single Thread - Read Writepgbench: Mostly RAM - Normal Load - Read Onlypgbench: On-Disk - Single Thread - Read Onlypgbench: On-Disk - Normal Load - Read Writepgbench: On-Disk - Normal Load - Read Onlylvm io_default btrfs defaultsbcache io_default btrfs defaultslvm io_default btrfs compress=lzobcache io_default btrfs compress=lzolvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default ext4 defaultsbcache io_default ext4 defaultslvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 data=writeback,noatime,barrier=0,discard1. xl03 lzo 64428.941004.3861212.9159083.32125.32682.19115.2423914.4522864.9220997.67300.23552.1076977.4674.9668288.462544.95320.2320162.02391.66340.9259583.6644878.87126.84195.49111.4724192.07441.9420979.40376.19464.0077598.5421.6568972.7277.5494.05316.91554.241795.5961400.3057059.61171.731082.41171.7423859.9610505.6121043.97477.56936.2577873.82116.5268533.551619.90645.958279.07436.64903.6565558.2657826.54143.84217.77117.5324127.63552.7121371.39391.39504.9878646.5523.0169187.9189.22106.26394.99855.592128.2364219.4855695.46288.411341.64264.8123829.4010887.1121176.86744.761478.5876681.77198.9468515.651663.56861.658415.20902.531141.4062967.0759553.10285.55258.12225.6424229.96626.1521345.45769.99948.1479555.7866.3568750.9290.60179.22480.80897.732205.6562553.5353077.35288.421308.29262.6423658.498136.9721042.27691.831420.2779021.37197.8668348.051844.51881.309352.71798.861162.3964438.6458727.96269.88293.57209.5724208.31776.1221445.74714.72844.8578960.6863.4369027.3783.68149.00481.75906.721753.1060428.8155526.16278.43625.31248.2623747.128935.0220829.28704.481182.2578117.39180.5268431.891696.50496.868222.94887.781309.7760061.3658144.94289.34239.40215.3023874.24861.7421525.05793.59786.3279764.8061.8069221.9795.75150.23601.40933.812317.4462527.7458797.71311.661551.38263.0723699.766063.6020951.10825.141407.8678498.80225.9368419.471421.211043.576346.92799.381347.5763223.7457647.39270.11467.98201.7824073.672916.7021489.61756.62800.0579011.9689.2168988.32150.95203.951097.821068.651880.6760854.1551754.71367.211222.51361.2223997.2521463.9120879.32870.781367.9276449.10261.8168721.782629.90796.3619742.34870.25695.3564625.5023133.34285.92197.12214.4924067.91472.3220863.27802.34722.4077521.6063.3768898.6477.50137.41350.11190.06666.5360263.1557908.5065.83447.3466.4923978.778135.8121208.74157.50363.9078414.4329.8068475.701716.87152.557723.21117.67398.4461354.6157898.5630.02180.5039.3823938.98652.2121151.7596.84156.1777603.4022.1368431.94100.9778.00495.15225.00881.8762560.3658442.0077.73790.2966.8223904.5821537.0121093.49201.42402.5176558.8143.2168665.062623.91277.4320477.31100.28211.1261428.7415179.5232.78164.7346.6124092.47470.7321279.2865.85198.9278959.4029.1568605.1678.5179.88347.49272.22321.3459202.2958106.86122.84180.52135.0423964.56417.5821556.72245.41279.1378829.9820.9968904.8415.3956.8713809.96651.34732.7760508.1858360.52302.40196.92251.3824118.29418.6821432.19882.97686.3277237.6323.2869132.3673.9494.41331.005579.311022.2259413.9159677.982252.17212.19459.2624119.68387.2021474.247796.79771.7378665.0644.9069098.0729.10101.278274.223689.621496.9261830.8358564.962160.69304.93951.9624302.63433.3421550.264460.021618.3578362.2670.3668705.2174.03280.53332.38OpenBenchmarking.org

PostgreSQL pgbench

Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Writebcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default ext4 defaultsbcache io_default btrfs defaultslvm io_default btrfs defaultsbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default ext4 defaultsbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discard12002400360048006000SE +/- 11.43, N = 6SE +/- 19.58, N = 6SE +/- 9.21, N = 6SE +/- 7.49, N = 6SE +/- 16.11, N = 6SE +/- 16.83, N = 6SE +/- 24.37, N = 6SE +/- 8.43, N = 6SE +/- 27.90, N = 6SE +/- 199.68, N = 6SE +/- 10.09, N = 3SE +/- 15.94, N = 3SE +/- 30.07, N = 6SE +/- 36.75, N = 6SE +/- 16.21, N = 3SE +/- 53.22, N = 6SE +/- 4.26, N = 3SE +/- 55.48, N = 6SE +/- 46.96, N = 6SE +/- 19.50, N = 3SE +/- 52.78, N = 3SE +/- 119.98, N = 6100.28117.67190.06225.00272.22391.66428.94436.64554.24651.34798.86799.38855.59870.25887.78897.73902.53906.72933.811068.653689.625579.311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Writebcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default ext4 defaultsbcache io_default btrfs defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default ext4 defaultslvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzolvm io_default btrfs defaultslvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzolvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum5001000150020002500SE +/- 16.00, N = 6SE +/- 4.98, N = 3SE +/- 76.71, N = 6SE +/- 76.23, N = 6SE +/- 44.27, N = 6SE +/- 82.09, N = 6SE +/- 62.15, N = 6SE +/- 39.45, N = 6SE +/- 33.46, N = 6SE +/- 40.99, N = 6SE +/- 226.19, N = 6SE +/- 35.67, N = 6SE +/- 34.35, N = 6SE +/- 133.61, N = 6SE +/- 62.62, N = 6SE +/- 84.37, N = 6SE +/- 12.71, N = 3SE +/- 141.45, N = 6SE +/- 33.06, N = 3SE +/- 139.20, N = 6SE +/- 154.00, N = 6SE +/- 134.32, N = 6211.12321.34340.92398.44666.53695.35732.77881.87903.651004.381022.221141.401162.391309.771347.571496.921753.101795.591880.672128.232205.652317.441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

PostgreSQL pgbench

Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Onlylvm io_default ext4 defaultslvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default btrfs defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default ext4 defaultslvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzobcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=lzo14K28K42K56K70KSE +/- 1827.25, N = 6SE +/- 1538.63, N = 6SE +/- 1340.56, N = 6SE +/- 2219.46, N = 6SE +/- 2037.87, N = 6SE +/- 1765.40, N = 6SE +/- 2400.87, N = 6SE +/- 1633.90, N = 6SE +/- 1000.79, N = 6SE +/- 1328.76, N = 6SE +/- 2095.61, N = 6SE +/- 1102.28, N = 3SE +/- 2992.06, N = 6SE +/- 2324.68, N = 6SE +/- 1988.91, N = 6SE +/- 801.99, N = 3SE +/- 2975.06, N = 6SE +/- 936.58, N = 3SE +/- 3267.18, N = 6SE +/- 182.09, N = 3SE +/- 2141.87, N = 6SE +/- 1261.90, N = 659202.2959413.9159583.6660061.3660263.1560428.8160508.1860854.1561212.9161354.6161400.3061428.7461830.8362527.7462553.5362560.3662967.0763223.7464219.4864438.6464625.5065558.261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Onlybcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs defaultslvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzobcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzobcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default ext4 defaultslvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default ext4 data=writeback,noatime,barrier=0,discard13K26K39K52K65KSE +/- 8949.19, N = 6SE +/- 10271.50, N = 6SE +/- 9312.69, N = 6SE +/- 3786.54, N = 6SE +/- 2735.87, N = 6SE +/- 2045.70, N = 6SE +/- 2198.62, N = 6SE +/- 551.80, N = 3SE +/- 649.05, N = 3SE +/- 346.98, N = 3SE +/- 809.91, N = 5SE +/- 857.52, N = 3SE +/- 837.83, N = 3SE +/- 110.78, N = 3SE +/- 437.40, N = 3SE +/- 642.23, N = 3SE +/- 481.02, N = 3SE +/- 270.78, N = 3SE +/- 667.86, N = 3SE +/- 1544.48, N = 6SE +/- 873.00, N = 3SE +/- 864.58, N = 615179.5223133.3444878.8751754.7153077.3555526.1655695.4657059.6157647.3957826.5457898.5657908.5058106.8658144.9458360.5258442.0058564.9658727.9658797.7159083.3259553.1059677.981. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

PostgreSQL pgbench

Scaling: Buffer Test - Test: Single Thread - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Buffer Test - Test: Single Thread - Mode: Read Writebcache io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default ext4 defaultslvm io_default btrfs defaultsbcache io_default btrfs defaultsbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default ext4 defaultslvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discard5001000150020002500SE +/- 5.68, N = 6SE +/- 0.79, N = 6SE +/- 5.54, N = 6SE +/- 2.64, N = 6SE +/- 14.33, N = 6SE +/- 13.46, N = 6SE +/- 7.51, N = 6SE +/- 1.88, N = 3SE +/- 12.53, N = 6SE +/- 6.98, N = 6SE +/- 2.34, N = 3SE +/- 16.30, N = 6SE +/- 6.18, N = 6SE +/- 16.31, N = 6SE +/- 19.53, N = 6SE +/- 17.15, N = 6SE +/- 4.28, N = 5SE +/- 20.62, N = 6SE +/- 21.76, N = 6SE +/- 15.29, N = 6SE +/- 21.40, N = 3SE +/- 45.26, N = 630.0232.7865.8377.73122.84125.32126.84143.84171.73269.88270.11278.43285.55285.92288.41288.42289.34302.40311.66367.212160.692252.171. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

PostgreSQL pgbench

Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read Writebcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default ext4 defaultsbcache io_default btrfs defaultsbcache io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default btrfs compress=lzobcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs defaultslvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzolvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum30060090012001500SE +/- 2.39, N = 6SE +/- 9.63, N = 6SE +/- 3.05, N = 6SE +/- 4.87, N = 6SE +/- 1.70, N = 3SE +/- 3.80, N = 3SE +/- 15.51, N = 6SE +/- 3.18, N = 6SE +/- 7.39, N = 6SE +/- 2.65, N = 3SE +/- 8.88, N = 6SE +/- 8.49, N = 6SE +/- 14.04, N = 6SE +/- 20.82, N = 6SE +/- 76.70, N = 6SE +/- 18.32, N = 6SE +/- 26.75, N = 6SE +/- 26.99, N = 6SE +/- 39.30, N = 6SE +/- 23.73, N = 6SE +/- 12.19, N = 3SE +/- 44.00, N = 6164.73180.50180.52195.49196.92197.12212.19217.77239.40258.12293.57304.93447.34467.98625.31682.19790.291082.411222.511308.291341.641551.381. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Mostly RAM - Test: Single Thread - Mode: Read Writebcache io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs defaultslvm io_default btrfs defaultsbcache io_default btrfs compress=lzolvm io_default ext4 defaultslvm io_default btrfs compress=lzobcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default ext4 defaultslvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 data=writeback,noatime,barrier=0,discard2004006008001000SE +/- 4.92, N = 6SE +/- 4.44, N = 6SE +/- 2.70, N = 6SE +/- 1.48, N = 6SE +/- 5.67, N = 6SE +/- 4.33, N = 6SE +/- 2.21, N = 3SE +/- 4.92, N = 6SE +/- 13.52, N = 6SE +/- 1.70, N = 3SE +/- 10.57, N = 6SE +/- 3.71, N = 3SE +/- 7.35, N = 6SE +/- 18.02, N = 6SE +/- 13.36, N = 6SE +/- 23.43, N = 6SE +/- 18.41, N = 6SE +/- 17.47, N = 6SE +/- 18.66, N = 6SE +/- 6.33, N = 6SE +/- 12.77, N = 6SE +/- 46.58, N = 639.3846.6166.4966.82111.47115.24117.53135.04171.74201.78209.57214.49215.30225.64248.26251.38262.64263.07264.81361.22459.26951.961. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

PostgreSQL pgbench

Scaling: Buffer Test - Test: Single Thread - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Buffer Test - Test: Single Thread - Mode: Read Onlylvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzobcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default ext4 defaultslvm io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default ext4 defaultslvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default btrfs compress=lzobcache io_default btrfs defaultsbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default ext4 data=writeback,noatime,barrier=0,discard5K10K15K20K25KSE +/- 50.83, N = 3SE +/- 199.54, N = 3SE +/- 103.07, N = 3SE +/- 75.78, N = 3SE +/- 109.36, N = 3SE +/- 87.86, N = 3SE +/- 232.89, N = 3SE +/- 123.84, N = 3SE +/- 230.73, N = 3SE +/- 134.13, N = 3SE +/- 202.42, N = 3SE +/- 124.91, N = 3SE +/- 218.76, N = 3SE +/- 62.77, N = 3SE +/- 48.70, N = 3SE +/- 150.24, N = 3SE +/- 171.49, N = 3SE +/- 192.02, N = 3SE +/- 73.18, N = 3SE +/- 82.65, N = 3SE +/- 77.34, N = 3SE +/- 44.16, N = 323658.4923699.7623747.1223829.4023859.9623874.2423904.5823914.4523938.9823964.5623978.7723997.2524067.9124073.6724092.4724118.2924119.6824127.6324192.0724208.3124229.9624302.631. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

PostgreSQL pgbench

Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read Onlylvm io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 defaultsbcache io_default ext4 defaultsbcache io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default btrfs defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=lzobcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzolvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs defaults5K10K15K20K25KSE +/- 13.34, N = 6SE +/- 1.37, N = 3SE +/- 2.52, N = 3SE +/- 5.46, N = 3SE +/- 9.05, N = 6SE +/- 8.27, N = 6SE +/- 8.79, N = 6SE +/- 16.69, N = 6SE +/- 53.20, N = 6SE +/- 39.35, N = 6SE +/- 34.55, N = 6SE +/- 178.69, N = 6SE +/- 240.27, N = 6SE +/- 73.98, N = 3SE +/- 3.48, N = 3SE +/- 4.58, N = 3SE +/- 544.19, N = 6SE +/- 941.62, N = 6SE +/- 913.62, N = 6SE +/- 771.87, N = 6SE +/- 744.48, N = 6SE +/- 384.86, N = 3387.20417.58418.68433.34441.94470.73472.32552.71626.15652.21776.12861.742916.706063.608135.818136.978935.0210505.6110887.1121463.9121537.0122864.921. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Mostly RAM - Test: Single Thread - Mode: Read Onlylvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs defaultslvm io_default btrfs defaultslvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzolvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzobcache io_default ext4 defaultsbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 defaults5K10K15K20K25KSE +/- 137.69, N = 3SE +/- 319.38, N = 3SE +/- 247.98, N = 3SE +/- 35.40, N = 3SE +/- 378.36, N = 3SE +/- 83.52, N = 3SE +/- 148.23, N = 3SE +/- 145.21, N = 3SE +/- 27.25, N = 3SE +/- 301.89, N = 3SE +/- 122.72, N = 3SE +/- 107.38, N = 3SE +/- 163.79, N = 3SE +/- 116.08, N = 3SE +/- 57.96, N = 3SE +/- 107.00, N = 3SE +/- 39.10, N = 3SE +/- 162.74, N = 3SE +/- 45.25, N = 3SE +/- 42.19, N = 3SE +/- 63.85, N = 3SE +/- 79.14, N = 320829.2820863.2720879.3220951.1020979.4020997.6721042.2721043.9721093.4921151.7521176.8621208.7421279.2821345.4521371.3921432.1921445.7421474.2421489.6121525.0521550.2621556.721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

PostgreSQL pgbench

Scaling: Buffer Test - Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Buffer Test - Test: Normal Load - Mode: Read Writebcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default ext4 defaultslvm io_default btrfs defaultsbcache io_default btrfs defaultsbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzolvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default ext4 defaultsbcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discard2K4K6K8K10KSE +/- 3.16, N = 6SE +/- 16.88, N = 6SE +/- 4.80, N = 6SE +/- 4.33, N = 6SE +/- 6.82, N = 6SE +/- 14.99, N = 6SE +/- 20.76, N = 6SE +/- 8.78, N = 6SE +/- 32.26, N = 6SE +/- 29.69, N = 6SE +/- 26.15, N = 6SE +/- 17.28, N = 6SE +/- 31.47, N = 6SE +/- 9.68, N = 3SE +/- 7.66, N = 3SE +/- 10.59, N = 3SE +/- 24.40, N = 6SE +/- 49.09, N = 6SE +/- 36.07, N = 6SE +/- 4.71, N = 3SE +/- 73.28, N = 6SE +/- 38.39, N = 365.8596.84157.50201.42245.41300.23376.19391.39477.56691.83704.48714.72744.76756.62769.99793.59802.34825.14870.78882.974460.027796.791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read Writebcache io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default ext4 defaultslvm io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs defaultsbcache io_default btrfs compress=lzolvm io_default btrfs defaultsbcache io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzobcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default ext4 data=writeback,noatime,barrier=0,discard30060090012001500SE +/- 20.18, N = 6SE +/- 6.54, N = 6SE +/- 4.76, N = 4SE +/- 16.96, N = 6SE +/- 2.10, N = 3SE +/- 27.77, N = 6SE +/- 8.44, N = 3SE +/- 13.93, N = 6SE +/- 22.10, N = 6SE +/- 7.08, N = 3SE +/- 21.57, N = 6SE +/- 24.13, N = 6SE +/- 28.49, N = 6SE +/- 31.95, N = 6SE +/- 69.74, N = 6SE +/- 9.78, N = 3SE +/- 64.39, N = 6SE +/- 54.49, N = 6SE +/- 85.87, N = 6SE +/- 106.65, N = 6SE +/- 82.85, N = 6SE +/- 52.12, N = 6156.17198.92279.13363.90402.51464.00504.98552.10686.32722.40771.73786.32800.05844.85936.25948.141182.251367.921407.861420.271478.581618.351. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

PostgreSQL pgbench

Scaling: Buffer Test - Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Buffer Test - Test: Normal Load - Mode: Read Onlylvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs defaultsbcache io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzolvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag20K40K60K80K100KSE +/- 664.13, N = 3SE +/- 678.12, N = 3SE +/- 600.35, N = 3SE +/- 908.41, N = 3SE +/- 212.90, N = 3SE +/- 658.62, N = 3SE +/- 892.84, N = 3SE +/- 263.15, N = 3SE +/- 163.90, N = 3SE +/- 677.98, N = 3SE +/- 1401.16, N = 3SE +/- 842.39, N = 3SE +/- 537.93, N = 3SE +/- 359.72, N = 3SE +/- 903.09, N = 3SE +/- 344.69, N = 3SE +/- 864.73, N = 3SE +/- 414.51, N = 3SE +/- 1161.11, N = 3SE +/- 1146.43, N = 3SE +/- 360.56, N = 3SE +/- 1420.32, N = 376449.1076558.8176681.7776977.4677237.6377521.6077598.5477603.4077873.8278117.3978362.2678414.4378498.8078646.5578665.0678829.9878959.4078960.6879011.9679021.3779555.7879764.801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

PostgreSQL pgbench

Scaling: On-Disk - Test: Single Thread - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: On-Disk - Test: Single Thread - Mode: Read Writelvm io_default ext4 defaultsbcache io_default btrfs defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzobcache io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default btrfs defaultsbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzolvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow60120180240300SE +/- 1.95, N = 6SE +/- 0.39, N = 3SE +/- 5.21, N = 6SE +/- 0.36, N = 6SE +/- 0.61, N = 6SE +/- 0.69, N = 6SE +/- 0.25, N = 3SE +/- 0.51, N = 3SE +/- 0.82, N = 3SE +/- 2.78, N = 6SE +/- 0.30, N = 3SE +/- 2.59, N = 6SE +/- 0.99, N = 3SE +/- 0.56, N = 3SE +/- 1.53, N = 6SE +/- 4.69, N = 6SE +/- 2.12, N = 6SE +/- 4.14, N = 6SE +/- 3.06, N = 4SE +/- 3.05, N = 3SE +/- 4.68, N = 6SE +/- 2.10, N = 320.9921.6522.1323.0123.2829.1529.8043.2144.9061.8063.3763.4366.3570.3674.9689.21116.52180.52197.86198.94225.93261.811. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read Onlylvm io_default btrfs defaultslvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzobcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default ext4 defaultsbcache io_default btrfs defaultsbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultsbcache io_default btrfs compress=lzobcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag15K30K45K60K75KSE +/- 239.47, N = 3SE +/- 98.15, N = 3SE +/- 234.84, N = 3SE +/- 95.42, N = 3SE +/- 173.34, N = 3SE +/- 367.20, N = 3SE +/- 273.67, N = 3SE +/- 340.40, N = 3SE +/- 353.33, N = 3SE +/- 354.48, N = 3SE +/- 458.70, N = 3SE +/- 181.55, N = 3SE +/- 271.25, N = 3SE +/- 241.90, N = 3SE +/- 187.63, N = 3SE +/- 278.01, N = 3SE +/- 285.51, N = 3SE +/- 160.58, N = 3SE +/- 224.24, N = 3SE +/- 265.65, N = 3SE +/- 88.81, N = 3SE +/- 196.73, N = 368288.4668348.0568419.4768431.8968431.9468475.7068515.6568533.5568605.1668665.0668705.2168721.7868750.9268898.6468904.8468972.7268988.3269027.3769098.0769132.3669187.9169221.971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

PostgreSQL pgbench

Scaling: On-Disk - Test: Single Thread - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: On-Disk - Test: Single Thread - Mode: Read Onlylvm io_default ext4 defaultslvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultsbcache io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzobcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzolvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs defaultslvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow6001200180024003000SE +/- 0.11, N = 3SE +/- 3.90, N = 6SE +/- 0.23, N = 3SE +/- 0.45, N = 3SE +/- 1.40, N = 6SE +/- 1.20, N = 4SE +/- 1.76, N = 6SE +/- 2.69, N = 6SE +/- 2.20, N = 6SE +/- 2.89, N = 6SE +/- 4.32, N = 6SE +/- 8.94, N = 6SE +/- 19.35, N = 6SE +/- 19.47, N = 3SE +/- 38.51, N = 6SE +/- 34.84, N = 6SE +/- 42.66, N = 6SE +/- 47.87, N = 6SE +/- 68.16, N = 6SE +/- 6.32, N = 3SE +/- 43.84, N = 6SE +/- 40.76, N = 515.3929.1073.9474.0377.5077.5478.5183.6889.2290.6095.75100.97150.951421.211619.901663.561696.501716.871844.512544.952623.912629.901. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

PostgreSQL pgbench

Scaling: On-Disk - Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: On-Disk - Test: Normal Load - Mode: Read Writelvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs defaultsbcache io_default ext4 defaultslvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default btrfs compress=lzobcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default btrfs defaultslvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzolvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum2004006008001000SE +/- 1.11, N = 6SE +/- 2.00, N = 6SE +/- 2.92, N = 6SE +/- 2.02, N = 6SE +/- 1.50, N = 3SE +/- 2.77, N = 6SE +/- 3.38, N = 6SE +/- 3.01, N = 6SE +/- 10.96, N = 6SE +/- 8.89, N = 6SE +/- 11.00, N = 6SE +/- 5.25, N = 6SE +/- 11.59, N = 6SE +/- 37.54, N = 6SE +/- 13.00, N = 6SE +/- 16.22, N = 6SE +/- 29.22, N = 6SE +/- 23.29, N = 6SE +/- 17.70, N = 6SE +/- 24.49, N = 6SE +/- 13.43, N = 6SE +/- 42.21, N = 656.8778.0079.8894.0594.41101.27106.26137.41149.00150.23152.55179.22203.95277.43280.53320.23496.86645.95796.36861.65881.301043.571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

PostgreSQL pgbench

Scaling: On-Disk - Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: On-Disk - Test: Normal Load - Mode: Read Onlybcache io_default btrfs defaultsbcache io_default ext4 defaultsbcache io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=lzobcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default btrfs compress=lzolvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default ext4 defaultslvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs defaultslvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow4K8K12K16K20KSE +/- 18.63, N = 6SE +/- 5.31, N = 4SE +/- 4.48, N = 6SE +/- 5.89, N = 4SE +/- 5.56, N = 6SE +/- 5.78, N = 6SE +/- 22.29, N = 6SE +/- 20.75, N = 6SE +/- 27.91, N = 6SE +/- 78.88, N = 6SE +/- 253.91, N = 6SE +/- 273.32, N = 6SE +/- 17.78, N = 3SE +/- 354.20, N = 6SE +/- 2552.91, N = 6SE +/- 517.42, N = 6SE +/- 641.31, N = 6SE +/- 991.78, N = 6SE +/- 4325.01, N = 6SE +/- 304.64, N = 4SE +/- 136.42, N = 3SE +/- 281.41, N = 5316.91331.00332.38347.49350.11394.99480.80481.75495.15601.401097.826346.927723.218222.948274.228279.078415.209352.7113809.9619742.3420162.0220477.311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

Phoronix Test Suite v10.8.5