pgbenchAllTests20190717

container-other testing on Clear Linux OS 29390 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 1907182-HV-PGBENCHAL69
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
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
pgbenchALL
July 17 2019
  11 Hours, 22 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):

pgbenchALL

Processor: 4 x Intel Core (Haswell no TSX IBRS) (4 Cores), Motherboard: OpenStack Foundation Nova v18.1.0 (1.10.2-1ubuntu1 BIOS), Memory: 4096MB, Disk: 40GB, Graphics: cirrusdrmfb

OS: Clear Linux OS 29390, Kernel: 3.10.0-957.21.3.el7.x86_64 (x86_64), Compiler: GCC 9.1.1 20190512 gcc-9-branch@271104 + Clang 8.0.0 + LLVM 8.0.0, File-System: overlayfs, Screen Resolution: 1024x768, System Layer: container-other

Compiler Notes: --build=x86_64-generic-linux --disable-libmpx --disable-libunwind-exceptions --disable-multiarch --disable-vtable-verify --disable-werror --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-clocale=gnu --enable-default-pie --enable-gnu-indirect-function --enable-languages=c,c++,fortran,go --enable-ld=default --enable-libstdcxx-pch --enable-lto --enable-multilib --enable-plugin --enable-shared --enable-threads=posix --exec-prefix=/usr --includedir=/usr/include --target=x86_64-generic-linux --with-arch=westmere --with-gcc-major-version-only --with-glibc-version=2.19 --with-gnu-ld --with-isl --with-ppl=yes --with-tune=haswell
Security Notes: KPTI + Load fences __user pointer sanitization + Full retpoline IBPB + SSB disabled via prctl and seccomp + PTE Inversion; VMX: conditional cache flushes SMT disabled

pgbenchAllTests20190717OpenBenchmarking.orgPhoronix Test Suite4 x Intel Core (Haswell no TSX IBRS) (4 Cores)OpenStack Foundation Nova v18.1.0 (1.10.2-1ubuntu1 BIOS)4096MB40GBcirrusdrmfbClear Linux OS 293903.10.0-957.21.3.el7.x86_64 (x86_64)GCC 9.1.1 20190512 gcc-9-branch@271104 + Clang 8.0.0 + LLVM 8.0.0overlayfs1024x768container-otherProcessorMotherboardMemoryDiskGraphicsOSKernelCompilerFile-SystemScreen ResolutionSystem LayerPgbenchAllTests20190717 BenchmarksSystem Logs- --build=x86_64-generic-linux --disable-libmpx --disable-libunwind-exceptions --disable-multiarch --disable-vtable-verify --disable-werror --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-clocale=gnu --enable-default-pie --enable-gnu-indirect-function --enable-languages=c,c++,fortran,go --enable-ld=default --enable-libstdcxx-pch --enable-lto --enable-multilib --enable-plugin --enable-shared --enable-threads=posix --exec-prefix=/usr --includedir=/usr/include --target=x86_64-generic-linux --with-arch=westmere --with-gcc-major-version-only --with-glibc-version=2.19 --with-gnu-ld --with-isl --with-ppl=yes --with-tune=haswell - KPTI + Load fences __user pointer sanitization + Full retpoline IBPB + SSB disabled via prctl and seccomp + PTE Inversion; VMX: conditional cache flushes SMT disabled

pgbenchAllTests20190717pgbench: On-Disk - Normal Load - Read Onlypgbench: Mostly RAM - Normal Load - Read Writepgbench: Mostly RAM - Single Thread - Read Onlypgbench: Mostly RAM - Heavy Contention - Read Writepgbench: Mostly RAM - Heavy Contention - Read Onlypgbench: On-Disk - Single Thread - Read Onlypgbench: On-Disk - Normal Load - Read Writepgbench: On-Disk - Single Thread - Read Writepgbench: On-Disk - Heavy Contention - Read Onlypgbench: On-Disk - Heavy Contention - Read Writepgbench: Mostly RAM - Single Thread - Read Writepgbench: Mostly RAM - Normal Load - Read Onlypgbench: Buffer Test - Normal Load - Read Writepgbench: Buffer Test - Heavy Contention - Read Writepgbench: Buffer Test - Single Thread - Read Writepgbench: Buffer Test - Normal Load - Read Onlypgbench: Buffer Test - Single Thread - Read Onlypgbench: Buffer Test - Heavy Contention - Read OnlypgbenchALL33198.10490.82255.46996.9416016.279277.18926.91133.0737590.551185.5155.7411906.731120.321293.77199.3928000.327481.9129079.18OpenBenchmarking.org

