try to find the best setup for postgres over the dm-cache-bcache-btrfs-zfs field

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

Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Additional Graphs

Show Perf Per Core/Thread Calculation Graphs Where Applicable
Show Perf Per Clock Calculation Graphs Where Applicable

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Only show results where is faster than

Only show results matching title/arguments (delimit multiple options with a comma):

Do not show results matching title/arguments (delimit multiple options with a comma):

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