pgbench-1to1000-1-ro

Intel Core i5 450M testing with a Acer TravelMate 8372 (V1.10 BIOS) and Intel HD 2GB on Debian 10 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 2101215-HA-PGBENCH1T50
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
pgbench-1to1000-1-ro
January 21 2021
  1 Hour, 18 Minutes
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):

pgbench-1to1000-1-ro

Processor: Intel Core i5 450M @ 2.40GHz (2 Cores / 4 Threads), Motherboard: Acer TravelMate 8372 (V1.10 BIOS), Chipset: Intel Core DRAM, Memory: 8GB, Disk: 500GB CT500MX500SSD1, Graphics: Intel HD 2GB, Audio: Conexant CX20585, Monitor: DELL E173FP, Network: Broadcom NetXtreme BCM57760 PCIe + Broadcom BCM43225 802.11b/g/n

OS: Debian 10, Kernel: 5.8.0-3-amd64 (x86_64), Desktop: Xfce 4.14, Display Server: X Server 1.20.9, Display Driver: intel 2.99.917, OpenGL: 2.1 Mesa 20.1.8, Compiler: GCC 8.3.0, File-System: ext4, Screen Resolution: 2646x1024

Environment Notes: MESA_LOADER_DRIVER_OVERRIDE=i965
Compiler Notes: --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
Processor Notes: Scaling Governor: acpi-cpufreq ondemand (Boost: Enabled) - CPU Microcode: 0x7
Security Notes: itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Vulnerable: Clear buffers attempted no microcode; SMT vulnerable + meltdown: Mitigation of PTI + 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 generic retpoline IBPB: conditional IBRS_FW STIBP: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected

pgbench-1to1000-1-roOpenBenchmarking.orgPhoronix Test SuiteIntel Core i5 450M @ 2.40GHz (2 Cores / 4 Threads)Acer TravelMate 8372 (V1.10 BIOS)Intel Core DRAM8GB500GB CT500MX500SSD1Intel HD 2GBConexant CX20585DELL E173FPBroadcom NetXtreme BCM57760 PCIe + Broadcom BCM43225 802.11b/g/nDebian 105.8.0-3-amd64 (x86_64)Xfce 4.14X Server 1.20.9intel 2.99.9172.1 Mesa 20.1.8GCC 8.3.0ext42646x1024ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLCompilerFile-SystemScreen ResolutionPgbench-1to1000-1-ro BenchmarksSystem Logs- MESA_LOADER_DRIVER_OVERRIDE=i965- --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 - Scaling Governor: acpi-cpufreq ondemand (Boost: Enabled) - CPU Microcode: 0x7- itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Vulnerable: Clear buffers attempted no microcode; SMT vulnerable + meltdown: Mitigation of PTI + 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 generic retpoline IBPB: conditional IBRS_FW STIBP: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected

pgbench-1to1000-1-ropgbench: 1 - 1 - Read Onlypgbench: 1 - 1 - Read Only - Average Latencypgbench: 100 - 1 - Read Onlypgbench: 100 - 1 - Read Only - Average Latencypgbench: 1000 - 1 - Read Onlypgbench: 1000 - 1 - Read Only - Average Latencypgbench-1to1000-1-ro68670.14560960.16414050.712OpenBenchmarking.org

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Onlypgbench-1to1000-1-ro15003000450060007500SE +/- 33.75, N = 368671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latencypgbench-1to1000-1-ro0.03260.06520.09780.13040.163SE +/- 0.001, N = 30.1451. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 1 - Mode: Read Onlypgbench-1to1000-1-ro13002600390052006500SE +/- 37.26, N = 360961. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latencypgbench-1to1000-1-ro0.03690.07380.11070.14760.1845SE +/- 0.001, N = 30.1641. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Onlypgbench-1to1000-1-ro30060090012001500SE +/- 7.15, N = 314051. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latencypgbench-1to1000-1-ro0.16020.32040.48060.64080.801SE +/- 0.004, N = 30.7121. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

pgbench-1to1000-1-ro

Processor: Intel Core i5 450M @ 2.40GHz (2 Cores / 4 Threads), Motherboard: Acer TravelMate 8372 (V1.10 BIOS), Chipset: Intel Core DRAM, Memory: 8GB, Disk: 500GB CT500MX500SSD1, Graphics: Intel HD 2GB, Audio: Conexant CX20585, Monitor: DELL E173FP, Network: Broadcom NetXtreme BCM57760 PCIe + Broadcom BCM43225 802.11b/g/n

OS: Debian 10, Kernel: 5.8.0-3-amd64 (x86_64), Desktop: Xfce 4.14, Display Server: X Server 1.20.9, Display Driver: intel 2.99.917, OpenGL: 2.1 Mesa 20.1.8, Compiler: GCC 8.3.0, File-System: ext4, Screen Resolution: 2646x1024

Environment Notes: MESA_LOADER_DRIVER_OVERRIDE=i965
Compiler Notes: --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
Processor Notes: Scaling Governor: acpi-cpufreq ondemand (Boost: Enabled) - CPU Microcode: 0x7
Security Notes: itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Vulnerable: Clear buffers attempted no microcode; SMT vulnerable + meltdown: Mitigation of PTI + 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 generic retpoline IBPB: conditional IBRS_FW STIBP: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 21 January 2021 10:48 by user connor.