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/1706299-ASVA-170624661&grs.

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,discard2017-06-28 19:59Intel 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 SSDSC2BW24 + 2 x 2000GB HGST HUS724020ALIntel 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- 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 -vProcessor Details- Scaling Governor: intel_pstate powersave

pgall_1pgbench: Mostly RAM - Normal Load - Read Onlypgbench: Buffer Test - Normal Load - Read Onlypgbench: Mostly RAM - Single Thread - Read Onlypgbench: Buffer Test - Single Thread - Read Onlypgbench: 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: On-Disk - Heavy Contention - Read Onlypgbench: Buffer Test - Normal Load - Read Writepgbench: Mostly RAM - Normal Load - Read Writepgbench: On-Disk - Single Thread - Read Writepgbench: 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,discard2017-06-28 19:5968288.4676977.4620997.6723914.45428.941004.3861212.9159083.32125.32682.19115.2422864.92300.23552.1074.962544.95320.2320162.0268972.7277598.5420979.4024192.07391.66340.9259583.6644878.87126.84195.49111.47441.94376.19464.0021.6577.5494.05316.9168533.5577873.8221043.9723859.96554.241795.5961400.3057059.61171.731082.41171.7410505.61477.56936.25116.521619.90645.958279.0769187.9178646.5521371.3924127.63436.64903.6565558.2657826.54143.84217.77117.53552.71391.39504.9823.0189.22106.26394.9968515.6576681.7721176.8623829.40855.592128.2364219.4855695.46288.411341.64264.8110887.11744.761478.58198.941663.56861.658415.2068750.9279555.7821345.4524229.96902.531141.4062967.0759553.10285.55258.12225.64626.15769.99948.1466.3590.60179.22480.8068348.0579021.3721042.2723658.49897.732205.6562553.5353077.35288.421308.29262.648136.97691.831420.27197.861844.51881.309352.7169027.3778960.6821445.7424208.31798.861162.3964438.6458727.96269.88293.57209.57776.12714.72844.8563.4383.68149.00481.7568431.8978117.3920829.2823747.12906.721753.1060428.8155526.16278.43625.31248.268935.02704.481182.25180.521696.50496.868222.9469221.9779764.8021525.0523874.24887.781309.7760061.3658144.94289.34239.40215.30861.74793.59786.3261.8095.75150.23601.4068419.4778498.8020951.1023699.76933.812317.4462527.7458797.71311.661551.38263.076063.60825.141407.86225.931421.211043.576346.9268988.3279011.9621489.6124073.67799.381347.5763223.7457647.39270.11467.98201.782916.70756.62800.0589.21150.95203.951097.8268721.7876449.1020879.3223997.251068.651880.6760854.1551754.71367.211222.51361.2221463.91870.781367.92261.812629.90796.3619742.3468898.6477521.6020863.2724067.91870.25695.3564625.5023133.34285.92197.12214.49472.32802.34722.4063.3777.50137.41350.1168475.7078414.4321208.7423978.77190.06666.5360263.1557908.5065.83447.3466.498135.81157.50363.9029.801716.87152.557723.2168431.9477603.4021151.7523938.98117.67398.4461354.6157898.5630.02180.5039.38652.2196.84156.1722.13100.9778.00495.1568665.0676558.8121093.4923904.58225.00881.8762560.3658442.0077.73790.2966.8221537.01201.42402.5143.212623.91277.4320477.3168605.1678959.4021279.2824092.47100.28211.1261428.7415179.5232.78164.7346.61470.7365.85198.9229.1578.5179.88347.4968904.8478829.9821556.7223964.56272.22321.3459202.2958106.86122.84180.52135.04417.58245.41279.1320.9915.3956.8713809.9669132.3677237.6321432.1924118.29651.34732.7760508.1858360.52302.40196.92251.38418.68882.97686.3223.2873.9494.41331.0069098.0778665.0621474.2424119.685579.311022.2259413.9159677.982252.17212.19459.26387.207796.79771.7344.9029.10101.278274.2268705.2178362.2621550.2624302.633689.621496.9261830.8358564.962160.69304.93951.96433.344460.021618.3570.3674.03280.53332.3898340.0699002.3522178.2122977.75924.641198.3789454.8888170.0556.07511.9641.9011130.38536.00536.9137.25314.60239.30979.29OpenBenchmarking.org

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 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,discard2017-06-28 19:5920K40K60K80K100KSE +/- 239.47, N = 3SE +/- 278.01, N = 3SE +/- 340.40, N = 3SE +/- 88.81, N = 3SE +/- 273.67, N = 3SE +/- 271.25, N = 3SE +/- 98.15, N = 3SE +/- 160.58, N = 3SE +/- 95.42, N = 3SE +/- 196.73, N = 3SE +/- 234.84, N = 3SE +/- 285.51, N = 3SE +/- 181.55, N = 3SE +/- 241.90, N = 3SE +/- 367.20, N = 3SE +/- 173.34, N = 3SE +/- 354.48, N = 3SE +/- 353.33, N = 3SE +/- 187.63, N = 3SE +/- 265.65, N = 3SE +/- 224.24, N = 3SE +/- 458.70, N = 3SE +/- 137.76, N = 368288.4668972.7268533.5569187.9168515.6568750.9268348.0569027.3768431.8969221.9768419.4768988.3268721.7868898.6468475.7068431.9468665.0668605.1668904.8469132.3669098.0768705.2198340.061. (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 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,discard2017-06-28 19:5920K40K60K80K100KSE +/- 908.41, N = 3SE +/- 892.84, N = 3SE +/- 163.90, N = 3SE +/- 359.72, N = 3SE +/- 600.35, N = 3SE +/- 360.56, N = 3SE +/- 1146.43, N = 3SE +/- 414.51, N = 3SE +/- 677.98, N = 3SE +/- 1420.32, N = 3SE +/- 537.93, N = 3SE +/- 1161.11, N = 3SE +/- 664.13, N = 3SE +/- 658.62, N = 3SE +/- 842.39, N = 3SE +/- 263.15, N = 3SE +/- 678.12, N = 3SE +/- 864.73, N = 3SE +/- 344.69, N = 3SE +/- 212.90, N = 3SE +/- 903.09, N = 3SE +/- 1401.16, N = 3SE +/- 130.77, N = 376977.4677598.5477873.8278646.5576681.7779555.7879021.3778960.6878117.3979764.8078498.8079011.9676449.1077521.6078414.4377603.4076558.8178959.4078829.9877237.6378665.0678362.2699002.351. (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 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,discard2017-06-28 19:595K10K15K20K25KSE +/- 83.52, N = 3SE +/- 378.36, N = 3SE +/- 145.21, N = 3SE +/- 57.96, N = 3SE +/- 122.72, N = 3SE +/- 116.08, N = 3SE +/- 148.23, N = 3SE +/- 39.10, N = 3SE +/- 137.69, N = 3SE +/- 42.19, N = 3SE +/- 35.40, N = 3SE +/- 45.25, N = 3SE +/- 247.98, N = 3SE +/- 319.38, N = 3SE +/- 107.38, N = 3SE +/- 301.89, N = 3SE +/- 27.25, N = 3SE +/- 163.79, N = 3SE +/- 79.14, N = 3SE +/- 107.00, N = 3SE +/- 162.74, N = 3SE +/- 63.85, N = 3SE +/- 171.72, N = 320997.6720979.4021043.9721371.3921176.8621345.4521042.2721445.7420829.2821525.0520951.1021489.6120879.3220863.2721208.7421151.7521093.4921279.2821556.7221432.1921474.2421550.2622178.211. (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_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,discard2017-06-28 19:595K10K15K20K25KSE +/- 123.84, N = 3SE +/- 73.18, N = 3SE +/- 109.36, N = 3SE +/- 192.02, N = 3SE +/- 75.78, N = 3SE +/- 77.34, N = 3SE +/- 50.83, N = 3SE +/- 82.65, N = 3SE +/- 103.07, N = 3SE +/- 87.86, N = 3SE +/- 199.54, N = 3SE +/- 62.77, N = 3SE +/- 124.91, N = 3SE +/- 218.76, N = 3SE +/- 202.42, N = 3SE +/- 230.73, N = 3SE +/- 232.89, N = 3SE +/- 48.70, N = 3SE +/- 134.13, N = 3SE +/- 150.24, N = 3SE +/- 171.49, N = 3SE +/- 44.16, N = 3SE +/- 241.47, N = 323914.4524192.0723859.9624127.6323829.4024229.9623658.4924208.3123747.1223874.2423699.7624073.6723997.2524067.9123978.7723938.9823904.5824092.4723964.5624118.2924119.6824302.6322977.751. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

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 Writelvm 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,discard2017-06-28 19:5912002400360048006000SE +/- 24.37, N = 6SE +/- 16.83, N = 6SE +/- 27.90, N = 6SE +/- 8.43, N = 6SE +/- 30.07, N = 6SE +/- 4.26, N = 3SE +/- 53.22, N = 6SE +/- 10.09, N = 3SE +/- 55.48, N = 6SE +/- 16.21, N = 3SE +/- 46.96, N = 6SE +/- 15.94, N = 3SE +/- 19.50, N = 3SE +/- 36.75, N = 6SE +/- 9.21, N = 6SE +/- 19.58, N = 6SE +/- 7.49, N = 6SE +/- 11.43, N = 6SE +/- 16.11, N = 6SE +/- 199.68, N = 6SE +/- 119.98, N = 6SE +/- 52.78, N = 3SE +/- 59.45, N = 6428.94391.66554.24436.64855.59902.53897.73798.86906.72887.78933.81799.381068.65870.25190.06117.67225.00100.28272.22651.345579.313689.62924.641. (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 Writelvm 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,discard2017-06-28 19:595001000150020002500SE +/- 40.99, N = 6SE +/- 76.71, N = 6SE +/- 141.45, N = 6SE +/- 33.46, N = 6SE +/- 139.20, N = 6SE +/- 35.67, N = 6SE +/- 154.00, N = 6SE +/- 34.35, N = 6SE +/- 12.71, N = 3SE +/- 133.61, N = 6SE +/- 134.32, N = 6SE +/- 62.62, N = 6SE +/- 33.06, N = 3SE +/- 82.09, N = 6SE +/- 44.27, N = 6SE +/- 76.23, N = 6SE +/- 39.45, N = 6SE +/- 16.00, N = 6SE +/- 4.98, N = 3SE +/- 62.15, N = 6SE +/- 226.19, N = 6SE +/- 84.37, N = 6SE +/- 63.02, N = 61004.38340.921795.59903.652128.231141.402205.651162.391753.101309.772317.441347.571880.67695.35666.53398.44881.87211.12321.34732.771022.221496.921198.371. (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 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,discard2017-06-28 19:5920K40K60K80K100KSE +/- 1000.79, N = 6SE +/- 1340.56, N = 6SE +/- 2095.61, N = 6SE +/- 1261.90, N = 6SE +/- 3267.18, N = 6SE +/- 2975.06, N = 6SE +/- 1988.91, N = 6SE +/- 182.09, N = 3SE +/- 1765.40, N = 6SE +/- 2219.46, N = 6SE +/- 2324.68, N = 6SE +/- 936.58, N = 3SE +/- 1633.90, N = 6SE +/- 2141.87, N = 6SE +/- 2037.87, N = 6SE +/- 1328.76, N = 6SE +/- 801.99, N = 3SE +/- 1102.28, N = 3SE +/- 1827.25, N = 6SE +/- 2400.87, N = 6SE +/- 1538.63, N = 6SE +/- 2992.06, N = 6SE +/- 303.19, N = 361212.9159583.6661400.3065558.2664219.4862967.0762553.5364438.6460428.8160061.3662527.7463223.7460854.1564625.5060263.1561354.6162560.3661428.7459202.2960508.1859413.9161830.8389454.881. (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 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,discard2017-06-28 19:5920K40K60K80K100KSE +/- 1544.48, N = 6SE +/- 9312.69, N = 6SE +/- 551.80, N = 3SE +/- 346.98, N = 3SE +/- 2198.62, N = 6SE +/- 873.00, N = 3SE +/- 2735.87, N = 6SE +/- 270.78, N = 3SE +/- 2045.70, N = 6SE +/- 110.78, N = 3SE +/- 667.86, N = 3SE +/- 649.05, N = 3SE +/- 3786.54, N = 6SE +/- 10271.50, N = 6SE +/- 857.52, N = 3SE +/- 809.91, N = 5SE +/- 642.23, N = 3SE +/- 8949.19, N = 6SE +/- 837.83, N = 3SE +/- 437.40, N = 3SE +/- 864.58, N = 6SE +/- 481.02, N = 3SE +/- 847.32, N = 359083.3244878.8757059.6157826.5455695.4659553.1053077.3558727.9655526.1658144.9458797.7157647.3951754.7123133.3457908.5057898.5658442.0015179.5258106.8658360.5259677.9858564.9688170.051. (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 Writelvm 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,discard2017-06-28 19:595001000150020002500SE +/- 13.46, N = 6SE +/- 7.51, N = 6SE +/- 12.53, N = 6SE +/- 1.88, N = 3SE +/- 19.53, N = 6SE +/- 6.18, N = 6SE +/- 17.15, N = 6SE +/- 6.98, N = 6SE +/- 16.30, N = 6SE +/- 4.28, N = 5SE +/- 21.76, N = 6SE +/- 2.34, N = 3SE +/- 15.29, N = 6SE +/- 16.31, N = 6SE +/- 5.54, N = 6SE +/- 5.68, N = 6SE +/- 2.64, N = 6SE +/- 0.79, N = 6SE +/- 14.33, N = 6SE +/- 20.62, N = 6SE +/- 45.26, N = 6SE +/- 21.40, N = 3SE +/- 3.65, N = 6125.32126.84171.73143.84288.41285.55288.42269.88278.43289.34311.66270.11367.21285.9265.8330.0277.7332.78122.84302.402252.172160.6956.071. (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 Writelvm 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,discard2017-06-28 19:5930060090012001500SE +/- 18.32, N = 6SE +/- 4.87, N = 6SE +/- 26.99, N = 6SE +/- 3.18, N = 6SE +/- 12.19, N = 3SE +/- 2.65, N = 3SE +/- 23.73, N = 6SE +/- 8.88, N = 6SE +/- 76.70, N = 6SE +/- 7.39, N = 6SE +/- 44.00, N = 6SE +/- 20.82, N = 6SE +/- 39.30, N = 6SE +/- 3.80, N = 3SE +/- 14.04, N = 6SE +/- 9.63, N = 6SE +/- 26.75, N = 6SE +/- 2.39, N = 6SE +/- 3.05, N = 6SE +/- 1.70, N = 3SE +/- 15.51, N = 6SE +/- 8.49, N = 6SE +/- 71.20, N = 6682.19195.491082.41217.771341.64258.121308.29293.57625.31239.401551.38467.981222.51197.12447.34180.50790.29164.73180.52196.92212.19304.93511.961. (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 Writelvm 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,discard2017-06-28 19:592004006008001000SE +/- 4.33, N = 6SE +/- 5.67, N = 6SE +/- 13.52, N = 6SE +/- 2.21, N = 3SE +/- 18.66, N = 6SE +/- 18.02, N = 6SE +/- 18.41, N = 6SE +/- 10.57, N = 6SE +/- 13.36, N = 6SE +/- 7.35, N = 6SE +/- 17.47, N = 6SE +/- 1.70, N = 3SE +/- 6.33, N = 6SE +/- 3.71, N = 3SE +/- 2.70, N = 6SE +/- 4.92, N = 6SE +/- 1.48, N = 6SE +/- 4.44, N = 6SE +/- 4.92, N = 6SE +/- 23.43, N = 6SE +/- 12.77, N = 6SE +/- 46.58, N = 6SE +/- 1.18, N = 6115.24111.47171.74117.53264.81225.64262.64209.57248.26215.30263.07201.78361.22214.4966.4939.3866.8246.61135.04251.38459.26951.9641.901. (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 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,discard2017-06-28 19:595K10K15K20K25KSE +/- 384.86, N = 3SE +/- 9.05, N = 6SE +/- 941.62, N = 6SE +/- 16.69, N = 6SE +/- 913.62, N = 6SE +/- 53.20, N = 6SE +/- 4.58, N = 3SE +/- 34.55, N = 6SE +/- 544.19, N = 6SE +/- 178.69, N = 6SE +/- 73.98, N = 3SE +/- 240.27, N = 6SE +/- 771.87, N = 6SE +/- 8.79, N = 6SE +/- 3.48, N = 3SE +/- 39.35, N = 6SE +/- 744.48, N = 6SE +/- 8.27, N = 6SE +/- 1.37, N = 3SE +/- 2.52, N = 3SE +/- 13.34, N = 6SE +/- 5.46, N = 3SE +/- 160.20, N = 322864.92441.9410505.61552.7110887.11626.158136.97776.128935.02861.746063.602916.7021463.91472.328135.81652.2121537.01470.73417.58418.68387.20433.3411130.381. (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 Writelvm 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,discard2017-06-28 19:592K4K6K8K10KSE +/- 14.99, N = 6SE +/- 20.76, N = 6SE +/- 32.26, N = 6SE +/- 8.78, N = 6SE +/- 31.47, N = 6SE +/- 7.66, N = 3SE +/- 29.69, N = 6SE +/- 17.28, N = 6SE +/- 26.15, N = 6SE +/- 10.59, N = 3SE +/- 49.09, N = 6SE +/- 9.68, N = 3SE +/- 36.07, N = 6SE +/- 24.40, N = 6SE +/- 4.80, N = 6SE +/- 16.88, N = 6SE +/- 4.33, N = 6SE +/- 3.16, N = 6SE +/- 6.82, N = 6SE +/- 4.71, N = 3SE +/- 38.39, N = 3SE +/- 73.28, N = 6SE +/- 18.33, N = 6300.23376.19477.56391.39744.76769.99691.83714.72704.48793.59825.14756.62870.78802.34157.5096.84201.4265.85245.41882.977796.794460.02536.001. (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 Writelvm 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,discard2017-06-28 19:5930060090012001500SE +/- 13.93, N = 6SE +/- 27.77, N = 6SE +/- 69.74, N = 6SE +/- 8.44, N = 3SE +/- 82.85, N = 6SE +/- 9.78, N = 3SE +/- 106.65, N = 6SE +/- 31.95, N = 6SE +/- 64.39, N = 6SE +/- 24.13, N = 6SE +/- 85.87, N = 6SE +/- 28.49, N = 6SE +/- 54.49, N = 6SE +/- 7.08, N = 3SE +/- 16.96, N = 6SE +/- 20.18, N = 6SE +/- 2.10, N = 3SE +/- 6.54, N = 6SE +/- 4.76, N = 4SE +/- 22.10, N = 6SE +/- 21.57, N = 6SE +/- 52.12, N = 6SE +/- 26.11, N = 6552.10464.00936.25504.981478.58948.141420.27844.851182.25786.321407.86800.051367.92722.40363.90156.17402.51198.92279.13686.32771.731618.35536.911. (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 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,discard2017-06-28 19:5960120180240300SE +/- 1.53, N = 6SE +/- 0.39, N = 3SE +/- 2.12, N = 6SE +/- 0.36, N = 6SE +/- 3.05, N = 3SE +/- 0.99, N = 3SE +/- 3.06, N = 4SE +/- 2.59, N = 6SE +/- 4.14, N = 6SE +/- 2.78, N = 6SE +/- 4.68, N = 6SE +/- 4.69, N = 6SE +/- 2.10, N = 3SE +/- 0.30, N = 3SE +/- 0.25, N = 3SE +/- 5.21, N = 6SE +/- 0.51, N = 3SE +/- 0.69, N = 6SE +/- 1.95, N = 6SE +/- 0.61, N = 6SE +/- 0.82, N = 3SE +/- 0.56, N = 3SE +/- 2.68, N = 674.9621.65116.5223.01198.9466.35197.8663.43180.5261.80225.9389.21261.8163.3729.8022.1343.2129.1520.9923.2844.9070.3637.251. (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 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,discard2017-06-28 19:596001200180024003000SE +/- 6.32, N = 3SE +/- 1.20, N = 4SE +/- 38.51, N = 6SE +/- 2.20, N = 6SE +/- 34.84, N = 6SE +/- 2.89, N = 6SE +/- 68.16, N = 6SE +/- 2.69, N = 6SE +/- 42.66, N = 6SE +/- 4.32, N = 6SE +/- 19.47, N = 3SE +/- 19.35, N = 6SE +/- 40.76, N = 5SE +/- 1.40, N = 6SE +/- 47.87, N = 6SE +/- 8.94, N = 6SE +/- 43.84, N = 6SE +/- 1.76, N = 6SE +/- 0.11, N = 3SE +/- 0.23, N = 3SE +/- 3.90, N = 6SE +/- 0.45, N = 3SE +/- 23.02, N = 62544.9577.541619.9089.221663.5690.601844.5183.681696.5095.751421.21150.952629.9077.501716.87100.972623.9178.5115.3973.9429.1074.03314.601. (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 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,discard2017-06-28 19:592004006008001000SE +/- 16.22, N = 6SE +/- 2.02, N = 6SE +/- 23.29, N = 6SE +/- 3.38, N = 6SE +/- 24.49, N = 6SE +/- 5.25, N = 6SE +/- 13.43, N = 6SE +/- 10.96, N = 6SE +/- 29.22, N = 6SE +/- 8.89, N = 6SE +/- 42.21, N = 6SE +/- 11.59, N = 6SE +/- 17.70, N = 6SE +/- 3.01, N = 6SE +/- 11.00, N = 6SE +/- 2.00, N = 6SE +/- 37.54, N = 6SE +/- 2.92, N = 6SE +/- 1.11, N = 6SE +/- 1.50, N = 3SE +/- 2.77, N = 6SE +/- 13.00, N = 6SE +/- 13.79, N = 6320.2394.05645.95106.26861.65179.22881.30149.00496.86150.231043.57203.95796.36137.41152.5578.00277.4379.8856.8794.41101.27280.53239.301. (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 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,discard2017-06-28 19:594K8K12K16K20KSE +/- 136.42, N = 3SE +/- 18.63, N = 6SE +/- 517.42, N = 6SE +/- 5.78, N = 6SE +/- 641.31, N = 6SE +/- 22.29, N = 6SE +/- 991.78, N = 6SE +/- 20.75, N = 6SE +/- 354.20, N = 6SE +/- 78.88, N = 6SE +/- 273.32, N = 6SE +/- 253.91, N = 6SE +/- 304.64, N = 4SE +/- 5.56, N = 6SE +/- 17.78, N = 3SE +/- 27.91, N = 6SE +/- 281.41, N = 5SE +/- 5.89, N = 4SE +/- 4325.01, N = 6SE +/- 5.31, N = 4SE +/- 2552.91, N = 6SE +/- 4.48, N = 6SE +/- 63.42, N = 620162.02316.918279.07394.998415.20480.809352.71481.758222.94601.406346.921097.8219742.34350.117723.21495.1520477.31347.4913809.96331.008274.22332.38979.291. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic

Phoronix Test Suite v10.8.4