roos-data

roos-defaults-pgbench

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2209287-MUPP-ROOSDAT40
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
Prefer Vertical Bar Graphs

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
Performance Per
Dollar
Date
Run
  Test
  Duration
xfs-defaults
September 28
  13 Minutes
data-defaults
September 28
  15 Minutes
data-defaults-pgbench
September 28
  14 Minutes
roos-defaults-pgbench
September 28
  53 Minutes
Invert Hiding All Results Option
  24 Minutes

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


roos-dataOpenBenchmarking.orgPhoronix Test Suite 10.8.42 x Intel Xeon Gold 6138 (40 Cores / 80 Threads)Dell PowerEdge R640 [0HG0J8] (2.14.2 BIOS)Intel Sky Lake-E DMI3 Registers8 x 32 GB DDR4-2400MT/s M393A4K40BB1-CRC3839GB PERC H750 Adp + 480GB DELLBOSS VDMatrox G200eW32 x Intel I350 + 4 x Intel 10-Gigabit X540-AT2Debian 115.15.53-1-pve (x86_64)1.0.2GCC 10.2.1 20210110xfs1600x1200ProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelVulkanCompilerFile-SystemScreen ResolutionRoos-data BenchmarksSystem Logs- Transparent Huge Pages: madvise- --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++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-mutex --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-10-Km9U7s/gcc-10-10.2.1/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-10-Km9U7s/gcc-10-10.2.1/debian/tmp-gcn/usr,hsa --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-build-config=bootstrap-lto-lean --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v - xfs-defaults, data-defaults: MQ-DEADLINE / attr2,inode64,logbsize=256k,logbufs=8,noquota,relatime,rw,sunit=512,swidth=2048 / Block Size: 4096 - CPU Microcode: 0x2006d05- itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + mmio_stale_data: Mitigation of Clear buffers; SMT vulnerable + retbleed: Mitigation of IBRS + 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 IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Mitigation of Clear buffers; SMT vulnerable

roos-datafio: Rand Read - Linux AIO - No - Yes - 4KB - Default Test Directoryfio: Rand Read - Linux AIO - No - Yes - 4KB - Default Test Directoryfio: Rand Write - Linux AIO - No - Yes - 4KB - Default Test Directoryfio: Rand Write - Linux AIO - No - Yes - 4KB - Default Test Directoryfio: Seq Read - Linux AIO - No - Yes - 4KB - Default Test Directoryfio: Seq Read - Linux AIO - No - Yes - 4KB - Default Test Directoryfio: Seq Write - Linux AIO - No - Yes - 4KB - Default Test Directoryfio: Seq Write - Linux AIO - No - Yes - 4KB - Default Test Directorypgbench: 100 - 250 - Read Onlypgbench: 100 - 250 - Read Writepgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Write - Average Latencypgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 250 - Read Write - Average Latencypgbench: 1000 - 1 - Read Writepgbench: 1000 - 1 - Read Write - Average Latencyxfs-defaultsdata-defaultsdata-defaults-pgbenchroos-defaults-pgbench48812466748112300048912500084321566748312366745611666748712466783621400025550.391827229373660.3026.69118010.555OpenBenchmarking.org

Flexible IO Tester

FIO, the Flexible I/O Tester, is an advanced Linux disk benchmark supporting multiple I/O engines and a wealth of options. FIO was written by Jens Axboe for testing of the Linux I/O subsystem and schedulers. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMB/s, More Is BetterFlexible IO Tester 3.29Type: Random Read - Engine: Linux AIO - Buffered: No - Direct: Yes - Block Size: 4KB - Disk Target: Default Test Directoryxfs-defaultsdata-defaults110220330440550SE +/- 1.33, N = 3SE +/- 4.51, N = 34884831. (CC) gcc options: -rdynamic -ll -lrt -lz -lpthread -lm -ldl -laio -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -U_FORTIFY_SOURCE -march=native
OpenBenchmarking.orgMB/s, More Is BetterFlexible IO Tester 3.29Type: Random Read - Engine: Linux AIO - Buffered: No - Direct: Yes - Block Size: 4KB - Disk Target: Default Test Directoryxfs-defaultsdata-defaults90180270360450Min: 485 / Avg: 487.67 / Max: 489Min: 474 / Avg: 483 / Max: 4881. (CC) gcc options: -rdynamic -ll -lrt -lz -lpthread -lm -ldl -laio -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -U_FORTIFY_SOURCE -march=native

