debian-pgbench-3

VMware testing on Debian 10 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2012042-RGPO-DEBIANP39.

debian-pgbench-3ProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerCompilerFile-SystemScreen ResolutionSystem LayerAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BXAMD Ryzen 5 4600H (1 Core)Intel 440BX (6.00 BIOS)Intel 440BX/ZX/DX2048MB21GB VMware Virtual SVMware SVGA IIEnsoniq ES1371/ES1373Intel 82545EMDebian 104.19.0-12-amd64 (x86_64)GNOME Shell 3.30.2X Server + WaylandGCC 8.3.0ext42048x2048VMwareOpenBenchmarking.org- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic --without-cuda-driver -v - CPU Microcode: 0x8600104- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline IBPB: conditional STIBP: disabled RSB filling + srbds: Not affected + tsx_async_abort: Not affected

debian-pgbench-3pgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Write - Average Latencypgbench: 1 - 50 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 100 - 1 - Read Writepgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average LatencyAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX22580.443102548.80215440.648153232.645OpenBenchmarking.org

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 1 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read WriteAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX5001000150020002500SE +/- 30.11, N = 422581. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average LatencyAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX0.09970.19940.29910.39880.4985SE +/- 0.006, N = 40.4431. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

PostgreSQL pgbench

CPU Usage (Summary) Monitor

OpenBenchmarking.orgPercent, Fewer Is BetterPostgreSQL pgbench 13.0CPU Usage (Summary) MonitorAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX0.8821.7642.6463.5284.413.92

PostgreSQL pgbench

Drive Read Speed (sda) Monitor

MinAvgMaxAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX0.00.00.2OpenBenchmarking.orgMB/s, Fewer Is BetterPostgreSQL pgbench 13.0Drive Read Speed (sda) Monitor0.06470.12940.19410.25880.3235

PostgreSQL pgbench

Drive Write Speed (sda) Monitor

MinAvgMaxAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX0.010.131.6OpenBenchmarking.orgMB/s, Fewer Is BetterPostgreSQL pgbench 13.0Drive Write Speed (sda) Monitor918273645

PostgreSQL pgbench

Memory Usage Monitor

MinAvgMaxAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX680684686OpenBenchmarking.orgMegabytes, Fewer Is BetterPostgreSQL pgbench 13.0Memory Usage Monitor2004006008001000

PostgreSQL pgbench

Swap Usage Monitor

MinAvgMaxAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX9.09.610.0OpenBenchmarking.orgMegabytes, Fewer Is BetterPostgreSQL pgbench 13.0Swap Usage Monitor48121620

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read WriteAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX2004006008001000SE +/- 16.05, N = 310251. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average LatencyAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX1122334455SE +/- 0.75, N = 348.801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

PostgreSQL pgbench

CPU Usage (Summary) Monitor

OpenBenchmarking.orgPercent, Fewer Is BetterPostgreSQL pgbench 13.0CPU Usage (Summary) MonitorAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX0.8821.7642.6463.5284.413.92

PostgreSQL pgbench

Drive Write Speed (sda) Monitor

MinAvgMaxAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX0.05.427.6OpenBenchmarking.orgMB/s, Fewer Is BetterPostgreSQL pgbench 13.0Drive Write Speed (sda) Monitor816243240

PostgreSQL pgbench

Memory Usage Monitor

MinAvgMaxAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX683717751OpenBenchmarking.orgMegabytes, Fewer Is BetterPostgreSQL pgbench 13.0Memory Usage Monitor2004006008001000

PostgreSQL pgbench

Swap Usage Monitor

OpenBenchmarking.orgMegabytes, Fewer Is BetterPostgreSQL pgbench 13.0Swap Usage MonitorAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX36912159

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 1 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 1 - Mode: Read WriteAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX30060090012001500SE +/- 5.27, N = 315441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average LatencyAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX0.14580.29160.43740.58320.729SE +/- 0.002, N = 30.6481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

PostgreSQL pgbench

CPU Usage (Summary) Monitor

