postgresql Linux 6.10
Benchmarks for a future article.


Linux 6.10-rc1: 

	Processor: AMD Ryzen Threadripper 7980X 64-Cores @ 5.37GHz (64 Cores / 128 Threads), Motherboard: System76 Thelio Major (FA Z5 BIOS), Chipset: AMD Device 14a4, Memory: 4 x 32GB DDR5-4800MT/s Micron MTC20F1045S1RC48BA2, Disk: 1000GB CT1000T700SSD5, Graphics: AMD Radeon Pro W7900 45GB, Audio: AMD Device 14cc, Monitor: DELL P2415Q, Network: Aquantia AQC113C NBase-T/IEEE + Realtek RTL8125 2.5GbE + Intel Wi-Fi 6E

	OS: Ubuntu 24.04, Kernel: 6.10.0-061000rc1-generic (x86_64), Desktop: GNOME Shell 46.0, Display Server: X Server + Wayland, OpenGL: 4.6 Mesa 24.0.5-1ubuntu1 (LLVM 17.0.6 DRM 3.57), Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 1920x1200

Linux 6.9: 

	Processor: AMD Ryzen Threadripper 7980X 64-Cores @ 5.37GHz (64 Cores / 128 Threads), Motherboard: System76 Thelio Major (FA Z5 BIOS), Chipset: AMD Device 14a4, Memory: 4 x 32GB DDR5-4800MT/s Micron MTC20F1045S1RC48BA2, Disk: 1000GB CT1000T700SSD5, Graphics: AMD Radeon Pro W7900 45GB, Audio: AMD Device 14cc, Monitor: DELL P2415Q, Network: Aquantia AQC113C NBase-T/IEEE + Realtek RTL8125 2.5GbE + Intel Wi-Fi 6E

	OS: Ubuntu 24.04, Kernel: 6.9.0-060900-generic (x86_64), Desktop: GNOME Shell 46.0, Display Server: X Server + Wayland, OpenGL: 4.6 Mesa 24.0.5-1ubuntu1 (LLVM 17.0.6 DRM 3.57), Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 1920x1200


PostgreSQL 16
Scaling Factor: 100 - Clients: 1000 - Mode: Read Write
TPS > Higher Is Better
Linux 6.10-rc1 . 35382 |=======================================================
Linux 6.9 ...... 31878 |==================================================


PostgreSQL 16
Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency
ms < Lower Is Better
Linux 6.10-rc1 . 28.32 |==================================================
Linux 6.9 ...... 31.38 |=======================================================


PostgreSQL 16
Scaling Factor: 100 - Clients: 250 - Mode: Read Write
TPS > Higher Is Better
Linux 6.10-rc1 . 34537 |=======================================================
Linux 6.9 ...... 32523 |====================================================


PostgreSQL 16
Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency
ms < Lower Is Better
Linux 6.10-rc1 . 7.250 |====================================================
Linux 6.9 ...... 7.688 |=======================================================


PostgreSQL 16
Scaling Factor: 100 - Clients: 800 - Mode: Read Write
TPS > Higher Is Better
Linux 6.10-rc1 . 35262 |=======================================================
Linux 6.9 ...... 33445 |====================================================


PostgreSQL 16
Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency
ms < Lower Is Better
Linux 6.10-rc1 . 22.69 |====================================================
Linux 6.9 ...... 23.92 |=======================================================


PostgreSQL 16
Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average Latency
ms < Lower Is Better
Linux 6.10-rc1 . 40.45 |=====================================================
Linux 6.9 ...... 42.06 |=======================================================


PostgreSQL 16
Scaling Factor: 1000 - Clients: 800 - Mode: Read Write
TPS > Higher Is Better
Linux 6.10-rc1 . 19784 |=======================================================
Linux 6.9 ...... 19025 |=====================================================


PostgreSQL 16
Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency
ms < Lower Is Better
Linux 6.10-rc1 . 0.066 |=======================================================
Linux 6.9 ...... 0.065 |======================================================


PostgreSQL 16
Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average Latency
ms < Lower Is Better
Linux 6.10-rc1 . 0.388 |=======================================================
Linux 6.9 ...... 0.383 |======================================================


PostgreSQL 16
Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only
TPS > Higher Is Better
Linux 6.10-rc1 . 2013769 |====================================================
Linux 6.9 ...... 2038672 |=====================================================


PostgreSQL 16
Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latency
ms < Lower Is Better
Linux 6.10-rc1 . 0.496 |=======================================================
Linux 6.9 ...... 0.490 |======================================================


PostgreSQL 16
Scaling Factor: 100 - Clients: 250 - Mode: Read Only
TPS > Higher Is Better
Linux 6.10-rc1 . 3780123 |====================================================
Linux 6.9 ...... 3825454 |=====================================================


PostgreSQL 16
Scaling Factor: 1000 - Clients: 800 - Mode: Read Only
TPS > Higher Is Better
Linux 6.10-rc1 . 2064612 |====================================================
Linux 6.9 ...... 2086199 |=====================================================


PostgreSQL 16
Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency
ms < Lower Is Better
Linux 6.10-rc1 . 0.209 |=======================================================
Linux 6.9 ...... 0.207 |======================================================


PostgreSQL 16
Scaling Factor: 100 - Clients: 800 - Mode: Read Only
TPS > Higher Is Better
Linux 6.10-rc1 . 3830814 |=====================================================
Linux 6.9 ...... 3865170 |=====================================================


PostgreSQL 16
Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency
ms < Lower Is Better
Linux 6.10-rc1 . 50.47 |=======================================================
Linux 6.9 ...... 50.72 |=======================================================


PostgreSQL 16
Scaling Factor: 100 - Clients: 1000 - Mode: Read Only
TPS > Higher Is Better
Linux 6.10-rc1 . 3833536 |=====================================================
Linux 6.9 ...... 3815568 |=====================================================


PostgreSQL 16
Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latency
ms < Lower Is Better
Linux 6.10-rc1 . 0.261 |=======================================================
Linux 6.9 ...... 0.262 |=======================================================


PostgreSQL 16
Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write
TPS > Higher Is Better
Linux 6.10-rc1 . 19813 |=======================================================
Linux 6.9 ...... 19759 |=======================================================


PostgreSQL 16
Scaling Factor: 1000 - Clients: 250 - Mode: Read Only
TPS > Higher Is Better
Linux 6.10-rc1 . 2489525 |=====================================================
Linux 6.9 ...... 2488906 |=====================================================


PostgreSQL 16
Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency
ms < Lower Is Better
Linux 6.10-rc1 . 0.101 |=======================================================
Linux 6.9 ...... 0.101 |=======================================================


PostgreSQL 16
Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency
ms < Lower Is Better
Linux 6.10-rc1 . 12.67 |====================================================
Linux 6.9 ...... 13.38 |=======================================================


PostgreSQL 16
Scaling Factor: 1000 - Clients: 250 - Mode: Read Write
TPS > Higher Is Better
Linux 6.10-rc1 . 19868 |=======================================================
Linux 6.9 ...... 18693 |====================================================