OpenBenchmarking.orgIOPS, More Is BetterFlexible IO Tester 3.29Type: Random Read - Engine: Linux AIO - Buffered: No - Direct: Yes - Block Size: 4KB - Disk Target: Default Test Directoryxfs-defaultsdata-defaults30K60K90K120K150KSE +/- 333.33, N = 3SE +/- 1333.33, N = 31246671236671. (CC) gcc options: -rdynamic -ll -lrt -lz -lpthread -lm -ldl -laio -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -U_FORTIFY_SOURCE -march=native
OpenBenchmarking.orgIOPS, More Is BetterFlexible IO Tester 3.29Type: Random Read - Engine: Linux AIO - Buffered: No - Direct: Yes - Block Size: 4KB - Disk Target: Default Test Directoryxfs-defaultsdata-defaults20K40K60K80K100KMin: 124000 / Avg: 124666.67 / Max: 125000Min: 121000 / Avg: 123666.67 / Max: 1250001. (CC) gcc options: -rdynamic -ll -lrt -lz -lpthread -lm -ldl -laio -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -U_FORTIFY_SOURCE -march=native

OpenBenchmarking.orgMB/s, More Is BetterFlexible IO Tester 3.29Type: Random Write - Engine: Linux AIO - Buffered: No - Direct: Yes - Block Size: 4KB - Disk Target: Default Test Directoryxfs-defaultsdata-defaults100200300400500SE +/- 3.48, N = 34814561. (CC) gcc options: -rdynamic -ll -lrt -lz -lpthread -lm -ldl -laio -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -U_FORTIFY_SOURCE -march=native
OpenBenchmarking.orgMB/s, More Is BetterFlexible IO Tester 3.29Type: Random Write - Engine: Linux AIO - Buffered: No - Direct: Yes - Block Size: 4KB - Disk Target: Default Test Directoryxfs-defaultsdata-defaults90180270360450Min: 450 / Avg: 456.33 / Max: 4621. (CC) gcc options: -rdynamic -ll -lrt -lz -lpthread -lm -ldl -laio -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -U_FORTIFY_SOURCE -march=native

OpenBenchmarking.orgIOPS, More Is BetterFlexible IO Tester 3.29Type: Random Write - Engine: Linux AIO - Buffered: No - Direct: Yes - Block Size: 4KB - Disk Target: Default Test Directoryxfs-defaultsdata-defaults30K60K90K120K150KSE +/- 881.92, N = 31230001166671. (CC) gcc options: -rdynamic -ll -lrt -lz -lpthread -lm -ldl -laio -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -U_FORTIFY_SOURCE -march=native
OpenBenchmarking.orgIOPS, More Is BetterFlexible IO Tester 3.29Type: Random Write - Engine: Linux AIO - Buffered: No - Direct: Yes - Block Size: 4KB - Disk Target: Default Test Directoryxfs-defaultsdata-defaults20K40K60K80K100KMin: 115000 / Avg: 116666.67 / Max: 1180001. (CC) gcc options: -rdynamic -ll -lrt -lz -lpthread -lm -ldl -laio -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -U_FORTIFY_SOURCE -march=native

OpenBenchmarking.orgMB/s, More Is BetterFlexible IO Tester 3.29Type: Sequential Read - Engine: Linux AIO - Buffered: No - Direct: Yes - Block Size: 4KB - Disk Target: Default Test Directoryxfs-defaultsdata-defaults110220330440550SE +/- 5.70, N = 3SE +/- 5.78, N = 34894871. (CC) gcc options: -rdynamic -ll -lrt -lz -lpthread -lm -ldl -laio -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -U_FORTIFY_SOURCE -march=native
OpenBenchmarking.orgMB/s, More Is BetterFlexible IO Tester 3.29Type: Sequential Read - Engine: Linux AIO - Buffered: No - Direct: Yes - Block Size: 4KB - Disk Target: Default Test Directoryxfs-defaultsdata-defaults90180270360450Min: 478 / Avg: 489.33 / Max: 496Min: 477 / Avg: 486.67 / Max: 4971. (CC) gcc options: -rdynamic -ll -lrt -lz -lpthread -lm -ldl -laio -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -U_FORTIFY_SOURCE -march=native

OpenBenchmarking.orgIOPS, More Is BetterFlexible IO Tester 3.29Type: Sequential Read - Engine: Linux AIO - Buffered: No - Direct: Yes - Block Size: 4KB - Disk Target: Default Test Directoryxfs-defaultsdata-defaults30K60K90K120K150KSE +/- 1527.53, N = 3SE +/- 1452.97, N = 31250001246671. (CC) gcc options: -rdynamic -ll -lrt -lz -lpthread -lm -ldl -laio -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -U_FORTIFY_SOURCE -march=native
OpenBenchmarking.orgIOPS, More Is BetterFlexible IO Tester 3.29Type: Sequential Read - Engine: Linux AIO - Buffered: No - Direct: Yes - Block Size: 4KB - Disk Target: Default Test Directoryxfs-defaultsdata-defaults20K40K60K80K100KMin: 122000 / Avg: 125000 / Max: 127000Min: 122000 / Avg: 124666.67 / Max: 1270001. (CC) gcc options: -rdynamic -ll -lrt -lz -lpthread -lm -ldl -laio -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -U_FORTIFY_SOURCE -march=native