PostgreSQL pgbench

This is a simple benchmark of PostgreSQL using pgbench. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Normal Load - Mode: Read OnlypgbenchALL7K14K21K28K35KSE +/- 1738.99, N = 933198.10

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read WritepgbenchALL110220330440550SE +/- 27.02, N = 9490.82

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Single Thread - Mode: Read OnlypgbenchALL60120180240300SE +/- 8.28, N = 9255.46

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read WritepgbenchALL2004006008001000SE +/- 64.77, N = 9996.94

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read OnlypgbenchALL3K6K9K12K15KSE +/- 419.45, N = 916016.27

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Single Thread - Mode: Read OnlypgbenchALL2K4K6K8K10KSE +/- 127.48, N = 49277.18

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Normal Load - Mode: Read WritepgbenchALL2004006008001000SE +/- 7.84, N = 3926.91

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Single Thread - Mode: Read WritepgbenchALL306090120150SE +/- 1.00, N = 3133.07

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read OnlypgbenchALL8K16K24K32K40KSE +/- 460.02, N = 337590.55

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read WritepgbenchALL30060090012001500SE +/- 5.71, N = 31185.51

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Single Thread - Mode: Read WritepgbenchALL1326395265SE +/- 0.72, N = 355.74

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read OnlypgbenchALL3K6K9K12K15KSE +/- 62.16, N = 311906.73

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Normal Load - Mode: Read WritepgbenchALL2004006008001000SE +/- 23.68, N = 151120.32

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Heavy Contention - Mode: Read WritepgbenchALL30060090012001500SE +/- 44.47, N = 121293.77

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Single Thread - Mode: Read WritepgbenchALL4080120160200SE +/- 2.61, N = 5199.39

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Normal Load - Mode: Read OnlypgbenchALL6K12K18K24K30KSE +/- 340.07, N = 328000.32

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Single Thread - Mode: Read OnlypgbenchALL16003200480064008000SE +/- 93.40, N = 37481.91

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Heavy Contention - Mode: Read OnlypgbenchALL6K12K18K24K30KSE +/- 236.07, N = 329079.18

pgbenchALL

Processor: 4 x Intel Core (Haswell no TSX IBRS) (4 Cores), Motherboard: OpenStack Foundation Nova v18.1.0 (1.10.2-1ubuntu1 BIOS), Memory: 4096MB, Disk: 40GB, Graphics: cirrusdrmfb

OS: Clear Linux OS 29390, Kernel: 3.10.0-957.21.3.el7.x86_64 (x86_64), Compiler: GCC 9.1.1 20190512 gcc-9-branch@271104 + Clang 8.0.0 + LLVM 8.0.0, File-System: overlayfs, Screen Resolution: 1024x768, System Layer: container-other

Compiler Notes: --build=x86_64-generic-linux --disable-libmpx --disable-libunwind-exceptions --disable-multiarch --disable-vtable-verify --disable-werror --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-clocale=gnu --enable-default-pie --enable-gnu-indirect-function --enable-languages=c,c++,fortran,go --enable-ld=default --enable-libstdcxx-pch --enable-lto --enable-multilib --enable-plugin --enable-shared --enable-threads=posix --exec-prefix=/usr --includedir=/usr/include --target=x86_64-generic-linux --with-arch=westmere --with-gcc-major-version-only --with-glibc-version=2.19 --with-gnu-ld --with-isl --with-ppl=yes --with-tune=haswell
Security Notes: KPTI + Load fences __user pointer sanitization + Full retpoline IBPB + SSB disabled via prctl and seccomp + PTE Inversion; VMX: conditional cache flushes SMT disabled

Testing initiated at 17 July 2019 16:05 by user root.