homelab-postgres

VMware testing on Microsoft Windows 10 Pro Build 19045 via the Phoronix Test Suite.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2211182-NE-HOMELABPO08
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Disable Color Branding
Prefer Vertical Bar Graphs

Additional Graphs

Show Perf Per Core/Thread Calculation Graphs Where Applicable

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
homelab postgres
November 18 2022
 
Chris
November 18 2022
 
2 x AMD Ryzen 9 5950X 16-Core - VMware SVGA 3D 2GB -
November 18 2022
 
Chris VM
November 18 2022
  27 Minutes
Invert Hiding All Results Option
  7 Minutes

Only show results where is faster than
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):

homelab postgres

Security Notes: __user pointer sanitization: Disabled + Retpoline: Full + IBPB: Always + VBS: Disabled

Chris

Processor: 2 x AMD Ryzen 9 5950X 16-Core @ 3.40GHz (4 Cores), Motherboard: Intel 440BX (VMW71.00V.18452719.B64.2108091906 BIOS), Memory: 8192 + 2048 + 1024 + 128 + 64 + 32 + 8 + 4 0MHz, Disk: 300GB VMware Virtual NVMe Disk + 1048576GB StorLib Virtual Storage, Graphics: VMware SVGA 3D 2GB, Audio: HD Audio Device, Network: Intel 82574L Gigabit Connection

OS: Microsoft Windows 10 Pro Build 19045, Kernel: 10.0.19045.2251 (x86_64), Display Driver: 8.17.3.5, File-System: NTFS, Screen Resolution: 1920x1200, System Layer: VMware

2 x AMD Ryzen 9 5950X 16-Core - VMware SVGA 3D 2GB -

Chris VM

Processor: 2 x AMD Ryzen 9 5950X 16-Core @ 3.40GHz (8 Cores), Motherboard: Intel 440BX (VMW71.00V.18452719.B64.2108091906 BIOS), Memory: 8192 + 4096 + 2048 + 128 + 32 + 4 0MHz, Disk: 300GB VMware Virtual NVMe Disk + 1048576GB StorLib Virtual Storage, Graphics: VMware SVGA 3D 2GB, Audio: HD Audio Device, Network: Intel 82574L Gigabit Connection

OS: Microsoft Windows 10 Pro Build 19045, Kernel: 10.0.19045.2311 (x86_64), Display Driver: 8.17.3.5, File-System: NTFS, Screen Resolution: 1920x1200, System Layer: VMware

homelab-postgresProcessorMotherboardMemoryDiskGraphicsAudioNetworkOSKernelDisplay DriverFile-SystemScreen ResolutionSystem Layerhomelab postgresChris2 x AMD Ryzen 9 5950X 16-Core - VMware SVGA 3D 2GB -Chris VM2 x AMD Ryzen 9 5950X 16-Core @ 3.40GHz (4 Cores)Intel 440BX (VMW71.00V.18452719.B64.2108091906 BIOS)8192 + 2048 + 1024 + 128 + 64 + 32 + 8 + 4 0MHz300GB VMware Virtual NVMe Disk + 1048576GB StorLib Virtual StorageVMware SVGA 3D 2GBHD Audio DeviceIntel 82574L Gigabit ConnectionMicrosoft Windows 10 Pro Build 1904510.0.19045.2251 (x86_64)8.17.3.5NTFS1920x1200VMware2 x AMD Ryzen 9 5950X 16-Core @ 3.40GHz (8 Cores)8192 + 4096 + 2048 + 128 + 32 + 4 0MHz10.0.19045.2311 (x86_64)OpenBenchmarking.orgSecurity Details- __user pointer sanitization: Disabled + Retpoline: Full + IBPB: Always + VBS: Disabled

homelab-postgrespgbench: 1 - 1 - Read Onlypgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Write - Average Latencyhomelab postgresChris2 x AMD Ryzen 9 5950X 16-Core - VMware SVGA 3D 2GB -Chris VM59150.1696821.467OpenBenchmarking.org

PostgreSQL

This is a benchmark of PostgreSQL using the integrated pgbench for facilitating the database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read OnlyChris VM13002600390052006500SE +/- 45.59, N = 35915

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average LatencyChris VM0.0380.0760.1140.1520.19SE +/- 0.001, N = 30.169

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read WriteChris VM150300450600750SE +/- 8.72, N = 3682

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average LatencyChris VM0.33010.66020.99031.32041.6505SE +/- 0.019, N = 31.467

homelab postgres

Security Notes: __user pointer sanitization: Disabled + Retpoline: Full + IBPB: Always + VBS: Disabled

Testing initiated at 18 November 2022 03:21 by user Sandbox.

Chris

Processor: 2 x AMD Ryzen 9 5950X 16-Core @ 3.40GHz (4 Cores), Motherboard: Intel 440BX (VMW71.00V.18452719.B64.2108091906 BIOS), Memory: 8192 + 2048 + 1024 + 128 + 64 + 32 + 8 + 4 0MHz, Disk: 300GB VMware Virtual NVMe Disk + 1048576GB StorLib Virtual Storage, Graphics: VMware SVGA 3D 2GB, Audio: HD Audio Device, Network: Intel 82574L Gigabit Connection

OS: Microsoft Windows 10 Pro Build 19045, Kernel: 10.0.19045.2251 (x86_64), Display Driver: 8.17.3.5, File-System: NTFS, Screen Resolution: 1920x1200, System Layer: VMware

Security Notes: __user pointer sanitization: Disabled + Retpoline: Full + IBPB: Always + VBS: Disabled

Testing initiated at 18 November 2022 03:22 by user Sandbox.

2 x AMD Ryzen 9 5950X 16-Core - VMware SVGA 3D 2GB -

Security Notes: __user pointer sanitization: Disabled + Retpoline: Full + IBPB: Always + VBS: Disabled

Testing initiated at 18 November 2022 03:32 by user Sandbox.

Chris VM

Processor: 2 x AMD Ryzen 9 5950X 16-Core @ 3.40GHz (8 Cores), Motherboard: Intel 440BX (VMW71.00V.18452719.B64.2108091906 BIOS), Memory: 8192 + 4096 + 2048 + 128 + 32 + 4 0MHz, Disk: 300GB VMware Virtual NVMe Disk + 1048576GB StorLib Virtual Storage, Graphics: VMware SVGA 3D 2GB, Audio: HD Audio Device, Network: Intel 82574L Gigabit Connection

OS: Microsoft Windows 10 Pro Build 19045, Kernel: 10.0.19045.2311 (x86_64), Display Driver: 8.17.3.5, File-System: NTFS, Screen Resolution: 1920x1200, System Layer: VMware

Security Notes: __user pointer sanitization: Disabled + Retpoline: Full + IBPB: Always + VBS: Disabled

Testing initiated at 18 November 2022 03:54 by user Sandbox.