OpenBenchmarking.orgMB/s, More Is BetterFlexible IO Tester 3.29Type: Sequential Write - Engine: Linux AIO - Buffered: No - Direct: Yes - Block Size: 4KB - Disk Target: Default Test Directoryxfs-defaultsdata-defaults2004006008001000SE +/- 9.91, N = 3SE +/- 9.68, N = 38438361. (CC) gcc options: -rdynamic -ll -lrt -lz -lpthread -lm -ldl -laio -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -U_FORTIFY_SOURCE -march=native
OpenBenchmarking.orgMB/s, More Is BetterFlexible IO Tester 3.29Type: Sequential Write - Engine: Linux AIO - Buffered: No - Direct: Yes - Block Size: 4KB - Disk Target: Default Test Directoryxfs-defaultsdata-defaults150300450600750Min: 827 / Avg: 842.67 / Max: 861Min: 825 / Avg: 835.67 / Max: 8551. (CC) gcc options: -rdynamic -ll -lrt -lz -lpthread -lm -ldl -laio -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -U_FORTIFY_SOURCE -march=native

OpenBenchmarking.orgIOPS, More Is BetterFlexible IO Tester 3.29Type: Sequential Write - Engine: Linux AIO - Buffered: No - Direct: Yes - Block Size: 4KB - Disk Target: Default Test Directoryxfs-defaultsdata-defaults50K100K150K200K250KSE +/- 2333.33, N = 3SE +/- 2516.61, N = 32156672140001. (CC) gcc options: -rdynamic -ll -lrt -lz -lpthread -lm -ldl -laio -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -U_FORTIFY_SOURCE -march=native
OpenBenchmarking.orgIOPS, More Is BetterFlexible IO Tester 3.29Type: Sequential Write - Engine: Linux AIO - Buffered: No - Direct: Yes - Block Size: 4KB - Disk Target: Default Test Directoryxfs-defaultsdata-defaults40K80K120K160K200KMin: 212000 / Avg: 215666.67 / Max: 220000Min: 211000 / Avg: 214000 / Max: 2190001. (CC) gcc options: -rdynamic -ll -lrt -lz -lpthread -lm -ldl -laio -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -U_FORTIFY_SOURCE -march=native

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 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read Onlyroos-defaults-pgbench200K400K600K800K1000KSE +/- 3694.76, N = 38272291. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read Onlyroos-defaults-pgbench140K280K420K560K700KMin: 820740.44 / Avg: 827229.15 / Max: 833535.581. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Scaling Factor: 100 - Clients: 250 - Mode: Read Only

data-defaults: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 35 aborted in command 0 (set) of script 0; evaluation of meta-command failed

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read Writeroos-defaults-pgbench8K16K24K32K40KSE +/- 86.04, N = 3373661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read Writeroos-defaults-pgbench6K12K18K24K30KMin: 37223.93 / Avg: 37365.97 / Max: 37521.131. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

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

data-defaults: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 3 aborted in command 0 (set) of script 0; evaluation of meta-command failed

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Writedata-defaults-pgbench5001000150020002500SE +/- 2.42, N = 325551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latencydata-defaults-pgbench0.0880.1760.2640.3520.44SE +/- 0.000, N = 30.3911. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latencyroos-defaults-pgbench0.0680.1360.2040.2720.34SE +/- 0.001, N = 30.3021. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latencyroos-defaults-pgbench246810SE +/- 0.015, N = 36.6911. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Writeroos-defaults-pgbench400800120016002000SE +/- 20.76, N = 318011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latencyroos-defaults-pgbench0.12490.24980.37470.49960.6245SE +/- 0.006, N = 30.5551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

16 Results Shown

Flexible IO Tester:
  Rand Read - Linux AIO - No - Yes - 4KB - Default Test Directory:
    MB/s
    IOPS
  Rand Write - Linux AIO - No - Yes - 4KB - Default Test Directory:
    MB/s
    IOPS
  Seq Read - Linux AIO - No - Yes - 4KB - Default Test Directory:
    MB/s
    IOPS
  Seq Write - Linux AIO - No - Yes - 4KB - Default Test Directory:
    MB/s
    IOPS
PostgreSQL pgbench:
  100 - 250 - Read Only
  100 - 250 - Read Write
  1 - 1 - Read Write
  1 - 1 - Read Write - Average Latency
  100 - 250 - Read Only - Average Latency
  100 - 250 - Read Write - Average Latency
  1000 - 1 - Read Write
  1000 - 1 - Read Write - Average Latency