OpenBenchmarking.orgPercent, Fewer Is BetterPostgreSQL pgbench 13.0CPU Usage (Summary) MonitorAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX0.8821.7642.6463.5284.413.92

PostgreSQL pgbench

Drive Read Speed (sda) Monitor

MinAvgMaxAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX0.028.4226.7OpenBenchmarking.orgMB/s, Fewer Is BetterPostgreSQL pgbench 13.0Drive Read Speed (sda) Monitor60120180240300

PostgreSQL pgbench

Drive Write Speed (sda) Monitor

MinAvgMaxAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX0.099.5321.6OpenBenchmarking.orgMB/s, Fewer Is BetterPostgreSQL pgbench 13.0Drive Write Speed (sda) Monitor80160240320400

PostgreSQL pgbench

Memory Usage Monitor

MinAvgMaxAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX516638743OpenBenchmarking.orgMegabytes, Fewer Is BetterPostgreSQL pgbench 13.0Memory Usage Monitor2004006008001000

PostgreSQL pgbench

Swap Usage Monitor

MinAvgMaxAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX9.078.3202.0OpenBenchmarking.orgMegabytes, Fewer Is BetterPostgreSQL pgbench 13.0Swap Usage Monitor50100150200250

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 50 - Mode: Read WriteAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX30060090012001500SE +/- 11.72, N = 315321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average LatencyAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX816243240SE +/- 0.25, N = 332.651. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

PostgreSQL pgbench

CPU Usage (Summary) Monitor

OpenBenchmarking.orgPercent, Fewer Is BetterPostgreSQL pgbench 13.0CPU Usage (Summary) MonitorAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX0.8821.7642.6463.5284.413.92

PostgreSQL pgbench

Drive Read Speed (sda) Monitor

MinAvgMaxAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX0.027.6217.5OpenBenchmarking.orgMB/s, Fewer Is BetterPostgreSQL pgbench 13.0Drive Read Speed (sda) Monitor60120180240300

PostgreSQL pgbench

Drive Write Speed (sda) Monitor

MinAvgMaxAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX0.095.0267.9OpenBenchmarking.orgMB/s, Fewer Is BetterPostgreSQL pgbench 13.0Drive Write Speed (sda) Monitor70140210280350

PostgreSQL pgbench

Memory Usage Monitor

MinAvgMaxAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX373.0477.1556.0OpenBenchmarking.orgMegabytes, Fewer Is BetterPostgreSQL pgbench 13.0Memory Usage Monitor140280420560700

PostgreSQL pgbench

Swap Usage Monitor

MinAvgMaxAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX202.0271.9327.0OpenBenchmarking.orgMegabytes, Fewer Is BetterPostgreSQL pgbench 13.0Swap Usage Monitor80160240320400

CPU Usage (Summary) Monitor

Phoronix Test Suite System Monitoring

OpenBenchmarking.orgPercentCPU Usage (Summary) MonitorPhoronix Test Suite System MonitoringAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX0.8821.7642.6463.5284.413.92

Drive Read Speed (sda) Monitor

Phoronix Test Suite System Monitoring

MinAvgMaxAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX0.015.2226.7OpenBenchmarking.orgMB/sDrive Read Speed (sda) MonitorPhoronix Test Suite System Monitoring60120180240300

Drive Write Speed (sda) Monitor

Phoronix Test Suite System Monitoring

MinAvgMaxAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX0.055.8321.6OpenBenchmarking.orgMB/sDrive Write Speed (sda) MonitorPhoronix Test Suite System Monitoring80160240320400

Memory Usage Monitor

Phoronix Test Suite System Monitoring

MinAvgMaxAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX373614751OpenBenchmarking.orgMegabytesMemory Usage MonitorPhoronix Test Suite System Monitoring2004006008001000

Swap Usage Monitor

Phoronix Test Suite System Monitoring

MinAvgMaxAMD Ryzen 5 4600H - VMware SVGA II - Intel 440BX9.0106.9327.0OpenBenchmarking.orgMegabytesSwap Usage MonitorPhoronix Test Suite System Monitoring80160240320400

Phoronix Test Suite v10.8.4