PostgreSQL 11.0 benchmarks including of new LLVM JIT. Benchmarks by Michael Larabel.
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 1810191-SK-POSTGRESQ55
{
"title": "PostgreSQL 11.0 Benchmarks",
"last_modified": "2018-10-19 14:00:54",
"description": "PostgreSQL 11.0 benchmarks including of new LLVM JIT. Benchmarks by Michael Larabel.",
"systems": {
"PostgreSQL 10.5": {
"identifier": "PostgreSQL 10.5",
"hardware": {
"Processor": "2 x AMD EPYC 7601 32-Core @ 3.05GHz (64 Cores \/ 128 Threads)",
"Motherboard": "Dell 02MJ3T (1.2.5 BIOS)",
"Chipset": "AMD Family 17h",
"Memory": "516096MB",
"Disk": "20 x 500GB Samsung SSD 860 + 120GB SSDSCKJB120G7R",
"Graphics": "Matrox Matrox G200eW3",
"Monitor": "VE228",
"Network": "Broadcom and subsidiaries BCM57416 NetXtreme-E Dual-Media 10G RDMA"
},
"software": {
"OS": "Ubuntu 18.10",
"Kernel": "4.18.0-8-generic (x86_64)",
"Compiler": "GCC 8.2.0",
"File-System": "ext4",
"Screen Resolution": "1600x1200"
},
"user": "phoronix",
"timestamp": "2018-10-18 11:12:52",
"data": {
"compiler-configuration": "--build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic --without-cuda-driver -v",
"security": "__user pointer sanitization + Full AMD retpoline IBPB + SSB disabled via prctl and seccomp"
}
},
"PostgreSQL 11.0": {
"identifier": "PostgreSQL 11.0",
"hardware": {
"Processor": "2 x AMD EPYC 7601 32-Core @ 3.11GHz (64 Cores \/ 128 Threads)",
"Motherboard": "Dell 02MJ3T (1.2.5 BIOS)",
"Chipset": "AMD Family 17h",
"Memory": "516096MB",
"Disk": "20 x 500GB Samsung SSD 860 + 120GB SSDSCKJB120G7R",
"Graphics": "Matrox Matrox G200eW3",
"Monitor": "VE228",
"Network": "Broadcom and subsidiaries BCM57416 NetXtreme-E Dual-Media 10G RDMA"
},
"software": {
"OS": "Ubuntu 18.10",
"Kernel": "4.18.0-8-generic (x86_64)",
"Compiler": "GCC 8.2.0",
"File-System": "ext4",
"Screen Resolution": "1600x1200"
},
"user": "phoronix",
"timestamp": "2018-10-18 17:54:18",
"data": {
"compiler-configuration": "--build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic --without-cuda-driver -v",
"security": "__user pointer sanitization + Full AMD retpoline IBPB + SSB disabled via prctl and seccomp"
}
},
"PostgreSQL 11.0 + LLVM JIT": {
"identifier": "PostgreSQL 11.0 + LLVM JIT",
"hardware": {
"Processor": "2 x AMD EPYC 7601 32-Core @ 3.13GHz (64 Cores \/ 128 Threads)",
"Motherboard": "Dell 02MJ3T (1.2.5 BIOS)",
"Chipset": "AMD Family 17h",
"Memory": "516096MB",
"Disk": "20 x 500GB Samsung SSD 860 + 120GB SSDSCKJB120G7R",
"Graphics": "Matrox Matrox G200eW3",
"Monitor": "VE228",
"Network": "Broadcom and subsidiaries BCM57416 NetXtreme-E Dual-Media 10G RDMA"
},
"software": {
"OS": "Ubuntu 18.10",
"Kernel": "4.18.0-8-generic (x86_64)",
"Compiler": "GCC 8.2.0 + LLVM 7.0.0",
"File-System": "ext4",
"Screen Resolution": "1600x1200"
},
"user": "phoronix",
"timestamp": "2018-10-19 11:39:09",
"data": {
"compiler-configuration": "--build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic --without-cuda-driver -v",
"security": "__user pointer sanitization + Full AMD retpoline IBPB + SSB disabled via prctl and seccomp"
}
}
},
"results": {
"cdb994d38ee92b568f379be1fe313e52dfd33068": {
"identifier": "pts\/pgbench-1.8.5",
"title": "PostgreSQL pgbench",
"arguments": "BUFFER_TEST NORMAL_LOAD READ_ONLY",
"description": "Test: Normal Load - Mode: Read Only",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"PostgreSQL 10.5": {
"value": 530485,
"raw_values": [
527303.917205999954603612422943115234375,
526607.35879299999214708805084228515625,
537545.147213999996893107891082763671875
],
"test_run_times": [
701.3400000000000318323145620524883270263671875,
685.1399999999999863575794734060764312744140625,
689.740000000000009094947017729282379150390625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm"
}
}
},
"PostgreSQL 11.0": {
"value": 537465,
"raw_values": [
535114.28623399999924004077911376953125,
550322.0045300000347197055816650390625,
526957.42566399998031556606292724609375
],
"test_run_times": [
683.48000000000001818989403545856475830078125,
669.700000000000045474735088646411895751953125,
669.779999999999972715158946812152862548828125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm"
}
}
},
"PostgreSQL 11.0 + LLVM JIT": {
"value": 538269,
"raw_values": [
528570.02152499998919665813446044921875,
541566.217668000026606023311614990234375,
544669.63729300000704824924468994140625
],
"test_run_times": [
695.1399999999999863575794734060764312744140625,
679,
680.5800000000000409272615797817707061767578125
],
"details": {
"compiler-options": {
"compiler-type": "CXX",
"compiler": "g++",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -fPIC -shared -lLLVM-7"
}
}
}
}
},
"609de1845f027db70e29f296d0ec09eb3cf4b46a": {
"identifier": "pts\/pgbench-1.8.5",
"title": "PostgreSQL pgbench",
"arguments": "BUFFER_TEST NORMAL_LOAD READ_WRITE",
"description": "Test: Normal Load - Mode: Read Write",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"PostgreSQL 10.5": {
"value": 5396,
"raw_values": [
5426.71206499999971129000186920166015625,
5349.559333999999580555595457553863525390625,
5410.4375140000001920270733535289764404296875
],
"test_run_times": [
693.8600000000000136424205265939235687255859375,
691.8899999999999863575794734060764312744140625,
710.470000000000027284841053187847137451171875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm"
}
}
},
"PostgreSQL 11.0": {
"value": 5473,
"raw_values": [
5514.2401550000004135654307901859283447265625,
5584.6533190000000104191713035106658935546875,
5319.8355110000002241577021777629852294921875
],
"test_run_times": [
677.1499999999999772626324556767940521240234375,
683.8999999999999772626324556767940521240234375,
681.8400000000000318323145620524883270263671875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm"
}
}
},
"PostgreSQL 11.0 + LLVM JIT": {
"value": 5677,
"raw_values": [
5595.1878559999995559337548911571502685546875,
5650.8339359999999942374415695667266845703125,
5783.7652630000002318411134183406829833984375
],
"test_run_times": [
682.1599999999999681676854379475116729736328125,
680.1599999999999681676854379475116729736328125,
695.9099999999999681676854379475116729736328125
],
"details": {
"compiler-options": {
"compiler-type": "CXX",
"compiler": "g++",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -fPIC -shared -lLLVM-7"
}
}
}
}
},
"eae897284d51dab04c8ec33c8ba0a59a901a5d56": {
"identifier": "pts\/pgbench-1.8.5",
"title": "PostgreSQL pgbench",
"arguments": "BUFFER_TEST SINGLE_THREAD READ_ONLY",
"description": "Test: Single Thread - Mode: Read Only",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"PostgreSQL 10.5": {
"value": 14941,
"raw_values": [
15281.691346999999950639903545379638671875,
14745.1645869999993010424077510833740234375,
14794.98236399999950663186609745025634765625
],
"test_run_times": [
688.94000000000005456968210637569427490234375,
697.01999999999998181010596454143524169921875,
707.5900000000000318323145620524883270263671875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm"
}
}
},
"PostgreSQL 11.0": {
"value": 15411,
"raw_values": [
15358.50654399999984889291226863861083984375,
14683.644904999999198480509221553802490234375,
15746.4379310000003897584974765777587890625,
15854.709956999999121762812137603759765625
],
"test_run_times": [
693.0900000000000318323145620524883270263671875,
678.1699999999999590727384202182292938232421875,
673.4600000000000363797880709171295166015625,
674.8500000000000227373675443232059478759765625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm"
}
}
},
"PostgreSQL 11.0 + LLVM JIT": {
"value": 15685,
"raw_values": [
15705.35061499999937950633466243743896484375,
15669.3544320000000880099833011627197265625,
15681.16225499999927706085145473480224609375
],
"test_run_times": [
695.4199999999999590727384202182292938232421875,
676.200000000000045474735088646411895751953125,
679.299999999999954525264911353588104248046875
],
"details": {
"compiler-options": {
"compiler-type": "CXX",
"compiler": "g++",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -fPIC -shared -lLLVM-7"
}
}
}
}
},
"51d02511935e15d53bf8ef932945808e49947163": {
"identifier": "pts\/pgbench-1.8.5",
"title": "PostgreSQL pgbench",
"arguments": "BUFFER_TEST SINGLE_THREAD READ_WRITE",
"description": "Test: Single Thread - Mode: Read Write",
"scale": "TPS",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"PostgreSQL 10.5": {
"value": 1150,
"raw_values": [
1165.65472300000010363874025642871856689453125,
1169.607565000000022337189875543117523193359375,
1114.66681500000004234607331454753875732421875
],
"test_run_times": [
686.0399999999999636202119290828704833984375,
688.8799999999999954525264911353588104248046875,
692.490000000000009094947017729282379150390625
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm"
}
}
},
"PostgreSQL 11.0": {
"value": 1142,
"raw_values": [
1086.655187999999952808138914406299591064453125,
1133.4889180000000123982317745685577392578125,
1181.56001900000001114676706492900848388671875,
1162.38914599999998245039023458957672119140625,
1145.329809999999952196958474814891815185546875
],
"test_run_times": [
666.3200000000000500222085975110530853271484375,
687.509999999999990905052982270717620849609375,
670.4299999999999499777914024889469146728515625,
673.6599999999999681676854379475116729736328125,
693.01999999999998181010596454143524169921875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm"
}
}
},
"PostgreSQL 11.0 + LLVM JIT": {
"value": 1174,
"raw_values": [
1198.71686300000010305666364729404449462890625,
1157.656118000000105894287116825580596923828125,
1165.279154000000062296749092638492584228515625
],
"test_run_times": [
673.3200000000000500222085975110530853271484375,
676.69000000000005456968210637569427490234375,
687.4600000000000363797880709171295166015625
],
"details": {
"compiler-options": {
"compiler-type": "CXX",
"compiler": "g++",
"compiler-options": "-fno-strict-aliasing -fwrapv -O2 -fPIC -shared -lLLVM-7"
}
}
}
}
}
}
}