pg-all

KVM testing on Ubuntu 18.04 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 1908278-KH-PGALL452588
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
cafebazaar b4 with hugepages
August 26 2019
 
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):


pg-allOpenBenchmarking.orgPhoronix Test SuiteIntel Xeon Gold 6152 @ 2.10GHz (2 Cores)QEMU Standard PC (Q35 + ICH9 2009)Intel 82G33/G31/P35/P31 + ICH94 x 1024 MB RAM QEMU29GBDevice 1234:1111Red Hat Virtio deviceUbuntu 18.044.15.0-58-generic (x86_64)ext4KVMProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelFile-SystemSystem LayerPg-all BenchmarksSystem Logs- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --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

pg-allpgbench: On-Disk - Normal Load - Read Onlypgbench: On-Disk - Normal Load - Read Writepgbench: On-Disk - Single Thread - Read Onlypgbench: Mostly RAM - Normal Load - Read Onlypgbench: On-Disk - Single Thread - Read Writepgbench: Buffer Test - Normal Load - Read Onlypgbench: Mostly RAM - Normal Load - Read Writepgbench: Buffer Test - Normal Load - Read Writepgbench: Mostly RAM - Single Thread - Read Onlypgbench: On-Disk - Heavy Contention - Read Onlypgbench: Buffer Test - Single Thread - Read Onlypgbench: Mostly RAM - Single Thread - Read Writepgbench: On-Disk - Heavy Contention - Read Writepgbench: Buffer Test - Single Thread - Read Writepgbench: Mostly RAM - Heavy Contention - Read Onlypgbench: Buffer Test - Heavy Contention - Read Onlypgbench: Mostly RAM - Heavy Contention - Read Writepgbench: Buffer Test - Heavy Contention - Read Writecafebazaar b4 with hugepages49236.891077.1324446.235015.86458.9733372.491592.233942.291832.7049316.1918639.34717.061036.391666.325571.5934143.611621.324067.84OpenBenchmarking.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 Onlycafebazaar b4 with hugepages11K22K33K44K55KSE +/- 541.56, N = 349236.891. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Normal Load - Mode: Read Writecafebazaar b4 with hugepages2004006008001000SE +/- 4.95, N = 31077.131. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Single Thread - Mode: Read Onlycafebazaar b4 with hugepages5K10K15K20K25KSE +/- 264.46, N = 324446.231. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read Onlycafebazaar b4 with hugepages11002200330044005500SE +/- 81.06, N = 45015.861. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Single Thread - Mode: Read Writecafebazaar b4 with hugepages100200300400500SE +/- 6.18, N = 6458.971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Normal Load - Mode: Read Onlycafebazaar b4 with hugepages7K14K21K28K35KSE +/- 778.23, N = 633372.491. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read Writecafebazaar b4 with hugepages30060090012001500SE +/- 4.86, N = 31592.231. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Normal Load - Mode: Read Writecafebazaar b4 with hugepages8001600240032004000SE +/- 16.82, N = 33942.291. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Single Thread - Mode: Read Onlycafebazaar b4 with hugepages400800120016002000SE +/- 15.58, N = 31832.701. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read Onlycafebazaar b4 with hugepages11K22K33K44K55KSE +/- 68.65, N = 349316.191. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Single Thread - Mode: Read Onlycafebazaar b4 with hugepages4K8K12K16K20KSE +/- 81.45, N = 318639.341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Single Thread - Mode: Read Writecafebazaar b4 with hugepages150300450600750SE +/- 5.47, N = 3717.061. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read Writecafebazaar b4 with hugepages2004006008001000SE +/- 7.26, N = 31036.391. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Single Thread - Mode: Read Writecafebazaar b4 with hugepages400800120016002000SE +/- 16.13, N = 31666.321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Onlycafebazaar b4 with hugepages12002400360048006000SE +/- 67.78, N = 35571.591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Onlycafebazaar b4 with hugepages7K14K21K28K35KSE +/- 297.89, N = 334143.611. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Writecafebazaar b4 with hugepages30060090012001500SE +/- 16.18, N = 31621.321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Writecafebazaar b4 with hugepages9001800270036004500SE +/- 36.44, N = 34067.841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -lcrypt -ldl -lm