PostgreSQL 10 Beta Benchmarking
Some early benchmarks of PostgreSQL 10 Beta 1. Tests by Michael Larabel


PostgreSQL 9.6.3: 

	Processor: Intel Xeon E3-1280 v5 @ 4.00GHz (8 Cores), Motherboard: MSI C236A WORKSTATION (MS-7998) v1.0, Chipset: Intel Sky Lake, Memory: 16384MB, Disk: 256GB TOSHIBA-RD400, Graphics: Sapphire AMD POLARIS10 4096MB, Audio: Realtek ALC1150, Monitor: DELL P2415Q, Network: Intel Connection

	OS: Ubuntu 16.04, Kernel: 4.12.0-999-generic (x86_64) 20170517, Desktop: Unity 7.4.0, Display Server: X Server 1.18.4, Display Driver: modesetting 1.18.4, OpenGL: 4.5 Mesa 17.2.0-devel- padoka PPA Gallium 0.4 (LLVM 5.0.0), Vulkan: 1.0.21, Compiler: GCC 5.4.0 20160609, File-System: ext4, Screen Resolution: 3840x2160

PostgreSQL 10.0 Beta 1: 

	Processor: Intel Xeon E3-1280 v5 @ 4.00GHz (8 Cores), Motherboard: MSI C236A WORKSTATION (MS-7998) v1.0, Chipset: Intel Sky Lake, Memory: 16384MB, Disk: 256GB TOSHIBA-RD400, Graphics: Sapphire AMD POLARIS10 4096MB, Audio: Realtek ALC1150, Monitor: DELL P2415Q, Network: Intel Connection

	OS: Ubuntu 16.04, Kernel: 4.12.0-999-generic (x86_64) 20170517, Desktop: Unity 7.4.0, Display Server: X Server 1.18.4, Display Driver: modesetting 1.18.4, OpenGL: 4.5 Mesa 17.2.0-devel- padoka PPA Gallium 0.4 (LLVM 5.0.0), Vulkan: 1.0.21, Compiler: GCC 5.4.0 20160609, File-System: ext4, Screen Resolution: 3840x2160


PostgreSQL pgbench
Scaling: On-Disk - Test: Normal Load - Mode: Read Only
TPS > Higher Is Better
PostgreSQL 9.6.3 ....... 185598.27 |===========================================
PostgreSQL 10.0 Beta 1 . 184213.98 |===========================================


PostgreSQL pgbench
Scaling: On-Disk - Test: Normal Load - Mode: Read Write
TPS > Higher Is Better
PostgreSQL 9.6.3 ....... 1194.17 |=======================================
PostgreSQL 10.0 Beta 1 . 1391.65 |=============================================


PostgreSQL pgbench
Scaling: Buffer Test - Test: Normal Load - Mode: Read Only
TPS > Higher Is Better
PostgreSQL 9.6.3 ....... 126711.14 |===========================================
PostgreSQL 10.0 Beta 1 . 120952.24 |=========================================


PostgreSQL pgbench
Scaling: Buffer Test - Test: Normal Load - Mode: Read Write
TPS > Higher Is Better
PostgreSQL 9.6.3 ....... 1657.06 |================================
PostgreSQL 10.0 Beta 1 . 2326.75 |=============================================


PostgreSQL pgbench
Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only
TPS > Higher Is Better
PostgreSQL 9.6.3 ....... 157553.04 |=======================================
PostgreSQL 10.0 Beta 1 . 172121.85 |===========================================


PostgreSQL pgbench
Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write
TPS > Higher Is Better
PostgreSQL 9.6.3 ....... 1190.23 |=======================================
PostgreSQL 10.0 Beta 1 . 1377.40 |=============================================


PostgreSQL pgbench
Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only
TPS > Higher Is Better
PostgreSQL 9.6.3 ....... 117563.06 |===========================================
PostgreSQL 10.0 Beta 1 . 115252.14 |==========================================


PostgreSQL pgbench
Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write
TPS > Higher Is Better
PostgreSQL 9.6.3 ....... 2734.09 |==========================================
PostgreSQL 10.0 Beta 1 . 2897.34 |=============================================