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 |============================================