Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 1706286-ASVA-170624645
pgall_1
try to find the best setup for postgres over the dm-cache-bcache-btrfs-zfs field
lvm io_default btrfs defaults:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
bcache io_default btrfs defaults:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
lvm io_default btrfs compress=lzo:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
bcache io_default btrfs compress=lzo:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
lvm io_default ext4 defaults:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
bcache io_default ext4 defaults:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
lvm io_default ext4 data=writeback,noatime,barrier=0,discard:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
bcache io_default ext4 data=writeback,noatime,barrier=0,discard:
Processor: Intel Core i5-4590 @ 3.70GHz (4 Cores), Motherboard: MSI Z97-G43 (MS-7816) v3.0, Chipset: Intel 4th Gen Core DRAM, Memory: 2048MB, Disk: 2 x 4001GB Western Digital WD40EFRX-68W + 240GB ADATA SP550, Graphics: Intel HD 4600 (1150MHz), Audio: Intel Xeon E3-1200 v3/4th, Network: Realtek RTL8111/8168/8411
OS: Ubuntu 16.04, Kernel: 4.4.0-21-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: intel 2.99.917, Compiler: GCC 5.4.0 20160609, File-System: overlayfs, Screen Resolution: 2560x1440
1. xl03 lzo 64:
Processor: Intel Core i7-4770 @ 3.90GHz (8 Cores), Motherboard: MSI H87-G43 (MS-7816) v1.0, Chipset: Intel 4th Gen Core DRAM, Memory: 32768MB, Disk: 2 x 240GB INTEL SSDSC2CW24 + 2 x 2000GB Western Digital WD2000FYYZ-0, Graphics: Intel Xeon E3-1200 v3/4th Gen Core IGP, Network: Realtek RTL8111/8168/8411
OS: Debian 8.8, Kernel: 4.9.0-0.bpo.3-amd64 (x86_64), Compiler: GCC 4.9.2, File-System: btrfs
2017-06-28 12:52:
Processor: Intel Core i7-4770 @ 3.90GHz (8 Cores), Motherboard: MSI H87-G43 (MS-7816) v1.0, Chipset: Intel 4th Gen Core DRAM, Memory: 32768MB, Disk: 2 x 240GB INTEL SSDSC2CW24 + 2 x 2000GB Western Digital WD2000FYYZ-0, Graphics: Intel Xeon E3-1200 v3/4th Gen Core IGP, Network: Realtek RTL8111/8168/8411
OS: Debian 8.8, Kernel: 4.9.0-0.bpo.3-amd64 (x86_64), Compiler: GCC 4.9.2, File-System: btrfs
PostgreSQL pgbench 9.6.3
Scaling: On-Disk - Test: Normal Load - Mode: Read Only
TPS > Higher Is Better
lvm io_default btrfs defaults ............................................... 20162.02 |
bcache io_default btrfs defaults ............................................ 316.91 |
lvm io_default btrfs compress=lzo ........................................... 8279.07 |
bcache io_default btrfs compress=lzo ........................................ 394.99 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............... 8415.20 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............ 480.80 |
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum ................. 9352.71 |
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum .............. 481.75 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag .... 8222.94 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag . 601.40 |
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum .............. 6346.92 |
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum ........... 1097.82 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............... 19742.34 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............ 350.11 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog ............... 7723.21 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog ............ 495.15 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow ..... 20477.31 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow .. 347.49 |
lvm io_default ext4 defaults ................................................ 13809.96 |
bcache io_default ext4 defaults ............................................. 331.00 |
lvm io_default ext4 data=writeback,noatime,barrier=0,discard ................ 8274.22 |
bcache io_default ext4 data=writeback,noatime,barrier=0,discard ............. 332.38 |
PostgreSQL pgbench 9.6.3
Scaling: On-Disk - Test: Normal Load - Mode: Read Write
TPS > Higher Is Better
lvm io_default btrfs defaults ............................................... 320.23 |
bcache io_default btrfs defaults ............................................ 94.05 |
lvm io_default btrfs compress=lzo ........................................... 645.95 |
bcache io_default btrfs compress=lzo ........................................ 106.26 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............... 861.65 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............ 179.22 |
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum ................. 881.30 |
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum .............. 149.00 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag .... 496.86 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag . 150.23 |
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum .............. 1043.57 |
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum ........... 203.95 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............... 796.36 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............ 137.41 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog ............... 152.55 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog ............ 78.00 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow ..... 277.43 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow .. 79.88 |
lvm io_default ext4 defaults ................................................ 56.87 |
bcache io_default ext4 defaults ............................................. 94.41 |
lvm io_default ext4 data=writeback,noatime,barrier=0,discard ................ 101.27 |
bcache io_default ext4 data=writeback,noatime,barrier=0,discard ............. 280.53 |
PostgreSQL pgbench 9.6.3
Scaling: On-Disk - Test: Single Thread - Mode: Read Only
TPS > Higher Is Better
lvm io_default btrfs defaults ............................................... 2544.95 |
bcache io_default btrfs defaults ............................................ 77.54 |
lvm io_default btrfs compress=lzo ........................................... 1619.90 |
bcache io_default btrfs compress=lzo ........................................ 89.22 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............... 1663.56 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............ 90.60 |
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum ................. 1844.51 |
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum .............. 83.68 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag .... 1696.50 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag . 95.75 |
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum .............. 1421.21 |
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum ........... 150.95 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............... 2629.90 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............ 77.50 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog ............... 1716.87 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog ............ 100.97 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow ..... 2623.91 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow .. 78.51 |
lvm io_default ext4 defaults ................................................ 15.39 |
bcache io_default ext4 defaults ............................................. 73.94 |
lvm io_default ext4 data=writeback,noatime,barrier=0,discard ................ 29.10 |
bcache io_default ext4 data=writeback,noatime,barrier=0,discard ............. 74.03 |
PostgreSQL pgbench 9.6.3
Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only
TPS > Higher Is Better
lvm io_default btrfs defaults ............................................... 68288.46 |
bcache io_default btrfs defaults ............................................ 68972.72 |
lvm io_default btrfs compress=lzo ........................................... 68533.55 |
bcache io_default btrfs compress=lzo ........................................ 69187.91 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............... 68515.65 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............ 68750.92 |
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum ................. 68348.05 |
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum .............. 69027.37 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag .... 68431.89 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag . 69221.97 |
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum .............. 68419.47 |
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum ........... 68988.32 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............... 68721.78 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............ 68898.64 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog ............... 68475.70 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog ............ 68431.94 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow ..... 68665.06 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow .. 68605.16 |
lvm io_default ext4 defaults ................................................ 68904.84 |
bcache io_default ext4 defaults ............................................. 69132.36 |
lvm io_default ext4 data=writeback,noatime,barrier=0,discard ................ 69098.07 |
bcache io_default ext4 data=writeback,noatime,barrier=0,discard ............. 68705.21 |
PostgreSQL pgbench 9.6.3
Scaling: On-Disk - Test: Single Thread - Mode: Read Write
TPS > Higher Is Better
lvm io_default btrfs defaults ............................................... 74.96 |
bcache io_default btrfs defaults ............................................ 21.65 |
lvm io_default btrfs compress=lzo ........................................... 116.52 |
bcache io_default btrfs compress=lzo ........................................ 23.01 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............... 198.94 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............ 66.35 |
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum ................. 197.86 |
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum .............. 63.43 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag .... 180.52 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag . 61.80 |
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum .............. 225.93 |
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum ........... 89.21 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............... 261.81 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............ 63.37 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog ............... 29.80 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog ............ 22.13 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow ..... 43.21 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow .. 29.15 |
lvm io_default ext4 defaults ................................................ 20.99 |
bcache io_default ext4 defaults ............................................. 23.28 |
lvm io_default ext4 data=writeback,noatime,barrier=0,discard ................ 44.90 |
bcache io_default ext4 data=writeback,noatime,barrier=0,discard ............. 70.36 |
PostgreSQL pgbench 9.6.3
Scaling: Buffer Test - Test: Normal Load - Mode: Read Only
TPS > Higher Is Better
lvm io_default btrfs defaults ............................................... 76977.46 |
bcache io_default btrfs defaults ............................................ 77598.54 |
lvm io_default btrfs compress=lzo ........................................... 77873.82 |
bcache io_default btrfs compress=lzo ........................................ 78646.55 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............... 76681.77 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............ 79555.78 |
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum ................. 79021.37 |
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum .............. 78960.68 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag .... 78117.39 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag . 79764.80 |
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum .............. 78498.80 |
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum ........... 79011.96 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............... 76449.10 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............ 77521.60 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog ............... 78414.43 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog ............ 77603.40 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow ..... 76558.81 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow .. 78959.40 |
lvm io_default ext4 defaults ................................................ 78829.98 |
bcache io_default ext4 defaults ............................................. 77237.63 |
lvm io_default ext4 data=writeback,noatime,barrier=0,discard ................ 78665.06 |
bcache io_default ext4 data=writeback,noatime,barrier=0,discard ............. 78362.26 |
PostgreSQL pgbench 9.6.3
Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write
TPS > Higher Is Better
lvm io_default btrfs defaults ............................................... 552.10 |
bcache io_default btrfs defaults ............................................ 464.00 |
lvm io_default btrfs compress=lzo ........................................... 936.25 |
bcache io_default btrfs compress=lzo ........................................ 504.98 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............... 1478.58 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............ 948.14 |
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum ................. 1420.27 |
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum .............. 844.85 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag .... 1182.25 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag . 786.32 |
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum .............. 1407.86 |
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum ........... 800.05 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............... 1367.92 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............ 722.40 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog ............... 363.90 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog ............ 156.17 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow ..... 402.51 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow .. 198.92 |
lvm io_default ext4 defaults ................................................ 279.13 |
bcache io_default ext4 defaults ............................................. 686.32 |
lvm io_default ext4 data=writeback,noatime,barrier=0,discard ................ 771.73 |
bcache io_default ext4 data=writeback,noatime,barrier=0,discard ............. 1618.35 |
PostgreSQL pgbench 9.6.3
Scaling: Buffer Test - Test: Normal Load - Mode: Read Write
TPS > Higher Is Better
lvm io_default btrfs defaults ............................................... 300.23 |
bcache io_default btrfs defaults ............................................ 376.19 |
lvm io_default btrfs compress=lzo ........................................... 477.56 |
bcache io_default btrfs compress=lzo ........................................ 391.39 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............... 744.76 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............ 769.99 |
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum ................. 691.83 |
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum .............. 714.72 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag .... 704.48 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag . 793.59 |
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum .............. 825.14 |
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum ........... 756.62 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............... 870.78 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............ 802.34 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog ............... 157.50 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog ............ 96.84 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow ..... 201.42 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow .. 65.85 |
lvm io_default ext4 defaults ................................................ 245.41 |
bcache io_default ext4 defaults ............................................. 882.97 |
lvm io_default ext4 data=writeback,noatime,barrier=0,discard ................ 7796.79 |
bcache io_default ext4 data=writeback,noatime,barrier=0,discard ............. 4460.02 |
PostgreSQL pgbench 9.6.3
Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only
TPS > Higher Is Better
lvm io_default btrfs defaults ............................................... 20997.67 |
bcache io_default btrfs defaults ............................................ 20979.40 |
lvm io_default btrfs compress=lzo ........................................... 21043.97 |
bcache io_default btrfs compress=lzo ........................................ 21371.39 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............... 21176.86 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............ 21345.45 |
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum ................. 21042.27 |
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum .............. 21445.74 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag .... 20829.28 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag . 21525.05 |
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum .............. 20951.10 |
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum ........... 21489.61 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............... 20879.32 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............ 20863.27 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog ............... 21208.74 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog ............ 21151.75 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow ..... 21093.49 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow .. 21279.28 |
lvm io_default ext4 defaults ................................................ 21556.72 |
bcache io_default ext4 defaults ............................................. 21432.19 |
lvm io_default ext4 data=writeback,noatime,barrier=0,discard ................ 21474.24 |
bcache io_default ext4 data=writeback,noatime,barrier=0,discard ............. 21550.26 |
PostgreSQL pgbench 9.6.3
Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only
TPS > Higher Is Better
lvm io_default btrfs defaults ............................................... 22864.92 |
bcache io_default btrfs defaults ............................................ 441.94 |
lvm io_default btrfs compress=lzo ........................................... 10505.61 |
bcache io_default btrfs compress=lzo ........................................ 552.71 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............... 10887.11 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............ 626.15 |
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum ................. 8136.97 |
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum .............. 776.12 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag .... 8935.02 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag . 861.74 |
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum .............. 6063.60 |
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum ........... 2916.70 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............... 21463.91 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............ 472.32 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog ............... 8135.81 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog ............ 652.21 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow ..... 21537.01 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow .. 470.73 |
lvm io_default ext4 defaults ................................................ 417.58 |
bcache io_default ext4 defaults ............................................. 418.68 |
lvm io_default ext4 data=writeback,noatime,barrier=0,discard ................ 387.20 |
bcache io_default ext4 data=writeback,noatime,barrier=0,discard ............. 433.34 |
PostgreSQL pgbench 9.6.3
Scaling: Buffer Test - Test: Single Thread - Mode: Read Only
TPS > Higher Is Better
lvm io_default btrfs defaults ............................................... 23914.45 |
bcache io_default btrfs defaults ............................................ 24192.07 |
lvm io_default btrfs compress=lzo ........................................... 23859.96 |
bcache io_default btrfs compress=lzo ........................................ 24127.63 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............... 23829.40 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............ 24229.96 |
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum ................. 23658.49 |
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum .............. 24208.31 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag .... 23747.12 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag . 23874.24 |
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum .............. 23699.76 |
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum ........... 24073.67 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............... 23997.25 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............ 24067.91 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog ............... 23978.77 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog ............ 23938.98 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow ..... 23904.58 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow .. 24092.47 |
lvm io_default ext4 defaults ................................................ 23964.56 |
bcache io_default ext4 defaults ............................................. 24118.29 |
lvm io_default ext4 data=writeback,noatime,barrier=0,discard ................ 24119.68 |
bcache io_default ext4 data=writeback,noatime,barrier=0,discard ............. 24302.63 |
PostgreSQL pgbench 9.6.3
Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write
TPS > Higher Is Better
lvm io_default btrfs defaults ............................................... 115.24 |
bcache io_default btrfs defaults ............................................ 111.47 |
lvm io_default btrfs compress=lzo ........................................... 171.74 |
bcache io_default btrfs compress=lzo ........................................ 117.53 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............... 264.81 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............ 225.64 |
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum ................. 262.64 |
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum .............. 209.57 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag .... 248.26 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag . 215.30 |
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum .............. 263.07 |
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum ........... 201.78 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............... 361.22 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............ 214.49 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog ............... 66.49 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog ............ 39.38 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow ..... 66.82 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow .. 46.61 |
lvm io_default ext4 defaults ................................................ 135.04 |
bcache io_default ext4 defaults ............................................. 251.38 |
lvm io_default ext4 data=writeback,noatime,barrier=0,discard ................ 459.26 |
bcache io_default ext4 data=writeback,noatime,barrier=0,discard ............. 951.96 |
PostgreSQL pgbench 9.6.3
Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write
TPS > Higher Is Better
lvm io_default btrfs defaults ............................................... 682.19 |
bcache io_default btrfs defaults ............................................ 195.49 |
lvm io_default btrfs compress=lzo ........................................... 1082.41 |
bcache io_default btrfs compress=lzo ........................................ 217.77 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............... 1341.64 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............ 258.12 |
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum ................. 1308.29 |
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum .............. 293.57 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag .... 625.31 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag . 239.40 |
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum .............. 1551.38 |
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum ........... 467.98 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............... 1222.51 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............ 197.12 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog ............... 447.34 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog ............ 180.50 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow ..... 790.29 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow .. 164.73 |
lvm io_default ext4 defaults ................................................ 180.52 |
bcache io_default ext4 defaults ............................................. 196.92 |
lvm io_default ext4 data=writeback,noatime,barrier=0,discard ................ 212.19 |
bcache io_default ext4 data=writeback,noatime,barrier=0,discard ............. 304.93 |
PostgreSQL pgbench 9.6.3
Scaling: Buffer Test - Test: Single Thread - Mode: Read Write
TPS > Higher Is Better
lvm io_default btrfs defaults ............................................... 125.32 |
bcache io_default btrfs defaults ............................................ 126.84 |
lvm io_default btrfs compress=lzo ........................................... 171.73 |
bcache io_default btrfs compress=lzo ........................................ 143.84 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............... 288.41 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............ 285.55 |
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum ................. 288.42 |
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum .............. 269.88 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag .... 278.43 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag . 289.34 |
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum .............. 311.66 |
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum ........... 270.11 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............... 367.21 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............ 285.92 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog ............... 65.83 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog ............ 30.02 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow ..... 77.73 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow .. 32.78 |
lvm io_default ext4 defaults ................................................ 122.84 |
bcache io_default ext4 defaults ............................................. 302.40 |
lvm io_default ext4 data=writeback,noatime,barrier=0,discard ................ 2252.17 |
bcache io_default ext4 data=writeback,noatime,barrier=0,discard ............. 2160.69 |
PostgreSQL pgbench 9.6.3
Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only
TPS > Higher Is Better
lvm io_default btrfs defaults ............................................... 59083.32 |
bcache io_default btrfs defaults ............................................ 44878.87 |
lvm io_default btrfs compress=lzo ........................................... 57059.61 |
bcache io_default btrfs compress=lzo ........................................ 57826.54 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............... 55695.46 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............ 59553.10 |
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum ................. 53077.35 |
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum .............. 58727.96 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag .... 55526.16 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag . 58144.94 |
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum .............. 58797.71 |
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum ........... 57647.39 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............... 51754.71 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............ 23133.34 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog ............... 57908.50 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog ............ 57898.56 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow ..... 58442.00 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow .. 15179.52 |
lvm io_default ext4 defaults ................................................ 58106.86 |
bcache io_default ext4 defaults ............................................. 58360.52 |
lvm io_default ext4 data=writeback,noatime,barrier=0,discard ................ 59677.98 |
bcache io_default ext4 data=writeback,noatime,barrier=0,discard ............. 58564.96 |
PostgreSQL pgbench 9.6.3
Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only
TPS > Higher Is Better
lvm io_default btrfs defaults ............................................... 61212.91 |
bcache io_default btrfs defaults ............................................ 59583.66 |
lvm io_default btrfs compress=lzo ........................................... 61400.30 |
bcache io_default btrfs compress=lzo ........................................ 65558.26 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............... 64219.48 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............ 62967.07 |
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum ................. 62553.53 |
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum .............. 64438.64 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag .... 60428.81 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag . 60061.36 |
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum .............. 62527.74 |
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum ........... 63223.74 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............... 60854.15 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............ 64625.50 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog ............... 60263.15 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog ............ 61354.61 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow ..... 62560.36 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow .. 61428.74 |
lvm io_default ext4 defaults ................................................ 59202.29 |
bcache io_default ext4 defaults ............................................. 60508.18 |
lvm io_default ext4 data=writeback,noatime,barrier=0,discard ................ 59413.91 |
bcache io_default ext4 data=writeback,noatime,barrier=0,discard ............. 61830.83 |
PostgreSQL pgbench 9.6.3
Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write
TPS > Higher Is Better
lvm io_default btrfs defaults ............................................... 1004.38 |
bcache io_default btrfs defaults ............................................ 340.92 |
lvm io_default btrfs compress=lzo ........................................... 1795.59 |
bcache io_default btrfs compress=lzo ........................................ 903.65 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............... 2128.23 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............ 1141.40 |
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum ................. 2205.65 |
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum .............. 1162.39 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag .... 1753.10 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag . 1309.77 |
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum .............. 2317.44 |
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum ........... 1347.57 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............... 1880.67 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............ 695.35 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog ............... 666.53 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog ............ 398.44 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow ..... 881.87 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow .. 211.12 |
lvm io_default ext4 defaults ................................................ 321.34 |
bcache io_default ext4 defaults ............................................. 732.77 |
lvm io_default ext4 data=writeback,noatime,barrier=0,discard ................ 1022.22 |
bcache io_default ext4 data=writeback,noatime,barrier=0,discard ............. 1496.92 |
PostgreSQL pgbench 9.6.3
Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write
TPS > Higher Is Better
lvm io_default btrfs defaults ............................................... 428.94 |
bcache io_default btrfs defaults ............................................ 391.66 |
lvm io_default btrfs compress=lzo ........................................... 554.24 |
bcache io_default btrfs compress=lzo ........................................ 436.64 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............... 855.59 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum ............ 902.53 |
lvm io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum ................. 897.73 |
bcache io_tuned btrfs compress=lzo,discard,nobarrier,nodatasum .............. 798.86 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag .... 906.72 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatasum,autodefrag . 887.78 |
lvm io_default btrfs compress=zlib,discard,nobarrier,nodatasum .............. 933.81 |
bcache io_default btrfs compress=zlib,discard,nobarrier,nodatasum ........... 799.38 |
lvm io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............... 1068.65 |
bcache io_default btrfs compress=lzo,discard,nobarrier,nodatacow ............ 870.25 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog ............... 190.06 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog ............ 117.67 |
lvm io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow ..... 225.00 |
bcache io_default btrfs compress=lzo,discard,nobarrier,notreelog,nodatacow .. 100.28 |
lvm io_default ext4 defaults ................................................ 272.22 |
bcache io_default ext4 defaults ............................................. 651.34 |
lvm io_default ext4 data=writeback,noatime,barrier=0,discard ................ 5579.31 |
bcache io_default ext4 data=writeback,noatime,barrier=0,discard ............. 3689.62 |