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
PostgreSQL 11.0 Benchmarks
PostgreSQL 11.0 benchmarks including of new LLVM JIT. Benchmarks by Michael Larabel.
PostgreSQL 10.5:
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
OS: Ubuntu 18.10, Kernel: 4.18.0-8-generic (x86_64), Compiler: GCC 8.2.0, File-System: ext4, Screen Resolution: 1600x1200
PostgreSQL 11.0:
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
OS: Ubuntu 18.10, Kernel: 4.18.0-8-generic (x86_64), Compiler: GCC 8.2.0, File-System: ext4, Screen Resolution: 1600x1200
PostgreSQL 11.0 + LLVM JIT:
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
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
PostgreSQL pgbench
Test: Normal Load - Mode: Read Only
TPS > Higher Is Better
PostgreSQL 10.5 ............ 530485 |=========================================
PostgreSQL 11.0 ............ 537465 |==========================================
PostgreSQL 11.0 + LLVM JIT . 538269 |==========================================
PostgreSQL pgbench
Test: Normal Load - Mode: Read Write
TPS > Higher Is Better
PostgreSQL 10.5 ............ 5396 |==========================================
PostgreSQL 11.0 ............ 5473 |==========================================
PostgreSQL 11.0 + LLVM JIT . 5677 |============================================
PostgreSQL pgbench
Test: Single Thread - Mode: Read Only
TPS > Higher Is Better
PostgreSQL 10.5 ............ 14941 |=========================================
PostgreSQL 11.0 ............ 15411 |==========================================
PostgreSQL 11.0 + LLVM JIT . 15685 |===========================================
PostgreSQL pgbench
Test: Single Thread - Mode: Read Write
TPS > Higher Is Better
PostgreSQL 10.5 ............ 1150 |===========================================
PostgreSQL 11.0 ............ 1142 |===========================================
PostgreSQL 11.0 + LLVM JIT . 1174 |============================================