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

PG10_11_JIT_20190305: 

	Processor: Intel Xeon E5-2630 v4 (8 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (rel-1.11.0-0-g63451fca13-prebuilt.qemu-project.org BIOS), Memory: 30720MB, Disk: 859GB QEMU HDD, Graphics: EFI VGA

	OS: Clear Linux OS 27600, Kernel: 4.18.0-10-generic (x86_64), Compiler: GCC 8.2.1 20180502 + Clang 7.0.1 + LLVM 7.0.1, File-System: overlayfs, Screen Resolution: 800x600, System Layer: KVM


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 |==========================================
PG10_11_JIT_20190305 ....... 45635  |====


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 |============================================
PG10_11_JIT_20190305 ....... 4805 |=====================================


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 |===========================================
PG10_11_JIT_20190305 ....... 8434  |=======================


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 |============================================
PG10_11_JIT_20190305 ....... 898  |==================================