Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 1706295-ASVA-170624683
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","2017-06-28 19:59"
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)
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
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
Memory,,2048MB,2048MB,2048MB,2048MB,2048MB,2048MB,2048MB,2048MB,2048MB,2048MB,2048MB,2048MB,2048MB,2048MB,2048MB,2048MB,2048MB,2048MB,2048MB,2048MB,2048MB,2048MB,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 SSDSC2BW24 + 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
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
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
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)
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
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
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","2017-06-28 19:59"
"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,989.50
"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,167.13
"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,191.60
"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,93307.23
"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,31.15
"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,93604.64
"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,445.39
"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,328.59
"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,22456.10
"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,8236.50
"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,22705.40
"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,35.82
"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,495.86
"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,33.00
"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,84719.68
"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,86173.55
"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,928.77
"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,657.03