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&grw&rdt&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: On-Disk - Normal Load - Read Onlypgbench: On-Disk - Normal Load - Read Writepgbench: On-Disk - Single Thread - Read Onlypgbench: Mostly RAM - Normal Load - Read Onlypgbench: On-Disk - Single Thread - Read Writepgbench: Buffer Test - Normal Load - Read Onlypgbench: Mostly RAM - Normal Load - Read Writepgbench: Buffer Test - Normal Load - Read Writepgbench: Mostly RAM - Single Thread - Read Onlypgbench: On-Disk - Heavy Contention - Read Onlypgbench: Buffer Test - Single Thread - Read Onlypgbench: Mostly RAM - Single Thread - Read Writepgbench: On-Disk - Heavy Contention - Read Writepgbench: Buffer Test - Single Thread - Read Writepgbench: Mostly RAM - Heavy Contention - Read Onlypgbench: Buffer Test - Heavy Contention - Read Onlypgbench: Mostly RAM - Heavy Contention - Read Writepgbench: Buffer Test - Heavy Contention - 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,discard1. xl03 lzo 6420162.02320.232544.9568288.4674.9676977.46552.10300.2320997.6722864.9223914.45115.24682.19125.3259083.3261212.911004.38428.94316.9194.0577.5468972.7221.6577598.54464.00376.1920979.40441.9424192.07111.47195.49126.8444878.8759583.66340.92391.668279.07645.951619.9068533.55116.5277873.82936.25477.5621043.9710505.6123859.96171.741082.41171.7357059.6161400.301795.59554.24394.99106.2689.2269187.9123.0178646.55504.98391.3921371.39552.7124127.63117.53217.77143.8457826.5465558.26903.65436.648415.20861.651663.5668515.65198.9476681.771478.58744.7621176.8610887.1123829.40264.811341.64288.4155695.4664219.482128.23855.59480.80179.2290.6068750.9266.3579555.78948.14769.9921345.45626.1524229.96225.64258.12285.5559553.1062967.071141.40902.539352.71881.301844.5168348.05197.8679021.371420.27691.8321042.278136.9723658.49262.641308.29288.4253077.3562553.532205.65897.73481.75149.0083.6869027.3763.4378960.68844.85714.7221445.74776.1224208.31209.57293.57269.8858727.9664438.641162.39798.868222.94496.861696.5068431.89180.5278117.391182.25704.4820829.288935.0223747.12248.26625.31278.4355526.1660428.811753.10906.72601.40150.2395.7569221.9761.8079764.80786.32793.5921525.05861.7423874.24215.30239.40289.3458144.9460061.361309.77887.786346.921043.571421.2168419.47225.9378498.801407.86825.1420951.106063.6023699.76263.071551.38311.6658797.7162527.742317.44933.811097.82203.95150.9568988.3289.2179011.96800.05756.6221489.612916.7024073.67201.78467.98270.1157647.3963223.741347.57799.3819742.34796.362629.9068721.78261.8176449.101367.92870.7820879.3221463.9123997.25361.221222.51367.2151754.7160854.151880.671068.65350.11137.4177.5068898.6463.3777521.60722.40802.3420863.27472.3224067.91214.49197.12285.9223133.3464625.50695.35870.257723.21152.551716.8768475.7029.8078414.43363.90157.5021208.748135.8123978.7766.49447.3465.8357908.5060263.15666.53190.06495.1578.00100.9768431.9422.1377603.40156.1796.8421151.75652.2123938.9839.38180.5030.0257898.5661354.61398.44117.6720477.31277.432623.9168665.0643.2176558.81402.51201.4221093.4921537.0123904.5866.82790.2977.7358442.0062560.36881.87225.00347.4979.8878.5168605.1629.1578959.40198.9265.8521279.28470.7324092.4746.61164.7332.7815179.5261428.74211.12100.2813809.9656.8715.3968904.8420.9978829.98279.13245.4121556.72417.5823964.56135.04180.52122.8458106.8659202.29321.34272.22331.0094.4173.9469132.3623.2877237.63686.32882.9721432.19418.6824118.29251.38196.92302.4058360.5260508.18732.77651.348274.22101.2729.1069098.0744.9078665.06771.737796.7921474.24387.2024119.68459.26212.192252.1759677.9859413.911022.225579.31332.38280.5374.0368705.2170.3678362.261618.354460.0221550.26433.3424302.63951.96304.932160.6958564.9661830.831496.923689.62OpenBenchmarking.org

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 ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultslvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default btrfs defaultslvm io_default btrfs defaults4K8K12K16K20KSE +/- 4.48, N = 6SE +/- 2552.91, N = 6SE +/- 5.31, N = 4SE +/- 4325.01, N = 6SE +/- 5.89, N = 4SE +/- 281.41, N = 5SE +/- 27.91, N = 6SE +/- 17.78, N = 3SE +/- 5.56, N = 6SE +/- 304.64, N = 4SE +/- 253.91, N = 6SE +/- 273.32, N = 6SE +/- 78.88, N = 6SE +/- 354.20, N = 6SE +/- 20.75, N = 6SE +/- 991.78, N = 6SE +/- 22.29, N = 6SE +/- 641.31, N = 6SE +/- 5.78, N = 6SE +/- 517.42, N = 6SE +/- 18.63, N = 6SE +/- 136.42, N = 3332.388274.22331.0013809.96347.4920477.31495.157723.21350.1119742.341097.826346.92601.408222.94481.759352.71480.808415.20394.998279.07316.9120162.021. (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 Writebcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultslvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default btrfs defaultslvm io_default btrfs defaults2004006008001000SE +/- 13.00, N = 6SE +/- 2.77, N = 6SE +/- 1.50, N = 3SE +/- 1.11, N = 6SE +/- 2.92, N = 6SE +/- 37.54, N = 6SE +/- 2.00, N = 6SE +/- 11.00, N = 6SE +/- 3.01, N = 6SE +/- 17.70, N = 6SE +/- 11.59, N = 6SE +/- 42.21, N = 6SE +/- 8.89, N = 6SE +/- 29.22, N = 6SE +/- 10.96, N = 6SE +/- 13.43, N = 6SE +/- 5.25, N = 6SE +/- 24.49, N = 6SE +/- 3.38, N = 6SE +/- 23.29, N = 6SE +/- 2.02, N = 6SE +/- 16.22, N = 6280.53101.2794.4156.8779.88277.4378.00152.55137.41796.36203.951043.57150.23496.86149.00881.30179.22861.65106.26645.9594.05320.231. (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 Onlybcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultslvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default btrfs defaultslvm io_default btrfs defaults6001200180024003000SE +/- 0.45, N = 3SE +/- 3.90, N = 6SE +/- 0.23, N = 3SE +/- 0.11, N = 3SE +/- 1.76, N = 6SE +/- 43.84, N = 6SE +/- 8.94, N = 6SE +/- 47.87, N = 6SE +/- 1.40, N = 6SE +/- 40.76, N = 5SE +/- 19.35, N = 6SE +/- 19.47, N = 3SE +/- 4.32, N = 6SE +/- 42.66, N = 6SE +/- 2.69, N = 6SE +/- 68.16, N = 6SE +/- 2.89, N = 6SE +/- 34.84, N = 6SE +/- 2.20, N = 6SE +/- 38.51, N = 6SE +/- 1.20, N = 4SE +/- 6.32, N = 374.0329.1073.9415.3978.512623.91100.971716.8777.502629.90150.951421.2195.751696.5083.681844.5190.601663.5689.221619.9077.542544.951. (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 Onlybcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultslvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default btrfs defaultslvm io_default btrfs defaults15K30K45K60K75KSE +/- 458.70, N = 3SE +/- 224.24, N = 3SE +/- 265.65, N = 3SE +/- 187.63, N = 3SE +/- 353.33, N = 3SE +/- 354.48, N = 3SE +/- 173.34, N = 3SE +/- 367.20, N = 3SE +/- 241.90, N = 3SE +/- 181.55, N = 3SE +/- 285.51, N = 3SE +/- 234.84, N = 3SE +/- 196.73, N = 3SE +/- 95.42, N = 3SE +/- 160.58, N = 3SE +/- 98.15, N = 3SE +/- 271.25, N = 3SE +/- 273.67, N = 3SE +/- 88.81, N = 3SE +/- 340.40, N = 3SE +/- 278.01, N = 3SE +/- 239.47, N = 368705.2169098.0769132.3668904.8468605.1668665.0668431.9468475.7068898.6468721.7868988.3268419.4769221.9768431.8969027.3768348.0568750.9268515.6569187.9168533.5568972.7268288.461. (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 Writebcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultslvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default btrfs defaultslvm io_default btrfs defaults60120180240300SE +/- 0.56, N = 3SE +/- 0.82, N = 3SE +/- 0.61, N = 6SE +/- 1.95, N = 6SE +/- 0.69, N = 6SE +/- 0.51, N = 3SE +/- 5.21, N = 6SE +/- 0.25, N = 3SE +/- 0.30, N = 3SE +/- 2.10, N = 3SE +/- 4.69, N = 6SE +/- 4.68, N = 6SE +/- 2.78, N = 6SE +/- 4.14, N = 6SE +/- 2.59, N = 6SE +/- 3.06, N = 4SE +/- 0.99, N = 3SE +/- 3.05, N = 3SE +/- 0.36, N = 6SE +/- 2.12, N = 6SE +/- 0.39, N = 3SE +/- 1.53, N = 670.3644.9023.2820.9929.1543.2122.1329.8063.37261.8189.21225.9361.80180.5263.43197.8666.35198.9423.01116.5221.6574.961. (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 Onlybcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultslvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default btrfs defaultslvm io_default btrfs defaults20K40K60K80K100KSE +/- 1401.16, N = 3SE +/- 903.09, N = 3SE +/- 212.90, N = 3SE +/- 344.69, N = 3SE +/- 864.73, N = 3SE +/- 678.12, N = 3SE +/- 263.15, N = 3SE +/- 842.39, N = 3SE +/- 658.62, N = 3SE +/- 664.13, N = 3SE +/- 1161.11, N = 3SE +/- 537.93, N = 3SE +/- 1420.32, N = 3SE +/- 677.98, N = 3SE +/- 414.51, N = 3SE +/- 1146.43, N = 3SE +/- 360.56, N = 3SE +/- 600.35, N = 3SE +/- 359.72, N = 3SE +/- 163.90, N = 3SE +/- 892.84, N = 3SE +/- 908.41, N = 378362.2678665.0677237.6378829.9878959.4076558.8177603.4078414.4377521.6076449.1079011.9678498.8079764.8078117.3978960.6879021.3779555.7876681.7778646.5577873.8277598.5476977.461. (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 ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultslvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default btrfs defaultslvm io_default btrfs defaults30060090012001500SE +/- 52.12, N = 6SE +/- 21.57, N = 6SE +/- 22.10, N = 6SE +/- 4.76, N = 4SE +/- 6.54, N = 6SE +/- 2.10, N = 3SE +/- 20.18, N = 6SE +/- 16.96, N = 6SE +/- 7.08, N = 3SE +/- 54.49, N = 6SE +/- 28.49, N = 6SE +/- 85.87, N = 6SE +/- 24.13, N = 6SE +/- 64.39, N = 6SE +/- 31.95, N = 6SE +/- 106.65, N = 6SE +/- 9.78, N = 3SE +/- 82.85, N = 6SE +/- 8.44, N = 3SE +/- 69.74, N = 6SE +/- 27.77, N = 6SE +/- 13.93, N = 61618.35771.73686.32279.13198.92402.51156.17363.90722.401367.92800.051407.86786.321182.25844.851420.27948.141478.58504.98936.25464.00552.101. (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 ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultslvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default btrfs defaultslvm io_default btrfs defaults2K4K6K8K10KSE +/- 73.28, N = 6SE +/- 38.39, N = 3SE +/- 4.71, N = 3SE +/- 6.82, N = 6SE +/- 3.16, N = 6SE +/- 4.33, N = 6SE +/- 16.88, N = 6SE +/- 4.80, N = 6SE +/- 24.40, N = 6SE +/- 36.07, N = 6SE +/- 9.68, N = 3SE +/- 49.09, N = 6SE +/- 10.59, N = 3SE +/- 26.15, N = 6SE +/- 17.28, N = 6SE +/- 29.69, N = 6SE +/- 7.66, N = 3SE +/- 31.47, N = 6SE +/- 8.78, N = 6SE +/- 32.26, N = 6SE +/- 20.76, N = 6SE +/- 14.99, N = 64460.027796.79882.97245.4165.85201.4296.84157.50802.34870.78756.62825.14793.59704.48714.72691.83769.99744.76391.39477.56376.19300.231. (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 Onlybcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultslvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default btrfs defaultslvm io_default btrfs defaults5K10K15K20K25KSE +/- 63.85, N = 3SE +/- 162.74, N = 3SE +/- 107.00, N = 3SE +/- 79.14, N = 3SE +/- 163.79, N = 3SE +/- 27.25, N = 3SE +/- 301.89, N = 3SE +/- 107.38, N = 3SE +/- 319.38, N = 3SE +/- 247.98, N = 3SE +/- 45.25, N = 3SE +/- 35.40, N = 3SE +/- 42.19, N = 3SE +/- 137.69, N = 3SE +/- 39.10, N = 3SE +/- 148.23, N = 3SE +/- 116.08, N = 3SE +/- 122.72, N = 3SE +/- 57.96, N = 3SE +/- 145.21, N = 3SE +/- 378.36, N = 3SE +/- 83.52, N = 321550.2621474.2421432.1921556.7221279.2821093.4921151.7521208.7420863.2720879.3221489.6120951.1021525.0520829.2821445.7421042.2721345.4521176.8621371.3921043.9720979.4020997.671. (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 Onlybcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultslvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default btrfs defaultslvm io_default btrfs defaults5K10K15K20K25KSE +/- 5.46, N = 3SE +/- 13.34, N = 6SE +/- 2.52, N = 3SE +/- 1.37, N = 3SE +/- 8.27, N = 6SE +/- 744.48, N = 6SE +/- 39.35, N = 6SE +/- 3.48, N = 3SE +/- 8.79, N = 6SE +/- 771.87, N = 6SE +/- 240.27, N = 6SE +/- 73.98, N = 3SE +/- 178.69, N = 6SE +/- 544.19, N = 6SE +/- 34.55, N = 6SE +/- 4.58, N = 3SE +/- 53.20, N = 6SE +/- 913.62, N = 6SE +/- 16.69, N = 6SE +/- 941.62, N = 6SE +/- 9.05, N = 6SE +/- 384.86, N = 3433.34387.20418.68417.58470.7321537.01652.218135.81472.3221463.912916.706063.60861.748935.02776.128136.97626.1510887.11552.7110505.61441.9422864.921. (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 Onlybcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultslvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default btrfs defaultslvm io_default btrfs defaults5K10K15K20K25KSE +/- 44.16, N = 3SE +/- 171.49, N = 3SE +/- 150.24, N = 3SE +/- 134.13, N = 3SE +/- 48.70, N = 3SE +/- 232.89, N = 3SE +/- 230.73, N = 3SE +/- 202.42, N = 3SE +/- 218.76, N = 3SE +/- 124.91, N = 3SE +/- 62.77, N = 3SE +/- 199.54, N = 3SE +/- 87.86, N = 3SE +/- 103.07, N = 3SE +/- 82.65, N = 3SE +/- 50.83, N = 3SE +/- 77.34, N = 3SE +/- 75.78, N = 3SE +/- 192.02, N = 3SE +/- 109.36, N = 3SE +/- 73.18, N = 3SE +/- 123.84, N = 324302.6324119.6824118.2923964.5624092.4723904.5823938.9823978.7724067.9123997.2524073.6723699.7623874.2423747.1224208.3123658.4924229.9623829.4024127.6323859.9624192.0723914.451. (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 ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultslvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default btrfs defaultslvm io_default btrfs defaults2004006008001000SE +/- 46.58, N = 6SE +/- 12.77, N = 6SE +/- 23.43, N = 6SE +/- 4.92, N = 6SE +/- 4.44, N = 6SE +/- 1.48, N = 6SE +/- 4.92, N = 6SE +/- 2.70, N = 6SE +/- 3.71, N = 3SE +/- 6.33, N = 6SE +/- 1.70, N = 3SE +/- 17.47, N = 6SE +/- 7.35, N = 6SE +/- 13.36, N = 6SE +/- 10.57, N = 6SE +/- 18.41, N = 6SE +/- 18.02, N = 6SE +/- 18.66, N = 6SE +/- 2.21, N = 3SE +/- 13.52, N = 6SE +/- 5.67, N = 6SE +/- 4.33, N = 6951.96459.26251.38135.0446.6166.8239.3866.49214.49361.22201.78263.07215.30248.26209.57262.64225.64264.81117.53171.74111.47115.241. (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 ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultslvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default btrfs defaultslvm io_default btrfs defaults30060090012001500SE +/- 8.49, N = 6SE +/- 15.51, N = 6SE +/- 1.70, N = 3SE +/- 3.05, N = 6SE +/- 2.39, N = 6SE +/- 26.75, N = 6SE +/- 9.63, N = 6SE +/- 14.04, N = 6SE +/- 3.80, N = 3SE +/- 39.30, N = 6SE +/- 20.82, N = 6SE +/- 44.00, N = 6SE +/- 7.39, N = 6SE +/- 76.70, N = 6SE +/- 8.88, N = 6SE +/- 23.73, N = 6SE +/- 2.65, N = 3SE +/- 12.19, N = 3SE +/- 3.18, N = 6SE +/- 26.99, N = 6SE +/- 4.87, N = 6SE +/- 18.32, N = 6304.93212.19196.92180.52164.73790.29180.50447.34197.121222.51467.981551.38239.40625.31293.571308.29258.121341.64217.771082.41195.49682.191. (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 ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultslvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default btrfs defaultslvm io_default btrfs defaults5001000150020002500SE +/- 21.40, N = 3SE +/- 45.26, N = 6SE +/- 20.62, N = 6SE +/- 14.33, N = 6SE +/- 0.79, N = 6SE +/- 2.64, N = 6SE +/- 5.68, N = 6SE +/- 5.54, N = 6SE +/- 16.31, N = 6SE +/- 15.29, N = 6SE +/- 2.34, N = 3SE +/- 21.76, N = 6SE +/- 4.28, N = 5SE +/- 16.30, N = 6SE +/- 6.98, N = 6SE +/- 17.15, N = 6SE +/- 6.18, N = 6SE +/- 19.53, N = 6SE +/- 1.88, N = 3SE +/- 12.53, N = 6SE +/- 7.51, N = 6SE +/- 13.46, N = 62160.692252.17302.40122.8432.7877.7330.0265.83285.92367.21270.11311.66289.34278.43269.88288.42285.55288.41143.84171.73126.84125.321. (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 ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultslvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default btrfs defaultslvm io_default btrfs defaults13K26K39K52K65KSE +/- 481.02, N = 3SE +/- 864.58, N = 6SE +/- 437.40, N = 3SE +/- 837.83, N = 3SE +/- 8949.19, N = 6SE +/- 642.23, N = 3SE +/- 809.91, N = 5SE +/- 857.52, N = 3SE +/- 10271.50, N = 6SE +/- 3786.54, N = 6SE +/- 649.05, N = 3SE +/- 667.86, N = 3SE +/- 110.78, N = 3SE +/- 2045.70, N = 6SE +/- 270.78, N = 3SE +/- 2735.87, N = 6SE +/- 873.00, N = 3SE +/- 2198.62, N = 6SE +/- 346.98, N = 3SE +/- 551.80, N = 3SE +/- 9312.69, N = 6SE +/- 1544.48, N = 658564.9659677.9858360.5258106.8615179.5258442.0057898.5657908.5023133.3451754.7157647.3958797.7158144.9455526.1658727.9653077.3559553.1055695.4657826.5457059.6144878.8759083.321. (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 Onlybcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultslvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default btrfs defaultslvm io_default btrfs defaults14K28K42K56K70KSE +/- 2992.06, N = 6SE +/- 1538.63, N = 6SE +/- 2400.87, N = 6SE +/- 1827.25, N = 6SE +/- 1102.28, N = 3SE +/- 801.99, N = 3SE +/- 1328.76, N = 6SE +/- 2037.87, N = 6SE +/- 2141.87, N = 6SE +/- 1633.90, N = 6SE +/- 936.58, N = 3SE +/- 2324.68, N = 6SE +/- 2219.46, N = 6SE +/- 1765.40, N = 6SE +/- 182.09, N = 3SE +/- 1988.91, N = 6SE +/- 2975.06, N = 6SE +/- 3267.18, N = 6SE +/- 1261.90, N = 6SE +/- 2095.61, N = 6SE +/- 1340.56, N = 6SE +/- 1000.79, N = 661830.8359413.9160508.1859202.2961428.7462560.3661354.6160263.1564625.5060854.1563223.7462527.7460061.3660428.8164438.6462553.5362967.0764219.4865558.2661400.3059583.6661212.911. (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 ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultslvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default btrfs defaultslvm io_default btrfs defaults5001000150020002500SE +/- 84.37, N = 6SE +/- 226.19, N = 6SE +/- 62.15, N = 6SE +/- 4.98, N = 3SE +/- 16.00, N = 6SE +/- 39.45, N = 6SE +/- 76.23, N = 6SE +/- 44.27, N = 6SE +/- 82.09, N = 6SE +/- 33.06, N = 3SE +/- 62.62, N = 6SE +/- 134.32, N = 6SE +/- 133.61, N = 6SE +/- 12.71, N = 3SE +/- 34.35, N = 6SE +/- 154.00, N = 6SE +/- 35.67, N = 6SE +/- 139.20, N = 6SE +/- 33.46, N = 6SE +/- 141.45, N = 6SE +/- 76.71, N = 6SE +/- 40.99, N = 61496.921022.22732.77321.34211.12881.87398.44666.53695.351880.671347.572317.441309.771753.101162.392205.651141.402128.23903.651795.59340.921004.381. (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 Writebcache io_default ext4 data=writeback,noatime,barrier=0,discardlvm io_default ext4 data=writeback,noatime,barrier=0,discardbcache io_default ext4 defaultslvm io_default ext4 defaultsbcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacowbcache io_default btrfs compress=lzo,discard,nobarrier,notreeloglvm io_default btrfs compress=lzo,discard,nobarrier,notreelogbcache io_default btrfs compress=lzo,discard,nobarrier,nodatacowlvm io_default btrfs compress=lzo,discard,nobarrier,nodatacowbcache io_default btrfs compress=zlib,discard,nobarrier,nodatasumlvm io_default btrfs compress=zlib,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefraglvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefragbcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzo,discard,nobarrier,nodatasumlvm io_default btrfs compress=lzo,discard,nobarrier,nodatasumbcache io_default btrfs compress=lzolvm io_default btrfs compress=lzobcache io_default btrfs defaultslvm io_default btrfs defaults12002400360048006000SE +/- 52.78, N = 3SE +/- 119.98, N = 6SE +/- 199.68, N = 6SE +/- 16.11, N = 6SE +/- 11.43, N = 6SE +/- 7.49, N = 6SE +/- 19.58, N = 6SE +/- 9.21, N = 6SE +/- 36.75, N = 6SE +/- 19.50, N = 3SE +/- 15.94, N = 3SE +/- 46.96, N = 6SE +/- 16.21, N = 3SE +/- 55.48, N = 6SE +/- 10.09, N = 3SE +/- 53.22, N = 6SE +/- 4.26, N = 3SE +/- 30.07, N = 6SE +/- 8.43, N = 6SE +/- 27.90, N = 6SE +/- 16.83, N = 6SE +/- 24.37, N = 63689.625579.31651.34272.22100.28225.00117.67190.06870.251068.65799.38933.81887.78906.72798.86897.73902.53855.59436.64554.24391.66428.941. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic


Phoronix Test Suite v10.8.5