db-fs-results

Docker testing on Ubuntu 20.04.3 LTS 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 2112219-TJ-DBFSRESUL67
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

Limit displaying results to tests within:

C/C++ Compiler Tests 4 Tests
CPU Massive 3 Tests
Database Test Suite 13 Tests
Java Tests 2 Tests
Common Kernel Benchmarks 4 Tests
Multi-Core 3 Tests
Server 13 Tests
Server CPU Tests 2 Tests

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Geometric Means Per-Suite/Category
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
EXT4
December 18 2021
  1 Day, 15 Hours, 24 Minutes
XFS
December 19 2021
  2 Days, 10 Hours, 38 Minutes
Invert Hiding All Results Option
  2 Days, 1 Hour, 1 Minute
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):

EXT4

Processor: 2 x Intel Xeon E5-2630 v3 @ 3.20GHz (16 Cores / 32 Threads), Motherboard: Dell 0CNCJW (2.2.5 BIOS), Memory: 64GB, Disk: 731GB PERC H730P Mini, Graphics: mgadrmfb

OS: Ubuntu 20.04.3 LTS, Kernel: 3.10.0-1160.36.2.el7.x86_64 (x86_64), Compiler: GCC 9.3.0, File-System: ext4, Screen Resolution: 1024x768, System Layer: Docker

Kernel Notes: Transparent Huge Pages: never
Compiler Notes: --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++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-HskZEa/gcc-9-9.3.0/debian/tmp-nvptx/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-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
Processor Notes: Scaling Governor: intel_pstate performance - CPU Microcode: 0x44
Disk Scheduler Notes: DEADLINE
Java Notes: OpenJDK Runtime Environment (build 11.0.13+8-Ubuntu-0ubuntu1.20.04)
Security Notes: itlb_multihit: KVM: Mitigation of Split huge pages + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of Load fences usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full retpoline IBPB + srbds: Not affected + tsx_async_abort: Not affected

XFS

OS: Ubuntu 20.04.3 LTS, Kernel: 3.10.0-1160.36.2.el7.x86_64 (x86_64), Compiler: GCC 9.3.0, File-System: xfs, Screen Resolution: 1024x768, System Layer: Docker

db-fs-resultsOpenBenchmarking.orgPhoronix Test Suite2 x Intel Xeon E5-2630 v3 @ 3.20GHz (16 Cores / 32 Threads)Dell 0CNCJW (2.2.5 BIOS)64GB731GB PERC H730P MinimgadrmfbUbuntu 20.04.3 LTS3.10.0-1160.36.2.el7.x86_64 (x86_64)GCC 9.3.0ext4xfs1024x768DockerProcessorMotherboardMemoryDiskGraphicsOSKernelCompilerFile-SystemsScreen ResolutionSystem LayerDb-fs-results PerformanceSystem Logs- Transparent Huge Pages: never- --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++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-HskZEa/gcc-9-9.3.0/debian/tmp-nvptx/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-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 - Scaling Governor: intel_pstate performance - CPU Microcode: 0x44- DEADLINE- OpenJDK Runtime Environment (build 11.0.13+8-Ubuntu-0ubuntu1.20.04)- itlb_multihit: KVM: Mitigation of Split huge pages + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of Load fences usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full retpoline IBPB + srbds: Not affected + tsx_async_abort: Not affected

EXT4 vs. XFS ComparisonPhoronix Test SuiteBaseline+48.5%+48.5%+97%+97%+145.5%+145.5%126%96.2%81.7%76.1%53.9%48.6%38.3%35.7%35.7%18.7%18.7%17.6%14.5%14.1%14%13%11.4%11.2%11.1%9.7%9.6%5.9%4.5%3.9%3.7%3.7%3.2%3.2%3.2%3.1%3.1%2.6%2.6%2.5%2.5%2.3%2.3%2.2%2.2%2.2%2.2%2.1%2.1%Rand Read - 128194%Rand Read - 128191.5%Rand Write - 16Rand Read - 64113.6%Rand Read - 64112.5%Rand Write - 16Rand Write - 32Rand Write - 32Rand Write - 128Rand Write - 64Rand Write - 64Rand Write - 128Seq Write - 32Rand Read - 3233%Rand Read - 3232.5%Seq Read - 1624%Seq Read - 1623.8%Async Rand Read - 3220.3%Async Rand Read - 3220.2%1000 - 500 - Read Write1000 - 500 - Read Write - Average LatencyRand Read - 1617.9%Increment - 117.9%Rand Read - 1617.8%Increment - 117.7%Seq Write - 16Seq Read - 3216.2%Seq Read - 3215.8%Seq Write - 161000 - 250 - Read Write1000 - 250 - Read Write - Average LatencyR.R.W.RRand Read - 1Rand Read - 1Seq Write - 128Rand Write - 411.1%Seq Write - 410%Seq Write - 32Seq Write - 128Rand Write - 1Increment - 45.5%Seq Read - 45.5%Increment - 45.4%Seq Read - 645.3%Increment - 165%Increment - 164.9%Seq Read - 644.9%1 - 250 - Read Write - Average LatencyRand Read - 44.2%Rand Read - 44.1%Redis4%Update RandIncrement - 323.9%Increment - 323.8%1000 - 500 - Read Only1000 - 500 - Read Only - Average LatencyRand Write - 43.5%100 - 250 - Read Write100 - 250 - Read Write - Average LatencyAsync Rand Read - 13.2%1 - 250 - Read WriteSeq Read - 43.2%Seq Write - 643.1%100 - 500 - Read Write - Average Latency100 - 500 - Read WriteAsync Rand Read - 12.9%Mixed 1:32.8%12.6%100 - 100 - Read Write - Average Latency100 - 100 - Read WriteSET2.5%ReadsSeq Read - 128Seq Read - 128Rand Fill100 - 100 - Read Only100 - 50 - Read Write - Average Latency100 - 50 - Read Write100 - 100 - Read Only - Average Latency1 - 500 - Read Only - Average Latency1 - 500 - Read OnlyApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBasePostgreSQL pgbenchPostgreSQL pgbenchApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBasePostgreSQL pgbenchPostgreSQL pgbenchFacebook RocksDBApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBaseApache HBasePostgreSQL pgbenchApache HBaseApache HBaseMemtier_benchmarkFacebook RocksDBApache HBaseApache HBasePostgreSQL pgbenchPostgreSQL pgbenchApache HBasePostgreSQL pgbenchPostgreSQL pgbenchApache HBasePostgreSQL pgbenchApache HBaseApache HBasePostgreSQL pgbenchPostgreSQL pgbenchApache HBaseApache CassandraSQLitePostgreSQL pgbenchPostgreSQL pgbenchRedisApache CassandraApache HBaseApache HBaseFacebook RocksDBPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchEXT4XFS

db-fs-resultshbase: Rand Read - 128hbase: Rand Read - 128hbase: Rand Read - 64hbase: Rand Read - 64hbase: Rand Read - 32hbase: Rand Read - 32hbase: Seq Read - 16hbase: Seq Read - 16hbase: Async Rand Read - 32hbase: Async Rand Read - 32pgbench: 1000 - 500 - Read Writepgbench: 1000 - 500 - Read Write - Average Latencyhbase: Rand Read - 16hbase: Increment - 1hbase: Rand Read - 16hbase: Increment - 1hbase: Seq Read - 32hbase: Seq Read - 32pgbench: 1000 - 250 - Read Writepgbench: 1000 - 250 - Read Write - Average Latencyhbase: Rand Read - 1hbase: Rand Read - 1hbase: Rand Write - 1hbase: Increment - 4hbase: Increment - 4hbase: Seq Read - 64hbase: Increment - 16hbase: Increment - 16hbase: Seq Read - 64hbase: Rand Read - 4hbase: Rand Read - 4rocksdb: Update Randhbase: Increment - 32hbase: Increment - 32pgbench: 1000 - 500 - Read Onlypgbench: 1000 - 500 - Read Only - Average Latencypgbench: 100 - 250 - Read Writepgbench: 100 - 250 - Read Write - Average Latencyhbase: Async Rand Read - 1pgbench: 100 - 500 - Read Write - Average Latencypgbench: 100 - 500 - Read Writehbase: Async Rand Read - 1cassandra: Mixed 1:3sqlite: 1pgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 100 - Read Writeredis: SEThbase: Seq Read - 128hbase: Seq Read - 128rocksdb: Rand Fillpgbench: 100 - 100 - Read Onlypgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 100 - Read Only - Average Latencypgbench: 1 - 500 - Read Only - Average Latencypgbench: 1 - 500 - Read Onlyredis: SADDhbase: Async Rand Write - 4pgbench: 1000 - 250 - Read Only - Average Latencyhbase: Async Rand Write - 4pgbench: 1000 - 250 - Read Onlycouchdb: 100 - 1000 - 24leveldb: Fill Syncpgbench: 1 - 1 - Read Only - Average Latencyinfluxdb: 4 - 10000 - 2,5000,1 - 10000pgbench: 1000 - 100 - Read Write - Average Latencypgbench: 1000 - 100 - Read Writehbase: Async Rand Write - 64leveldb: Overwritehbase: Async Rand Write - 64pgbench: 1000 - 100 - Read Onlypgbench: 100 - 250 - Read Only - Average Latencypgbench: 1000 - 100 - Read Only - Average Latencypgbench: 1 - 250 - Read Onlypgbench: 1 - 250 - Read Only - Average Latencypgbench: 1 - 1 - Read Onlypgbench: 100 - 250 - Read Onlypgbench: 1 - 50 - Read Write - Average Latencypgbench: 1 - 50 - Read Writepgbench: 1000 - 1 - Read Only - Average Latencyinfluxdb: 64 - 10000 - 2,5000,1 - 10000rocksdb: Seq Fillhbase: Async Rand Write - 1redis: GEThbase: Async Rand Write - 1cassandra: Writeshbase: Rand Write - 1pgbench: 1000 - 1 - Read Writepgbench: 100 - 50 - Read Only - Average Latencyinfluxdb: 1024 - 10000 - 2,5000,1 - 10000pgbench: 100 - 500 - Read Only - Average Latencypgbench: 100 - 500 - Read Onlyleveldb: Overwriteleveldb: Rand Fillredis: LPOPpgbench: 1000 - 1 - Read Write - Average Latencyhbase: Async Rand Read - 4hbase: Increment - 64hbase: Increment - 64leveldb: Fill Syncpgbench: 1 - 50 - Read Onlykeydb: pgbench: 1000 - 1 - Read Onlyhbase: Increment - 128rocksdb: Read While Writinghbase: Seq Write - 1hbase: Async Rand Write - 32hbase: Increment - 128pgbench: 100 - 50 - Read Onlyhbase: Async Rand Write - 32hbase: Async Rand Read - 4pgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 1 - Read Writepgbench: 1 - 100 - Read Only - Average Latencypgbench: 1 - 50 - Read Only - Average Latencyhbase: Async Rand Write - 128hbase: Async Rand Write - 128leveldb: Rand Deletehbase: Async Rand Read - 64pgbench: 1 - 1 - Read Writeleveldb: Rand Fillpgbench: 1000 - 50 - Read Only - Average Latencypgbench: 1 - 100 - Read Onlyleveldb: Rand Readpgbench: 1 - 1 - Read Write - Average Latencycassandra: Mixed 1:1rocksdb: Rand Readpgbench: 100 - 1 - Read Onlypgbench: 1000 - 50 - Read Writepgbench: 1000 - 50 - Read Write - Average Latencyleveldb: Seq Fillhbase: Async Rand Read - 64sqlite-speedtest: Timed Time - Size 1,000pgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 100 - Read Writeredis: LPUSHpgbench: 1000 - 50 - Read Onlyleveldb: Hot Readhbase: Async Rand Write - 16rocksdb: Rand Fill Syncleveldb: Seek Randhbase: Async Rand Write - 16hbase: Seq Read - 1hbase: Seq Read - 1pgbench: 100 - 1 - Read Only - Average Latencyleveldb: Seq Fillhbase: Async Rand Read - 128hbase: Async Rand Read - 128hbase: Seq Write - 128hbase: Seq Write - 128hbase: Async Rand Read - 16hbase: Async Rand Read - 16hbase: Seq Write - 64hbase: Seq Write - 64hbase: Seq Write - 32hbase: Seq Write - 32hbase: Seq Write - 16hbase: Seq Write - 16hbase: Seq Write - 4hbase: Seq Write - 4hbase: Seq Write - 1hbase: Seq Read - 4hbase: Seq Read - 4hbase: Rand Write - 128hbase: Rand Write - 128hbase: Rand Write - 64hbase: Rand Write - 64hbase: Rand Write - 32hbase: Rand Write - 32hbase: Rand Write - 16hbase: Rand Write - 16hbase: Rand Write - 4hbase: Rand Write - 4rocksdb: Read Rand Write Randcassandra: Readsmemtier-benchmark: Redispgbench: 1 - 500 - Read Write - Average Latencypgbench: 1 - 500 - Read Writepgbench: 1 - 250 - Read Write - Average Latencypgbench: 1 - 250 - Read Writemysqlslap: 1EXT4XFS11851070306331002613529006326260689473672614223118.40322322370930445243273558324277.10916659801830812905778339594688176516623872133336746426081699582.9421161421.52715545.280110476392669983.1598.30012050878810.461332955391465942110824.148120610.4742.341213610899392.7984031.264474197740112.3806.40.076859395.635.072285230182288.49721151918841.1160.5212392721.0451324722404713.78436270.091886748.9148183383873340.332597789805387915840.232867557.92.55419578112.212.3880911.580.63121404149342684543.771224084321216.81109833038241098765319114641978215937278391850.57117510.4450.223300004254288.11613811880287.3280.25522475635.3930.532672504809792512877285517.514288.30046162149.38636.5972733877540.9819626735.284217246526344.14373414866810.07812.23720345594992590642945420624628285513331797260347807301977351418221846131611015166711043131812444916514775845162144571707690781549937.94668.755771177.0141433348436719135247175468679573254903856955966501499.72526326360216378250263518369867.61014966481732512244819323494917794017322927138575775410381763252.8361199120.85216043.921113876214651753.2428.08812364857147.731300977241499152157404.059123220.4642.292218102883258.9285561.286466194410110.5696.50.075848341.634.632288829806292.07221411942301.1030.5152420591.0331339822658213.93935870.092877126.2149787387882156.812572782695435915980.230860201.82.53319740412.112.2873824.560.62621565148242998539.802225698319106.41109113058239542865732115341725217222276851840.57417430.4430.222298664273289.40113871888288.4850.25422563035.5290.530674884823982912840284717.560288.98346059149.71836.5272738876195.4619655035.252217176525244.1387340.07812.237783411344928404524327432198348681513983933320134114192211768551495204491526971752191817328985050156727645769707981490596.16671.078772169.3361479OpenBenchmarking.org

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Read - Clients: 128XFSEXT47001400210028003500SE +/- 50.52, N = 9SE +/- 3.48, N = 334841185
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Read - Clients: 128XFSEXT46001200180024003000Min: 3350 / Avg: 3483.89 / Max: 3839Min: 1179 / Avg: 1185.33 / Max: 1191

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Read - Clients: 128XFSEXT420K40K60K80K100KSE +/- 500.56, N = 9SE +/- 288.51, N = 336719107030
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Read - Clients: 128XFSEXT420K40K60K80K100KMin: 33284 / Avg: 36718.56 / Max: 38112Min: 106666 / Avg: 107030.33 / Max: 107600

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Read - Clients: 64XFSEXT430060090012001500SE +/- 13.39, N = 6SE +/- 5.70, N = 31352633
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Read - Clients: 64XFSEXT42004006008001000Min: 1324 / Avg: 1352.33 / Max: 1409Min: 626 / Avg: 632.67 / Max: 644

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Read - Clients: 64XFSEXT420K40K60K80K100KSE +/- 460.72, N = 6SE +/- 931.32, N = 347175100261
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Read - Clients: 64XFSEXT420K40K60K80K100KMin: 45231 / Avg: 47174.67 / Max: 48175Min: 98399 / Avg: 100261.33 / Max: 101222

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Read - Clients: 32XFSEXT4100200300400500SE +/- 5.12, N = 4SE +/- 1.86, N = 3468352
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Read - Clients: 32XFSEXT480160240320400Min: 454 / Avg: 467.5 / Max: 478Min: 348 / Avg: 351.67 / Max: 354

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Read - Clients: 32XFSEXT420K40K60K80K100KSE +/- 741.01, N = 4SE +/- 460.85, N = 36795790063
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Read - Clients: 32XFSEXT416K32K48K64K80KMin: 66397 / Avg: 67956.5 / Max: 69892Min: 89440 / Avg: 90063.33 / Max: 90963

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 16XFSEXT470140210280350SE +/- 4.16, N = 3SE +/- 2.30, N = 15325262
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 16XFSEXT460120180240300Min: 317 / Avg: 325 / Max: 331Min: 252 / Avg: 261.8 / Max: 286

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 16XFSEXT413K26K39K52K65KSE +/- 649.38, N = 3SE +/- 505.75, N = 154903860689
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 16XFSEXT411K22K33K44K55KMin: 48115 / Avg: 49038.33 / Max: 50291Min: 55573 / Avg: 60689.4 / Max: 63073

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 32XFSEXT4120240360480600SE +/- 6.53, N = 15SE +/- 4.40, N = 15569473
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 32XFSEXT4100200300400500Min: 550 / Avg: 569.13 / Max: 649Min: 453 / Avg: 472.93 / Max: 520

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 32XFSEXT414K28K42K56K70KSE +/- 591.92, N = 15SE +/- 603.25, N = 155596667261
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 32XFSEXT412K24K36K48K60KMin: 48922 / Avg: 55966.27 / Max: 57841Min: 60970 / Avg: 67260.8 / Max: 70054

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: 1000 - Clients: 500 - Mode: Read WriteXFSEXT411002200330044005500SE +/- 29.81, N = 3SE +/- 22.33, N = 3501442231. (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: 500 - Mode: Read WriteXFSEXT49001800270036004500Min: 4957.25 / Avg: 5014.13 / Max: 5058.04Min: 4192.17 / Avg: 4223.1 / Max: 4266.471. (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: 500 - Mode: Read Write - Average LatencyXFSEXT4306090120150SE +/- 0.60, N = 3SE +/- 0.62, N = 399.73118.401. (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: 500 - Mode: Read Write - Average LatencyXFSEXT420406080100Min: 98.85 / Avg: 99.73 / Max: 100.86Min: 117.19 / Avg: 118.4 / Max: 119.271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Read - Clients: 16XFSEXT460120180240300SE +/- 2.02, N = 9SE +/- 2.33, N = 3263223
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Read - Clients: 16XFSEXT450100150200250Min: 257 / Avg: 263.11 / Max: 275Min: 219 / Avg: 223.33 / Max: 227

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Increment - Clients: 1XFSEXT460120180240300SE +/- 3.68, N = 15SE +/- 2.33, N = 3263223
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Increment - Clients: 1XFSEXT450100150200250Min: 254 / Avg: 263.47 / Max: 311Min: 219 / Avg: 223.33 / Max: 227

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Read - Clients: 16XFSEXT415K30K45K60K75KSE +/- 473.67, N = 9SE +/- 706.49, N = 36021670930
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Read - Clients: 16XFSEXT412K24K36K48K60KMin: 57444 / Avg: 60216.33 / Max: 61666Min: 69805 / Avg: 70930.33 / Max: 72233

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Increment - Clients: 1XFSEXT410002000300040005000SE +/- 47.01, N = 15SE +/- 46.72, N = 337824452
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Increment - Clients: 1XFSEXT48001600240032004000Min: 3190 / Avg: 3781.93 / Max: 3911Min: 4379 / Avg: 4452 / Max: 4539

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 32XFSEXT4110220330440550SE +/- 6.03, N = 3SE +/- 4.81, N = 3502432
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 32XFSEXT490180270360450Min: 495 / Avg: 502 / Max: 514Min: 423 / Avg: 432.33 / Max: 439

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 32XFSEXT416K32K48K64K80KSE +/- 782.94, N = 3SE +/- 849.17, N = 36351873558
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 32XFSEXT413K26K39K52K65KMin: 61956 / Avg: 63517.67 / Max: 64398Min: 72330 / Avg: 73558 / Max: 75188

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: 1000 - Clients: 250 - Mode: Read WriteXFSEXT48001600240032004000SE +/- 29.98, N = 3SE +/- 9.96, N = 3369832421. (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: 250 - Mode: Read WriteXFSEXT46001200180024003000Min: 3639.94 / Avg: 3698.18 / Max: 3739.67Min: 3230.83 / Avg: 3242.24 / Max: 3262.091. (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: 250 - Mode: Read Write - Average LatencyXFSEXT420406080100SE +/- 0.55, N = 3SE +/- 0.24, N = 367.6177.111. (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: 250 - Mode: Read Write - Average LatencyXFSEXT41530456075Min: 66.85 / Avg: 67.61 / Max: 68.68Min: 76.64 / Avg: 77.11 / Max: 77.381. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Read - Clients: 1XFSEXT44080120160200SE +/- 1.44, N = 15SE +/- 1.89, N = 5149166
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Read - Clients: 1XFSEXT4306090120150Min: 143 / Avg: 148.93 / Max: 166Min: 163 / Avg: 165.6 / Max: 173

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Read - Clients: 1XFSEXT414002800420056007000SE +/- 59.65, N = 15SE +/- 65.40, N = 566485980
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Read - Clients: 1XFSEXT412002400360048006000Min: 5962 / Avg: 6648.27 / Max: 6893Min: 5726 / Avg: 5979.8 / Max: 6080

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Write - Clients: 1XFSEXT448121620SE +/- 0.24, N = 15SE +/- 0.23, N = 131718
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Write - Clients: 1XFSEXT4510152025Min: 16 / Avg: 17.47 / Max: 20Min: 17 / Avg: 17.77 / Max: 20

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Increment - Clients: 4XFSEXT470140210280350SE +/- 3.59, N = 4SE +/- 2.89, N = 3325308
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Increment - Clients: 4XFSEXT460120180240300Min: 317 / Avg: 324.75 / Max: 334Min: 303 / Avg: 308 / Max: 313

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Increment - Clients: 4XFSEXT43K6K9K12K15KSE +/- 140.72, N = 4SE +/- 138.30, N = 31224412905
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Increment - Clients: 4XFSEXT42K4K6K8K10KMin: 11877 / Avg: 12243.5 / Max: 12534Min: 12663 / Avg: 12905.33 / Max: 13142

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 64XFSEXT42004006008001000SE +/- 14.49, N = 9SE +/- 5.24, N = 3819778
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 64XFSEXT4140280420560700Min: 776 / Avg: 819.22 / Max: 899Min: 768 / Avg: 777.67 / Max: 786

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Increment - Clients: 16XFSEXT47K14K21K28K35KSE +/- 243.82, N = 3SE +/- 262.12, N = 33234933959
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Increment - Clients: 16XFSEXT46K12K18K24K30KMin: 31867 / Avg: 32349 / Max: 32654Min: 33562 / Avg: 33959 / Max: 34454

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Increment - Clients: 16XFSEXT4110220330440550SE +/- 3.51, N = 3SE +/- 3.48, N = 3491468
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Increment - Clients: 16XFSEXT490180270360450Min: 487 / Avg: 491 / Max: 498Min: 462 / Avg: 467.67 / Max: 474

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 64XFSEXT420K40K60K80K100KSE +/- 1325.65, N = 9SE +/- 527.81, N = 37794081765
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 64XFSEXT414K28K42K56K70KMin: 70821 / Avg: 77940.33 / Max: 82112Min: 80915 / Avg: 81764.67 / Max: 82732

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Read - Clients: 4XFSEXT44080120160200SE +/- 1.89, N = 5SE +/- 0.88, N = 3173166
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Read - Clients: 4XFSEXT4306090120150Min: 168 / Avg: 172.6 / Max: 179Min: 164 / Avg: 165.67 / Max: 167

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Read - Clients: 4XFSEXT45K10K15K20K25KSE +/- 250.88, N = 5SE +/- 119.26, N = 32292723872
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Read - Clients: 4XFSEXT44K8K12K16K20KMin: 22076 / Avg: 22926.8 / Max: 23548Min: 23651 / Avg: 23872.33 / Max: 24060

Facebook RocksDB

This is a benchmark of Facebook's RocksDB as an embeddable persistent key-value store for fast storage based on Google's LevelDB. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 6.22.1Test: Update RandomXFSEXT430K60K90K120K150KSE +/- 1044.42, N = 3SE +/- 966.89, N = 31385751333361. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread
OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 6.22.1Test: Update RandomXFSEXT420K40K60K80K100KMin: 136487 / Avg: 138575.33 / Max: 139659Min: 131427 / Avg: 133335.67 / Max: 1345591. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Increment - Clients: 32XFSEXT42004006008001000SE +/- 7.33, N = 3SE +/- 1.00, N = 3775746
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Increment - Clients: 32XFSEXT4140280420560700Min: 768 / Avg: 775.33 / Max: 790Min: 744 / Avg: 746 / Max: 747

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Increment - Clients: 32XFSEXT49K18K27K36K45KSE +/- 450.19, N = 3SE +/- 40.16, N = 34103842608
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Increment - Clients: 32XFSEXT47K14K21K28K35KMin: 40138 / Avg: 41038.33 / Max: 41496Min: 42529 / Avg: 42607.67 / Max: 42661

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: 1000 - Clients: 500 - Mode: Read OnlyXFSEXT440K80K120K160K200KSE +/- 464.17, N = 3SE +/- 917.32, N = 31763251699581. (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: 500 - Mode: Read OnlyXFSEXT430K60K90K120K150KMin: 175559.87 / Avg: 176325.29 / Max: 177162.93Min: 168946.3 / Avg: 169958.01 / Max: 171789.31. (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: 500 - Mode: Read Only - Average LatencyXFSEXT40.6621.3241.9862.6483.31SE +/- 0.008, N = 3SE +/- 0.016, N = 32.8362.9421. (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: 500 - Mode: Read Only - Average LatencyXFSEXT4246810Min: 2.82 / Avg: 2.84 / Max: 2.85Min: 2.91 / Avg: 2.94 / Max: 2.961. (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 WriteXFSEXT43K6K9K12K15KSE +/- 88.54, N = 3SE +/- 80.58, N = 311991116141. (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 WriteXFSEXT42K4K6K8K10KMin: 11814.51 / Avg: 11990.5 / Max: 12095.43Min: 11512.76 / Avg: 11614.15 / Max: 11773.321. (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 LatencyXFSEXT4510152025SE +/- 0.15, N = 3SE +/- 0.15, N = 320.8521.531. (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 LatencyXFSEXT4510152025Min: 20.67 / Avg: 20.85 / Max: 21.16Min: 21.23 / Avg: 21.53 / Max: 21.721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 1XFSEXT44080120160200SE +/- 2.11, N = 15SE +/- 1.51, N = 15160155
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 1XFSEXT4306090120150Min: 154 / Avg: 159.6 / Max: 187Min: 150 / Avg: 154.93 / Max: 174

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average LatencyXFSEXT41020304050SE +/- 0.52, N = 3SE +/- 0.63, N = 343.9245.281. (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: 500 - Mode: Read Write - Average LatencyXFSEXT4918273645Min: 42.9 / Avg: 43.92 / Max: 44.55Min: 44.3 / Avg: 45.28 / Max: 46.471. (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: 500 - Mode: Read WriteXFSEXT42K4K6K8K10KSE +/- 134.98, N = 3SE +/- 153.46, N = 311387110471. (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: 500 - Mode: Read WriteXFSEXT42K4K6K8K10KMin: 11223.72 / Avg: 11387.19 / Max: 11654.98Min: 10760.52 / Avg: 11046.78 / Max: 11285.781. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 1XFSEXT414002800420056007000SE +/- 72.29, N = 15SE +/- 57.80, N = 1562146392
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 1XFSEXT411002200330044005500Min: 5296 / Avg: 6214.27 / Max: 6405Min: 5677 / Avg: 6392.13 / Max: 6597

Apache Cassandra

This is a benchmark of the Apache Cassandra NoSQL database management system making use of cassandra-stress. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOp/s, More Is BetterApache Cassandra 4.0Test: Mixed 1:3XFSEXT414K28K42K56K70KSE +/- 668.69, N = 12SE +/- 601.71, N = 76517566998
OpenBenchmarking.orgOp/s, More Is BetterApache Cassandra 4.0Test: Mixed 1:3XFSEXT412K24K36K48K60KMin: 61390 / Avg: 65174.92 / Max: 68881Min: 64879 / Avg: 66997.86 / Max: 69711

SQLite

This is a simple benchmark of SQLite. At present this test profile just measures the time to perform a pre-defined number of insertions on an indexed database. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 1XFSEXT40.72951.4592.18852.9183.6475SE +/- 0.019, N = 3SE +/- 0.005, N = 33.2423.1591. (CC) gcc options: -O2 -lz -lm -ldl -lpthread
OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 1XFSEXT4246810Min: 3.22 / Avg: 3.24 / Max: 3.28Min: 3.15 / Avg: 3.16 / Max: 3.171. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average LatencyXFSEXT4246810SE +/- 0.051, N = 3SE +/- 0.059, N = 38.0888.3001. (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: 100 - Mode: Read Write - Average LatencyXFSEXT43691215Min: 7.99 / Avg: 8.09 / Max: 8.16Min: 8.24 / Avg: 8.3 / Max: 8.421. (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: 100 - Mode: Read WriteXFSEXT43K6K9K12K15KSE +/- 78.18, N = 3SE +/- 85.22, N = 312364120501. (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: 100 - Mode: Read WriteXFSEXT42K4K6K8K10KMin: 12259.55 / Avg: 12364.34 / Max: 12517.22Min: 11879.48 / Avg: 12049.89 / Max: 12138.041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Redis

Redis is an open-source in-memory data structure store, used as a database, cache, and message broker. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 6.0.9Test: SETXFSEXT4200K400K600K800K1000KSE +/- 3946.38, N = 3SE +/- 10546.64, N = 3857147.73878810.461. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 6.0.9Test: SETXFSEXT4150K300K450K600K750KMin: 850764.44 / Avg: 857147.73 / Max: 864359.56Min: 862834.88 / Avg: 878810.46 / Max: 898726.381. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 128XFSEXT430060090012001500SE +/- 4.81, N = 3SE +/- 4.67, N = 313001332
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 128XFSEXT42004006008001000Min: 1291 / Avg: 1300.33 / Max: 1307Min: 1325 / Avg: 1332.33 / Max: 1341

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 128XFSEXT420K40K60K80K100KSE +/- 313.48, N = 3SE +/- 278.67, N = 39772495539
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 128XFSEXT420K40K60K80K100KMin: 97296 / Avg: 97724.33 / Max: 98335Min: 95016 / Avg: 95539.33 / Max: 95967

Facebook RocksDB

This is a benchmark of Facebook's RocksDB as an embeddable persistent key-value store for fast storage based on Google's LevelDB. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 6.22.1Test: Random FillXFSEXT430K60K90K120K150KSE +/- 1431.41, N = 3SE +/- 1137.72, N = 31499151465941. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread
OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 6.22.1Test: Random FillXFSEXT430K60K90K120K150KMin: 147292 / Avg: 149914.67 / Max: 152220Min: 145230 / Avg: 146593.67 / Max: 1488531. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

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: 100 - Mode: Read OnlyXFSEXT450K100K150K200K250KSE +/- 517.47, N = 3SE +/- 1749.85, N = 32157402110821. (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: 100 - Mode: Read OnlyXFSEXT440K80K120K160K200KMin: 214764.54 / Avg: 215740.43 / Max: 216526.79Min: 207777.27 / Avg: 211082.15 / Max: 213731.721. (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: 50 - Mode: Read Write - Average LatencyXFSEXT40.93331.86662.79993.73324.6665SE +/- 0.040, N = 3SE +/- 0.037, N = 84.0594.1481. (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: 50 - Mode: Read Write - Average LatencyXFSEXT4246810Min: 3.99 / Avg: 4.06 / Max: 4.13Min: 4.05 / Avg: 4.15 / Max: 4.321. (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: 50 - Mode: Read WriteXFSEXT43K6K9K12K15KSE +/- 121.71, N = 3SE +/- 106.55, N = 812322120611. (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: 50 - Mode: Read WriteXFSEXT42K4K6K8K10KMin: 12110.45 / Avg: 12322.34 / Max: 12532.04Min: 11567.01 / Avg: 12060.54 / Max: 12346.261. (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: 100 - Mode: Read Only - Average LatencyXFSEXT40.10670.21340.32010.42680.5335SE +/- 0.001, N = 3SE +/- 0.004, N = 30.4640.4741. (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: 100 - Mode: Read Only - Average LatencyXFSEXT412345Min: 0.46 / Avg: 0.46 / Max: 0.47Min: 0.47 / Avg: 0.47 / Max: 0.481. (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: 500 - Mode: Read Only - Average LatencyXFSEXT40.52671.05341.58012.10682.6335SE +/- 0.012, N = 3SE +/- 0.010, N = 32.2922.3411. (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: 500 - Mode: Read Only - Average LatencyXFSEXT4246810Min: 2.27 / Avg: 2.29 / Max: 2.32Min: 2.32 / Avg: 2.34 / Max: 2.361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read OnlyXFSEXT450K100K150K200K250KSE +/- 1176.20, N = 3SE +/- 936.66, N = 32181022136101. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read OnlyXFSEXT440K80K120K160K200KMin: 215965.54 / Avg: 218102.41 / Max: 220022.72Min: 212345.97 / Avg: 213610.15 / Max: 215439.481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Redis

Redis is an open-source in-memory data structure store, used as a database, cache, and message broker. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 6.0.9Test: SADDXFSEXT4200K400K600K800K1000KSE +/- 9058.69, N = 3SE +/- 12939.69, N = 3883258.92899392.791. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 6.0.9Test: SADDXFSEXT4160K320K480K640K800KMin: 867238.56 / Avg: 883258.92 / Max: 898596.5Min: 873930.25 / Avg: 899392.79 / Max: 916130.441. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 4XFSEXT42K4K6K8K10KSE +/- 77.44, N = 3SE +/- 47.05, N = 385568403
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 4XFSEXT415003000450060007500Min: 8413 / Avg: 8556 / Max: 8679Min: 8321 / Avg: 8402.67 / Max: 8484

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average LatencyXFSEXT40.28940.57880.86821.15761.447SE +/- 0.002, N = 3SE +/- 0.004, N = 31.2861.2641. (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: 250 - Mode: Read Only - Average LatencyXFSEXT4246810Min: 1.28 / Avg: 1.29 / Max: 1.29Min: 1.26 / Avg: 1.26 / Max: 1.271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 4XFSEXT4100200300400500SE +/- 4.36, N = 3SE +/- 2.60, N = 3466474
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 4XFSEXT480160240320400Min: 459 / Avg: 466 / Max: 474Min: 470 / Avg: 474.33 / Max: 479

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: 1000 - Clients: 250 - Mode: Read OnlyXFSEXT440K80K120K160K200KSE +/- 269.64, N = 3SE +/- 670.87, N = 31944101977401. (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: 250 - Mode: Read OnlyXFSEXT430K60K90K120K150KMin: 193870.89 / Avg: 194409.5 / Max: 194702.09Min: 196514.77 / Avg: 197739.97 / Max: 198826.261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Apache CouchDB

This is a bulk insertion benchmark of Apache CouchDB. CouchDB is a document-oriented NoSQL database implemented in Erlang. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterApache CouchDB 3.2.1Bulk Size: 100 - Inserts: 1000 - Rounds: 24XFSEXT4306090120150SE +/- 0.47, N = 3SE +/- 1.03, N = 7110.57112.381. (CXX) g++ options: -std=c++14 -lmozjs-68 -lm -lei -fPIC -MMD
OpenBenchmarking.orgSeconds, Fewer Is BetterApache CouchDB 3.2.1Bulk Size: 100 - Inserts: 1000 - Rounds: 24XFSEXT420406080100Min: 109.69 / Avg: 110.57 / Max: 111.27Min: 109.51 / Avg: 112.38 / Max: 118.051. (CXX) g++ options: -std=c++14 -lmozjs-68 -lm -lei -fPIC -MMD

LevelDB

LevelDB is a key-value storage library developed by Google that supports making use of Snappy for data compression and has other modern features. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Fill SyncXFSEXT4246810SE +/- 0.06, N = 3SE +/- 0.03, N = 36.56.41. (CXX) g++ options: -O3 -lsnappy -lpthread
OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Fill SyncXFSEXT43691215Min: 6.4 / Avg: 6.5 / Max: 6.6Min: 6.4 / Avg: 6.43 / Max: 6.51. (CXX) g++ options: -O3 -lsnappy -lpthread

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average LatencyXFSEXT40.01710.03420.05130.06840.0855SE +/- 0.000, N = 3SE +/- 0.001, N = 30.0750.0761. (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 Only - Average LatencyXFSEXT412345Min: 0.07 / Avg: 0.07 / Max: 0.08Min: 0.08 / Avg: 0.08 / Max: 0.081. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

InfluxDB

This is a benchmark of the InfluxDB open-source time-series database optimized for fast, high-availability storage for IoT and other use-cases. The InfluxDB test profile makes use of InfluxDB Inch for facilitating the benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgval/sec, More Is BetterInfluxDB 1.8.2Concurrent Streams: 4 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000XFSEXT4200K400K600K800K1000KSE +/- 4939.53, N = 3SE +/- 1636.42, N = 3848341.6859395.6
OpenBenchmarking.orgval/sec, More Is BetterInfluxDB 1.8.2Concurrent Streams: 4 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000XFSEXT4150K300K450K600K750KMin: 842972.5 / Avg: 848341.57 / Max: 858207.8Min: 856459.9 / Avg: 859395.63 / Max: 862116.4

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average LatencyXFSEXT4816243240SE +/- 0.23, N = 3SE +/- 0.22, N = 334.6335.071. (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: 100 - Mode: Read Write - Average LatencyXFSEXT4714212835Min: 34.26 / Avg: 34.63 / Max: 35.06Min: 34.63 / Avg: 35.07 / Max: 35.321. (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: 100 - Mode: Read WriteXFSEXT46001200180024003000SE +/- 19.33, N = 3SE +/- 18.10, N = 3288828521. (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: 100 - Mode: Read WriteXFSEXT45001000150020002500Min: 2852.21 / Avg: 2887.76 / Max: 2918.7Min: 2831.47 / Avg: 2851.52 / Max: 2887.651. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 64XFSEXT46K12K18K24K30KSE +/- 254.18, N = 3SE +/- 250.74, N = 32980630182
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 64XFSEXT45K10K15K20K25KMin: 29421 / Avg: 29806 / Max: 30286Min: 29739 / Avg: 30182.33 / Max: 30607

LevelDB

LevelDB is a key-value storage library developed by Google that supports making use of Snappy for data compression and has other modern features. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: OverwriteXFSEXT460120180240300SE +/- 0.32, N = 3SE +/- 0.36, N = 3292.07288.501. (CXX) g++ options: -O3 -lsnappy -lpthread
OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: OverwriteXFSEXT450100150200250Min: 291.46 / Avg: 292.07 / Max: 292.51Min: 287.94 / Avg: 288.5 / Max: 289.181. (CXX) g++ options: -O3 -lsnappy -lpthread

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 64XFSEXT45001000150020002500SE +/- 18.77, N = 3SE +/- 18.21, N = 321412115
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 64XFSEXT4400800120016002000Min: 2106 / Avg: 2141.33 / Max: 2170Min: 2084 / Avg: 2114.67 / Max: 2147

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: 1000 - Clients: 100 - Mode: Read OnlyXFSEXT440K80K120K160K200KSE +/- 354.76, N = 3SE +/- 701.91, N = 31942301918841. (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: 100 - Mode: Read OnlyXFSEXT430K60K90K120K150KMin: 193531.62 / Avg: 194230.04 / Max: 194687.54Min: 190683.15 / Avg: 191884.2 / Max: 193114.111. (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 LatencyXFSEXT40.25110.50220.75331.00441.2555SE +/- 0.003, N = 3SE +/- 0.002, N = 31.1031.1161. (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 LatencyXFSEXT4246810Min: 1.1 / Avg: 1.1 / Max: 1.11Min: 1.11 / Avg: 1.12 / Max: 1.121. (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: 100 - Mode: Read Only - Average LatencyXFSEXT40.11720.23440.35160.46880.586SE +/- 0.001, N = 3SE +/- 0.002, N = 30.5150.5211. (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: 100 - Mode: Read Only - Average LatencyXFSEXT4246810Min: 0.51 / Avg: 0.52 / Max: 0.52Min: 0.52 / Avg: 0.52 / Max: 0.521. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read OnlyXFSEXT450K100K150K200K250KSE +/- 1017.69, N = 3SE +/- 435.69, N = 32420592392721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read OnlyXFSEXT440K80K120K160K200KMin: 240226.93 / Avg: 242059.2 / Max: 243742.92Min: 238497.74 / Avg: 239271.98 / Max: 240005.361. (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: 250 - Mode: Read Only - Average LatencyXFSEXT40.23510.47020.70530.94041.1755SE +/- 0.004, N = 3SE +/- 0.002, N = 31.0331.0451. (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: 250 - Mode: Read Only - Average LatencyXFSEXT4246810Min: 1.03 / Avg: 1.03 / Max: 1.04Min: 1.04 / Avg: 1.05 / Max: 1.051. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read OnlyXFSEXT43K6K9K12K15KSE +/- 32.01, N = 3SE +/- 93.30, N = 313398132471. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read OnlyXFSEXT42K4K6K8K10KMin: 13362.49 / Avg: 13398.01 / Max: 13461.91Min: 13066.54 / Avg: 13246.99 / Max: 13378.351. (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 OnlyXFSEXT450K100K150K200K250KSE +/- 688.93, N = 3SE +/- 466.97, N = 32265822240471. (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 OnlyXFSEXT440K80K120K160K200KMin: 225616.15 / Avg: 226581.99 / Max: 227915.93Min: 223121.14 / Avg: 224047.09 / Max: 224615.581. (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: 50 - Mode: Read Write - Average LatencyXFSEXT448121620SE +/- 0.04, N = 3SE +/- 0.01, N = 313.9413.781. (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: 50 - Mode: Read Write - Average LatencyXFSEXT448121620Min: 13.86 / Avg: 13.94 / Max: 13.98Min: 13.77 / Avg: 13.78 / Max: 13.811. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read WriteXFSEXT48001600240032004000SE +/- 9.88, N = 3SE +/- 3.19, N = 3358736271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read WriteXFSEXT46001200180024003000Min: 3576.55 / Avg: 3587.01 / Max: 3606.75Min: 3621.03 / Avg: 3627.37 / Max: 3631.271. (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 Only - Average LatencyXFSEXT40.02070.04140.06210.08280.1035SE +/- 0.001, N = 3SE +/- 0.001, N = 30.0920.0911. (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 Only - Average LatencyXFSEXT412345Min: 0.09 / Avg: 0.09 / Max: 0.09Min: 0.09 / Avg: 0.09 / Max: 0.091. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

InfluxDB

This is a benchmark of the InfluxDB open-source time-series database optimized for fast, high-availability storage for IoT and other use-cases. The InfluxDB test profile makes use of InfluxDB Inch for facilitating the benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgval/sec, More Is BetterInfluxDB 1.8.2Concurrent Streams: 64 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000XFSEXT4200K400K600K800K1000KSE +/- 2719.95, N = 3SE +/- 354.79, N = 3877126.2886748.9
OpenBenchmarking.orgval/sec, More Is BetterInfluxDB 1.8.2Concurrent Streams: 64 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000XFSEXT4150K300K450K600K750KMin: 873636.5 / Avg: 877126.17 / Max: 882485Min: 886304 / Avg: 886748.93 / Max: 887450.1

Facebook RocksDB

This is a benchmark of Facebook's RocksDB as an embeddable persistent key-value store for fast storage based on Google's LevelDB. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 6.22.1Test: Sequential FillXFSEXT430K60K90K120K150KSE +/- 641.02, N = 3SE +/- 1750.15, N = 31497871481831. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread
OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 6.22.1Test: Sequential FillXFSEXT430K60K90K120K150KMin: 148507 / Avg: 149786.67 / Max: 150494Min: 146332 / Avg: 148182.67 / Max: 1516811. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 1XFSEXT480160240320400SE +/- 5.00, N = 3SE +/- 3.33, N = 3387383
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 1XFSEXT470140210280350Min: 382 / Avg: 387 / Max: 397Min: 380 / Avg: 383.33 / Max: 390

Redis

Redis is an open-source in-memory data structure store, used as a database, cache, and message broker. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 6.0.9Test: GETXFSEXT4200K400K600K800K1000KSE +/- 3146.20, N = 3SE +/- 4177.59, N = 3882156.81873340.331. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 6.0.9Test: GETXFSEXT4150K300K450K600K750KMin: 876568.31 / Avg: 882156.81 / Max: 887455.5Min: 865002 / Avg: 873340.33 / Max: 877968.691. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 1XFSEXT46001200180024003000SE +/- 32.67, N = 3SE +/- 22.01, N = 325722597
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 1XFSEXT45001000150020002500Min: 2507 / Avg: 2572.33 / Max: 2606Min: 2553 / Avg: 2597 / Max: 2620

Apache Cassandra

This is a benchmark of the Apache Cassandra NoSQL database management system making use of cassandra-stress. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOp/s, More Is BetterApache Cassandra 4.0Test: WritesXFSEXT420K40K60K80K100KSE +/- 353.38, N = 3SE +/- 670.12, N = 87826978980
OpenBenchmarking.orgOp/s, More Is BetterApache Cassandra 4.0Test: WritesXFSEXT414K28K42K56K70KMin: 77565 / Avg: 78269 / Max: 78675Min: 77006 / Avg: 78980 / Max: 83228

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Write - Clients: 1XFSEXT412K24K36K48K60KSE +/- 624.11, N = 15SE +/- 611.63, N = 135435953879
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Write - Clients: 1XFSEXT49K18K27K36K45KMin: 47427 / Avg: 54359 / Max: 57737Min: 47630 / Avg: 53878.77 / Max: 56290

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: 1000 - Clients: 1 - Mode: Read WriteXFSEXT430060090012001500SE +/- 3.75, N = 3SE +/- 1.22, N = 3159815841. (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 WriteXFSEXT430060090012001500Min: 1590.74 / Avg: 1598.11 / Max: 1602.97Min: 1582.4 / Avg: 1583.86 / Max: 1586.281. (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: 50 - Mode: Read Only - Average LatencyXFSEXT40.05220.10440.15660.20880.261SE +/- 0.000, N = 3SE +/- 0.001, N = 30.2300.2321. (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: 50 - Mode: Read Only - Average LatencyXFSEXT412345Min: 0.23 / Avg: 0.23 / Max: 0.23Min: 0.23 / Avg: 0.23 / Max: 0.231. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

InfluxDB

This is a benchmark of the InfluxDB open-source time-series database optimized for fast, high-availability storage for IoT and other use-cases. The InfluxDB test profile makes use of InfluxDB Inch for facilitating the benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgval/sec, More Is BetterInfluxDB 1.8.2Concurrent Streams: 1024 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000XFSEXT4200K400K600K800K1000KSE +/- 2255.62, N = 3SE +/- 1298.48, N = 3860201.8867557.9
OpenBenchmarking.orgval/sec, More Is BetterInfluxDB 1.8.2Concurrent Streams: 1024 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000XFSEXT4150K300K450K600K750KMin: 857126.1 / Avg: 860201.8 / Max: 864597.7Min: 866245.1 / Avg: 867557.9 / Max: 870154.8

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average LatencyXFSEXT40.57471.14941.72412.29882.8735SE +/- 0.007, N = 3SE +/- 0.012, N = 32.5332.5541. (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: 500 - Mode: Read Only - Average LatencyXFSEXT4246810Min: 2.52 / Avg: 2.53 / Max: 2.55Min: 2.54 / Avg: 2.55 / Max: 2.581. (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: 500 - Mode: Read OnlyXFSEXT440K80K120K160K200KSE +/- 548.17, N = 3SE +/- 906.00, N = 31974041957811. (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: 500 - Mode: Read OnlyXFSEXT430K60K90K120K150KMin: 196345.19 / Avg: 197404.14 / Max: 198179.44Min: 194074.24 / Avg: 195781.44 / Max: 197160.991. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

LevelDB

LevelDB is a key-value storage library developed by Google that supports making use of Snappy for data compression and has other modern features. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: OverwriteXFSEXT43691215SE +/- 0.00, N = 3SE +/- 0.00, N = 312.112.21. (CXX) g++ options: -O3 -lsnappy -lpthread
OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: OverwriteXFSEXT448121620Min: 12.1 / Avg: 12.1 / Max: 12.1Min: 12.2 / Avg: 12.2 / Max: 12.21. (CXX) g++ options: -O3 -lsnappy -lpthread

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Random FillXFSEXT43691215SE +/- 0.00, N = 3SE +/- 0.03, N = 312.212.31. (CXX) g++ options: -O3 -lsnappy -lpthread
OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Random FillXFSEXT448121620Min: 12.2 / Avg: 12.2 / Max: 12.2Min: 12.2 / Avg: 12.27 / Max: 12.31. (CXX) g++ options: -O3 -lsnappy -lpthread

Redis

Redis is an open-source in-memory data structure store, used as a database, cache, and message broker. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 6.0.9Test: LPOPXFSEXT4200K400K600K800K1000KSE +/- 4956.07, N = 3SE +/- 3329.62, N = 3873824.56880911.581. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 6.0.9Test: LPOPXFSEXT4150K300K450K600K750KMin: 864999.25 / Avg: 873824.56 / Max: 882145.31Min: 877207.06 / Avg: 880911.58 / Max: 887556.191. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average LatencyXFSEXT40.1420.2840.4260.5680.71SE +/- 0.002, N = 3SE +/- 0.001, N = 30.6260.6311. (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 LatencyXFSEXT4246810Min: 0.62 / Avg: 0.63 / Max: 0.63Min: 0.63 / Avg: 0.63 / Max: 0.631. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 4XFSEXT45K10K15K20K25KSE +/- 201.09, N = 15SE +/- 217.88, N = 152156521404
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 4XFSEXT44K8K12K16K20KMin: 19377 / Avg: 21565.2 / Max: 22509Min: 18777 / Avg: 21403.8 / Max: 22317

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Increment - Clients: 64XFSEXT430060090012001500SE +/- 13.00, N = 3SE +/- 7.57, N = 314821493
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Increment - Clients: 64XFSEXT430060090012001500Min: 1459 / Avg: 1482 / Max: 1504Min: 1479 / Avg: 1493 / Max: 1505

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Increment - Clients: 64XFSEXT49K18K27K36K45KSE +/- 329.46, N = 3SE +/- 167.74, N = 34299842684
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Increment - Clients: 64XFSEXT47K14K21K28K35KMin: 42420 / Avg: 42998 / Max: 43561Min: 42396 / Avg: 42683.67 / Max: 42977

LevelDB

LevelDB is a key-value storage library developed by Google that supports making use of Snappy for data compression and has other modern features. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Fill SyncXFSEXT4120240360480600SE +/- 4.82, N = 3SE +/- 4.28, N = 3539.80543.771. (CXX) g++ options: -O3 -lsnappy -lpthread
OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Fill SyncXFSEXT4100200300400500Min: 534.26 / Avg: 539.8 / Max: 549.41Min: 535.44 / Avg: 543.77 / Max: 549.671. (CXX) g++ options: -O3 -lsnappy -lpthread

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: 1 - Clients: 50 - Mode: Read OnlyXFSEXT450K100K150K200K250KSE +/- 673.80, N = 3SE +/- 885.40, N = 32256982240841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read OnlyXFSEXT440K80K120K160K200KMin: 224671.08 / Avg: 225698.45 / Max: 226967.4Min: 223097.43 / Avg: 224084.38 / Max: 225851.131. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

KeyDB

A benchmark of KeyDB as a multi-threaded fork of the Redis server. The KeyDB benchmark is conducted using memtier-benchmark. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOps/sec, More Is BetterKeyDB 6.2.0XFSEXT470K140K210K280K350KSE +/- 3240.95, N = 3SE +/- 1831.29, N = 3319106.41321216.811. (CXX) g++ options: -O2 -levent_openssl -levent -lcrypto -lssl -lpthread -lz -lpcre
OpenBenchmarking.orgOps/sec, More Is BetterKeyDB 6.2.0XFSEXT460K120K180K240K300KMin: 313468.02 / Avg: 319106.41 / Max: 324694.67Min: 318722.4 / Avg: 321216.81 / Max: 324786.571. (CXX) g++ options: -O2 -levent_openssl -levent -lcrypto -lssl -lpthread -lz -lpcre

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: 1000 - Clients: 1 - Mode: Read OnlyXFSEXT42K4K6K8K10KSE +/- 121.75, N = 3SE +/- 79.57, N = 310911109831. (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 OnlyXFSEXT42K4K6K8K10KMin: 10692.08 / Avg: 10910.51 / Max: 11112.94Min: 10855.12 / Avg: 10982.88 / Max: 11128.931. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Increment - Clients: 128XFSEXT47001400210028003500SE +/- 39.56, N = 4SE +/- 36.84, N = 330583038
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Increment - Clients: 128XFSEXT45001000150020002500Min: 2939 / Avg: 3057.5 / Max: 3100Min: 2967 / Avg: 3038.33 / Max: 3090

Facebook RocksDB

This is a benchmark of Facebook's RocksDB as an embeddable persistent key-value store for fast storage based on Google's LevelDB. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 6.22.1Test: Read While WritingXFSEXT4500K1000K1500K2000K2500KSE +/- 30012.35, N = 3SE +/- 31860.75, N = 3239542824109871. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread
OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 6.22.1Test: Read While WritingXFSEXT4400K800K1200K1600K2000KMin: 2341793 / Avg: 2395428.33 / Max: 2445584Min: 2372218 / Avg: 2410987 / Max: 24741671. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 1XFSEXT414K28K42K56K70KSE +/- 803.17, N = 15SE +/- 946.43, N = 156573265319
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 1XFSEXT411K22K33K44K55KMin: 59032 / Avg: 65731.67 / Max: 69228Min: 55991 / Avg: 65319.33 / Max: 71301

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 32XFSEXT42004006008001000SE +/- 4.18, N = 3SE +/- 4.04, N = 311531146
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 32XFSEXT42004006008001000Min: 1148 / Avg: 1152.67 / Max: 1161Min: 1138 / Avg: 1146 / Max: 1151

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Increment - Clients: 128XFSEXT49K18K27K36K45KSE +/- 520.80, N = 4SE +/- 480.65, N = 34172541978
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Increment - Clients: 128XFSEXT47K14K21K28K35KMin: 41138 / Avg: 41724.5 / Max: 43284Min: 41292 / Avg: 41977.67 / Max: 42904

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: 50 - Mode: Read OnlyXFSEXT450K100K150K200K250KSE +/- 353.34, N = 3SE +/- 968.71, N = 32172222159371. (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: 50 - Mode: Read OnlyXFSEXT440K80K120K160K200KMin: 216604.86 / Avg: 217222.25 / Max: 217828.71Min: 214342.15 / Avg: 215937 / Max: 217687.071. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 32XFSEXT46K12K18K24K30KSE +/- 98.53, N = 3SE +/- 93.71, N = 32768527839
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 32XFSEXT45K10K15K20K25KMin: 27491 / Avg: 27684.67 / Max: 27813Min: 27726 / Avg: 27839 / Max: 28025

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 4XFSEXT44080120160200SE +/- 1.86, N = 15SE +/- 2.06, N = 15184185
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 4XFSEXT4306090120150Min: 176 / Avg: 184 / Max: 205Min: 178 / Avg: 185.4 / Max: 211

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average LatencyXFSEXT40.12920.25840.38760.51680.646SE +/- 0.003, N = 3SE +/- 0.002, N = 30.5740.5711. (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: 1 - Mode: Read Write - Average LatencyXFSEXT4246810Min: 0.57 / Avg: 0.57 / Max: 0.58Min: 0.57 / Avg: 0.57 / Max: 0.581. (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: 1 - Mode: Read WriteXFSEXT4400800120016002000SE +/- 8.81, N = 3SE +/- 6.13, N = 3174317511. (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: 1 - Mode: Read WriteXFSEXT430060090012001500Min: 1725.58 / Avg: 1742.94 / Max: 1754.27Min: 1740.61 / Avg: 1751.25 / Max: 1761.841. (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: 100 - Mode: Read Only - Average LatencyXFSEXT40.10010.20020.30030.40040.5005SE +/- 0.001, N = 3SE +/- 0.001, N = 30.4430.4451. (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: 100 - Mode: Read Only - Average LatencyXFSEXT412345Min: 0.44 / Avg: 0.44 / Max: 0.45Min: 0.44 / Avg: 0.45 / Max: 0.451. (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: 50 - Mode: Read Only - Average LatencyXFSEXT40.05020.10040.15060.20080.251SE +/- 0.001, N = 3SE +/- 0.001, N = 30.2220.2231. (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: 50 - Mode: Read Only - Average LatencyXFSEXT412345Min: 0.22 / Avg: 0.22 / Max: 0.22Min: 0.22 / Avg: 0.22 / Max: 0.221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 128XFSEXT46K12K18K24K30KSE +/- 178.78, N = 3SE +/- 110.41, N = 32986630000
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 128XFSEXT45K10K15K20K25KMin: 29529 / Avg: 29866 / Max: 30138Min: 29788 / Avg: 29999.67 / Max: 30160

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 128XFSEXT49001800270036004500SE +/- 26.27, N = 3SE +/- 15.77, N = 342734254
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 128XFSEXT47001400210028003500Min: 4234 / Avg: 4273 / Max: 4323Min: 4231 / Avg: 4253.67 / Max: 4284

LevelDB

LevelDB is a key-value storage library developed by Google that supports making use of Snappy for data compression and has other modern features. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random DeleteXFSEXT460120180240300SE +/- 0.24, N = 3SE +/- 0.20, N = 3289.40288.121. (CXX) g++ options: -O3 -lsnappy -lpthread
OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random DeleteXFSEXT450100150200250Min: 289.11 / Avg: 289.4 / Max: 289.88Min: 287.72 / Avg: 288.12 / Max: 288.361. (CXX) g++ options: -O3 -lsnappy -lpthread

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 64XFSEXT430060090012001500SE +/- 25.60, N = 9SE +/- 11.61, N = 313871381
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 64XFSEXT42004006008001000Min: 1342 / Avg: 1387.33 / Max: 1576Min: 1359 / Avg: 1381.33 / Max: 1398

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: 1 - Clients: 1 - Mode: Read WriteXFSEXT4400800120016002000SE +/- 2.19, N = 3SE +/- 14.82, N = 3188818801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read WriteXFSEXT430060090012001500Min: 1883.71 / Avg: 1887.98 / Max: 1890.96Min: 1850.29 / Avg: 1879.8 / Max: 1896.881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

LevelDB

LevelDB is a key-value storage library developed by Google that supports making use of Snappy for data compression and has other modern features. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random FillXFSEXT460120180240300SE +/- 0.38, N = 3SE +/- 0.66, N = 3288.49287.331. (CXX) g++ options: -O3 -lsnappy -lpthread
OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random FillXFSEXT450100150200250Min: 287.74 / Avg: 288.49 / Max: 288.99Min: 286.63 / Avg: 287.33 / Max: 288.651. (CXX) g++ options: -O3 -lsnappy -lpthread

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average LatencyXFSEXT40.05740.11480.17220.22960.287SE +/- 0.000, N = 3SE +/- 0.000, N = 30.2540.2551. (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: 50 - Mode: Read Only - Average LatencyXFSEXT412345Min: 0.25 / Avg: 0.25 / Max: 0.26Min: 0.25 / Avg: 0.25 / Max: 0.261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read OnlyXFSEXT450K100K150K200K250KSE +/- 560.78, N = 3SE +/- 402.72, N = 32256302247561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read OnlyXFSEXT440K80K120K160K200KMin: 224971.67 / Avg: 225629.92 / Max: 226745.47Min: 224289.82 / Avg: 224756.03 / Max: 225557.931. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

LevelDB

LevelDB is a key-value storage library developed by Google that supports making use of Snappy for data compression and has other modern features. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random ReadXFSEXT4816243240SE +/- 0.18, N = 3SE +/- 0.06, N = 335.5335.391. (CXX) g++ options: -O3 -lsnappy -lpthread
OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random ReadXFSEXT4816243240Min: 35.25 / Avg: 35.53 / Max: 35.87Min: 35.31 / Avg: 35.39 / Max: 35.511. (CXX) g++ options: -O3 -lsnappy -lpthread

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average LatencyXFSEXT40.11970.23940.35910.47880.5985SE +/- 0.001, N = 3SE +/- 0.004, N = 30.5300.5321. (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 LatencyXFSEXT4246810Min: 0.53 / Avg: 0.53 / Max: 0.53Min: 0.53 / Avg: 0.53 / Max: 0.541. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Apache Cassandra

This is a benchmark of the Apache Cassandra NoSQL database management system making use of cassandra-stress. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOp/s, More Is BetterApache Cassandra 4.0Test: Mixed 1:1XFSEXT414K28K42K56K70KSE +/- 670.05, N = 6SE +/- 805.19, N = 36748867250
OpenBenchmarking.orgOp/s, More Is BetterApache Cassandra 4.0Test: Mixed 1:1XFSEXT412K24K36K48K60KMin: 65896 / Avg: 67488.17 / Max: 69776Min: 65640 / Avg: 67250.33 / Max: 68065

Facebook RocksDB

This is a benchmark of Facebook's RocksDB as an embeddable persistent key-value store for fast storage based on Google's LevelDB. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 6.22.1Test: Random ReadXFSEXT410M20M30M40M50MSE +/- 442272.59, N = 3SE +/- 427414.69, N = 348239829480979251. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread
OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 6.22.1Test: Random ReadXFSEXT48M16M24M32M40MMin: 47362997 / Avg: 48239828.67 / Max: 48779189Min: 47243327 / Avg: 48097924.67 / Max: 485424591. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

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: 1 - Mode: Read OnlyXFSEXT43K6K9K12K15KSE +/- 43.12, N = 3SE +/- 46.38, N = 312840128771. (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: 1 - Mode: Read OnlyXFSEXT42K4K6K8K10KMin: 12780.16 / Avg: 12839.68 / Max: 12923.5Min: 12794.72 / Avg: 12877.01 / Max: 12955.241. (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: 50 - Mode: Read WriteXFSEXT46001200180024003000SE +/- 11.14, N = 3SE +/- 4.82, N = 3284728551. (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: 50 - Mode: Read WriteXFSEXT45001000150020002500Min: 2828.36 / Avg: 2847.41 / Max: 2866.93Min: 2848.13 / Avg: 2854.96 / Max: 2864.261. (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: 50 - Mode: Read Write - Average LatencyXFSEXT448121620SE +/- 0.07, N = 3SE +/- 0.03, N = 317.5617.511. (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: 50 - Mode: Read Write - Average LatencyXFSEXT448121620Min: 17.44 / Avg: 17.56 / Max: 17.68Min: 17.46 / Avg: 17.51 / Max: 17.561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

LevelDB

LevelDB is a key-value storage library developed by Google that supports making use of Snappy for data compression and has other modern features. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Sequential FillXFSEXT460120180240300SE +/- 0.70, N = 3SE +/- 0.97, N = 3288.98288.301. (CXX) g++ options: -O3 -lsnappy -lpthread
OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Sequential FillXFSEXT450100150200250Min: 287.66 / Avg: 288.98 / Max: 290.05Min: 286.48 / Avg: 288.3 / Max: 289.771. (CXX) g++ options: -O3 -lsnappy -lpthread

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 64XFSEXT410K20K30K40K50KSE +/- 776.29, N = 9SE +/- 399.45, N = 34605946162
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 64XFSEXT48K16K24K32K40KMin: 40423 / Avg: 46059 / Max: 47495Min: 45603 / Avg: 46162.33 / Max: 46936

SQLite Speedtest

This is a benchmark of SQLite's speedtest1 benchmark program with an increased problem size of 1,000. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite Speedtest 3.30Timed Time - Size 1,000XFSEXT4306090120150SE +/- 0.40, N = 3SE +/- 0.88, N = 3149.72149.391. (CC) gcc options: -O2 -ldl -lz -lpthread
OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite Speedtest 3.30Timed Time - Size 1,000XFSEXT4306090120150Min: 149.16 / Avg: 149.72 / Max: 150.51Min: 148.22 / Avg: 149.39 / Max: 151.121. (CC) gcc options: -O2 -ldl -lz -lpthread

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average LatencyXFSEXT4816243240SE +/- 0.33, N = 3SE +/- 0.18, N = 336.5336.601. (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: 100 - Mode: Read Write - Average LatencyXFSEXT4816243240Min: 35.88 / Avg: 36.53 / Max: 36.95Min: 36.23 / Avg: 36.6 / Max: 36.821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read WriteXFSEXT46001200180024003000SE +/- 25.01, N = 3SE +/- 13.77, N = 3273827331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read WriteXFSEXT45001000150020002500Min: 2706.21 / Avg: 2738.11 / Max: 2787.42Min: 2715.94 / Avg: 2732.65 / Max: 2759.951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Redis

Redis is an open-source in-memory data structure store, used as a database, cache, and message broker. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 6.0.9Test: LPUSHXFSEXT4200K400K600K800K1000KSE +/- 3139.63, N = 3SE +/- 3122.84, N = 3876195.46877540.981. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 6.0.9Test: LPUSHXFSEXT4150K300K450K600K750KMin: 870173.38 / Avg: 876195.46 / Max: 880746.88Min: 871341.25 / Avg: 877540.98 / Max: 881295.811. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

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: 1000 - Clients: 50 - Mode: Read OnlyXFSEXT440K80K120K160K200KSE +/- 352.21, N = 3SE +/- 172.61, N = 31965501962671. (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: 50 - Mode: Read OnlyXFSEXT430K60K90K120K150KMin: 195957.38 / Avg: 196549.77 / Max: 197176.07Min: 195943.92 / Avg: 196266.68 / Max: 196534.141. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

LevelDB

LevelDB is a key-value storage library developed by Google that supports making use of Snappy for data compression and has other modern features. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Hot ReadXFSEXT4816243240SE +/- 0.25, N = 15SE +/- 0.33, N = 335.2535.281. (CXX) g++ options: -O3 -lsnappy -lpthread
OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Hot ReadXFSEXT4816243240Min: 31.85 / Avg: 35.25 / Max: 35.92Min: 34.62 / Avg: 35.28 / Max: 35.681. (CXX) g++ options: -O3 -lsnappy -lpthread

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 16XFSEXT45K10K15K20K25KSE +/- 89.80, N = 3SE +/- 298.85, N = 32171721724
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 16XFSEXT44K8K12K16K20KMin: 21540 / Avg: 21716.67 / Max: 21833Min: 21232 / Avg: 21724.33 / Max: 22264

Facebook RocksDB

This is a benchmark of Facebook's RocksDB as an embeddable persistent key-value store for fast storage based on Google's LevelDB. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 6.22.1Test: Random Fill SyncXFSEXT414K28K42K56K70KSE +/- 71.15, N = 3SE +/- 81.04, N = 365252652631. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread
OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 6.22.1Test: Random Fill SyncXFSEXT411K22K33K44K55KMin: 65157 / Avg: 65251.67 / Max: 65391Min: 65152 / Avg: 65263.33 / Max: 654211. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

LevelDB

LevelDB is a key-value storage library developed by Google that supports making use of Snappy for data compression and has other modern features. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Seek RandomXFSEXT41020304050SE +/- 0.31, N = 3SE +/- 0.17, N = 344.1444.141. (CXX) g++ options: -O3 -lsnappy -lpthread
OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Seek RandomXFSEXT4918273645Min: 43.77 / Avg: 44.14 / Max: 44.75Min: 43.85 / Avg: 44.14 / Max: 44.441. (CXX) g++ options: -O3 -lsnappy -lpthread

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 16XFSEXT4160320480640800SE +/- 3.06, N = 3SE +/- 10.14, N = 3734734
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 16XFSEXT4130260390520650Min: 730 / Avg: 734 / Max: 740Min: 716 / Avg: 734.33 / Max: 751

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 1EXT4306090120150SE +/- 1.88, N = 15148

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 1EXT414002800420056007000SE +/- 78.59, N = 156681
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 1EXT412002400360048006000Min: 5822 / Avg: 6680.93 / Max: 6997

Test: Sequential Read - Clients: 1

XFS: Test failed to run.

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average LatencyXFSEXT40.01760.03520.05280.07040.088SE +/- 0.000, N = 3SE +/- 0.000, N = 30.0780.0781. (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: 1 - Mode: Read Only - Average LatencyXFSEXT412345Min: 0.08 / Avg: 0.08 / Max: 0.08Min: 0.08 / Avg: 0.08 / Max: 0.081. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

LevelDB

LevelDB is a key-value storage library developed by Google that supports making use of Snappy for data compression and has other modern features. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Sequential FillXFSEXT43691215SE +/- 0.03, N = 3SE +/- 0.03, N = 312.212.21. (CXX) g++ options: -O3 -lsnappy -lpthread
OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Sequential FillXFSEXT448121620Min: 12.2 / Avg: 12.23 / Max: 12.3Min: 12.2 / Avg: 12.23 / Max: 12.31. (CXX) g++ options: -O3 -lsnappy -lpthread

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

Test: Async Random Write - Clients: 256

EXT4: Test failed to run.

XFS: Test failed to run.

Test: Async Random Read - Clients: 256

EXT4: Test failed to run.

XFS: Test failed to run.

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 128XFSEXT48001600240032004000SE +/- 147.69, N = 9SE +/- 118.38, N = 937783720
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 128XFSEXT47001400210028003500Min: 3599 / Avg: 3777.67 / Max: 4956Min: 3537 / Avg: 3719.67 / Max: 4662

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 128XFSEXT47K14K21K28K35KSE +/- 1068.83, N = 9SE +/- 903.39, N = 93411334559
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 128XFSEXT46K12K18K24K30KMin: 25602 / Avg: 34113.22 / Max: 35473Min: 27392 / Avg: 34558.89 / Max: 36094

Test: Sequential Write - Clients: 256

EXT4: Test failed to run.

XFS: Test failed to run.

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 128XFSEXT4110220330440550SE +/- 7.63, N = 9SE +/- 12.36, N = 9449499
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 128XFSEXT490180270360450Min: 421 / Avg: 449 / Max: 478Min: 435 / Avg: 498.89 / Max: 550

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 128XFSEXT460K120K180K240K300KSE +/- 4813.28, N = 9SE +/- 6427.65, N = 9284045259064
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 128XFSEXT450K100K150K200K250KMin: 266507 / Avg: 284045.44 / Max: 302344Min: 231397 / Avg: 259063.67 / Max: 295102

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 16EXT460120180240300SE +/- 5.80, N = 15294

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 16EXT412K24K36K48K60KSE +/- 924.97, N = 1554206
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 16EXT49K18K27K36K45KMin: 43357 / Avg: 54205.8 / Max: 58082

Test: Async Random Read - Clients: 16

XFS: Test failed to run.

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 64XFSEXT450100150200250SE +/- 9.01, N = 5SE +/- 8.21, N = 15243246
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 64XFSEXT44080120160200Min: 227 / Avg: 243 / Max: 278Min: 212 / Avg: 246.07 / Max: 308

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 64XFSEXT460K120K180K240K300KSE +/- 4870.75, N = 5SE +/- 4775.23, N = 15274321282855
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 64XFSEXT450K100K150K200K250KMin: 255262 / Avg: 274320.8 / Max: 281447Min: 236325 / Avg: 282854.87 / Max: 309002

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 32XFSEXT4306090120150SE +/- 2.61, N = 15SE +/- 10.62, N = 1598133
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 32XFSEXT420406080100Min: 82 / Avg: 98.2 / Max: 112Min: 95 / Avg: 133.27 / Max: 229

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 32XFSEXT470K140K210K280K350KSE +/- 5477.25, N = 15SE +/- 9145.09, N = 15348681317972
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 32XFSEXT460K120K180K240K300KMin: 298290 / Avg: 348680.8 / Max: 385660Min: 259331 / Avg: 317971.8 / Max: 357180

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 16XFSEXT41326395265SE +/- 6.89, N = 15SE +/- 8.10, N = 155160
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 16XFSEXT41224364860Min: 34 / Avg: 50.8 / Max: 124Min: 42 / Avg: 60.07 / Max: 157

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 16XFSEXT490K180K270K360K450KSE +/- 10607.49, N = 15SE +/- 9367.43, N = 15398393347807
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 16XFSEXT470K140K210K280K350KMin: 304758 / Avg: 398393.4 / Max: 455500Min: 284250 / Avg: 347807.4 / Max: 383024

Test: Sequential Read - Clients: 256

EXT4: Test failed to run.

XFS: Test failed to run.

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 4XFSEXT4816243240SE +/- 15.17, N = 12SE +/- 12.02, N = 123330
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 4XFSEXT4714212835Min: 16 / Avg: 33.17 / Max: 200Min: 16 / Avg: 30.08 / Max: 162

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 4XFSEXT440K80K120K160K200KSE +/- 12069.51, N = 12SE +/- 17028.67, N = 12201341197735
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 4XFSEXT430K60K90K120K150KMin: 76652 / Avg: 201341.17 / Max: 232678Min: 24525 / Avg: 197734.67 / Max: 236130

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 1XFSEXT448121620SE +/- 0.21, N = 15SE +/- 0.25, N = 151414
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 1XFSEXT448121620Min: 13 / Avg: 14.33 / Max: 16Min: 13 / Avg: 14.4 / Max: 17

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 4XFSEXT44080120160200SE +/- 8.92, N = 15SE +/- 1.31, N = 15192182
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 4XFSEXT44080120160200Min: 172 / Avg: 191.6 / Max: 311Min: 176 / Avg: 181.93 / Max: 196

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 4XFSEXT45K10K15K20K25KSE +/- 662.38, N = 15SE +/- 149.90, N = 152117621846
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 4XFSEXT44K8K12K16K20KMin: 12792 / Avg: 21176.2 / Max: 23128Min: 20287 / Avg: 21846.4 / Max: 22562

Test: Random Write - Clients: 256

EXT4: Test failed to run.

XFS: Test failed to run.

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Write - Clients: 128XFSEXT430060090012001500SE +/- 67.50, N = 2SE +/- 185.46, N = 98551316
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Write - Clients: 128XFSEXT42004006008001000Min: 787 / Avg: 854.5 / Max: 922Min: 719 / Avg: 1315.89 / Max: 2423

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Write - Clients: 128XFSEXT430K60K90K120K150KSE +/- 12570.00, N = 2SE +/- 12285.62, N = 9149520110151
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Write - Clients: 128XFSEXT430K60K90K120K150KMin: 136950 / Avg: 149520 / Max: 162090Min: 53504 / Avg: 110151 / Max: 177064

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Write - Clients: 64XFSEXT4140280420560700SE +/- 33.25, N = 15SE +/- 78.20, N = 9449667
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Write - Clients: 64XFSEXT4120240360480600Min: 218 / Avg: 449 / Max: 777Min: 301 / Avg: 666.56 / Max: 1041

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Write - Clients: 64XFSEXT430K60K90K120K150KSE +/- 12366.87, N = 15SE +/- 16815.61, N = 9152697110431
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Write - Clients: 64XFSEXT430K60K90K120K150KMin: 82043 / Avg: 152696.87 / Max: 291147Min: 60762 / Avg: 110431.33 / Max: 209287

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Write - Clients: 32XFSEXT470140210280350SE +/- 23.38, N = 15SE +/- 37.02, N = 12175318
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Write - Clients: 32XFSEXT460120180240300Min: 96 / Avg: 174.6 / Max: 382Min: 98 / Avg: 317.92 / Max: 486

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Write - Clients: 32XFSEXT450K100K150K200K250KSE +/- 21678.90, N = 15SE +/- 21213.62, N = 12219181124449
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Write - Clients: 32XFSEXT440K80K120K160K200KMin: 83479 / Avg: 219180.87 / Max: 330195Min: 65644 / Avg: 124449.08 / Max: 320325

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Write - Clients: 16XFSEXT44080120160200SE +/- 20.22, N = 12SE +/- 29.81, N = 1573165
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Write - Clients: 16XFSEXT4306090120150Min: 42 / Avg: 72.83 / Max: 289Min: 47 / Avg: 165 / Max: 394

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Write - Clients: 16XFSEXT460K120K180K240K300KSE +/- 26659.17, N = 12SE +/- 22515.90, N = 15289850147758
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Write - Clients: 16XFSEXT450K100K150K200K250KMin: 55115 / Avg: 289849.75 / Max: 372017Min: 48396 / Avg: 147757.93 / Max: 336969

Test: Random Read - Clients: 256

EXT4: Test failed to run.

XFS: Test failed to run.

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Write - Clients: 4XFSEXT41122334455SE +/- 19.39, N = 12SE +/- 16.39, N = 125045
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Write - Clients: 4XFSEXT41020304050Min: 20 / Avg: 49.5 / Max: 216Min: 19 / Avg: 44.5 / Max: 167

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Write - Clients: 4XFSEXT430K60K90K120K150KSE +/- 18474.95, N = 12SE +/- 18825.90, N = 12156727162144
OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Write - Clients: 4XFSEXT430K60K90K120K150KMin: 18420 / Avg: 156727.08 / Max: 193580Min: 23868 / Avg: 162143.67 / Max: 201164

Test: Increment - Clients: 256

EXT4: Test failed to run.

XFS: Test failed to run.

Facebook RocksDB

This is a benchmark of Facebook's RocksDB as an embeddable persistent key-value store for fast storage based on Google's LevelDB. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 6.22.1Test: Read Random Write RandomXFSEXT4140K280K420K560K700KSE +/- 4151.31, N = 3SE +/- 9698.77, N = 156457695717071. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread
OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 6.22.1Test: Read Random Write RandomXFSEXT4110K220K330K440K550KMin: 640576 / Avg: 645769.33 / Max: 653976Min: 516867 / Avg: 571707.2 / Max: 6325291. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

Apache Cassandra

This is a benchmark of the Apache Cassandra NoSQL database management system making use of cassandra-stress. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOp/s, More Is BetterApache Cassandra 4.0Test: ReadsXFSEXT415K30K45K60K75KSE +/- 1471.42, N = 12SE +/- 983.14, N = 117079869078
OpenBenchmarking.orgOp/s, More Is BetterApache Cassandra 4.0Test: ReadsXFSEXT412K24K36K48K60KMin: 63663 / Avg: 70798.42 / Max: 79213Min: 62633 / Avg: 69078 / Max: 74077

Memtier_benchmark

Memtier_benchmark is a NoSQL Redis/Memcache traffic generation plus benchmarking tool. This current test profile currently just stresses the Redis protocol and basic options exposed wotj a 1:1 Set/Get ratio, 30 pipeline, 100 clients per thread, and thread count equal to the number of CPU cores/threads present. Patches to extend the test are welcome as always. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOps/sec, More Is BetterMemtier_benchmark 1.2.17Protocol: RedisXFSEXT4300K600K900K1200K1500KSE +/- 20674.68, N = 12SE +/- 49791.68, N = 121490596.161549937.941. (CXX) g++ options: -O2 -levent -lpthread -lz -lpcre
OpenBenchmarking.orgOps/sec, More Is BetterMemtier_benchmark 1.2.17Protocol: RedisXFSEXT4300K600K900K1200K1500KMin: 1390445.05 / Avg: 1490596.16 / Max: 1679372.98Min: 1370400.32 / Avg: 1549937.94 / Max: 1947647.431. (CXX) g++ options: -O2 -levent -lpthread -lz -lpcre

PostgreSQL pgbench

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

Scaling Factor: 10000 - Clients: 500 - Mode: Read Write

EXT4: pgbench: error: client 159 aborted in command 0 (set) of script 0; evaluation of meta-command failed

XFS: pgbench: error: client 63 aborted in command 0 (set) of script 0; evaluation of meta-command failed

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

EXT4: pgbench: error: client 55 aborted in command 0 (set) of script 0; evaluation of meta-command failed

XFS: pgbench: error: client 15 aborted in command 0 (set) of script 0; evaluation of meta-command failed

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

EXT4: pgbench: error: client 15 aborted in command 0 (set) of script 0; evaluation of meta-command failed

XFS: pgbench: error: client 11 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 10000 - Clients: 500 - Mode: Read Only

EXT4: pgbench: error: client 207 aborted in command 0 (set) of script 0; evaluation of meta-command failed

XFS: pgbench: error: client 143 aborted in command 0 (set) of script 0; evaluation of meta-command failed

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

EXT4: error: client 23 aborted in command 0 (set) of script 0; evaluation of meta-command failed

XFS: pgbench:error: error: client 3 aborted in command 0 (set) of script 0; evaluation of meta-command failed

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

EXT4: pgbench: error: client 15 aborted in command 0 (set) of script 0; evaluation of meta-command failed

XFS: pgbench: error: client 191 aborted in command 0 (set) of script 0; evaluation of meta-command failed

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

EXT4: error: client 11 aborted in command 0 (set) of script 0; evaluation of meta-command failed

XFS: pgbench: error: client 93 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 10000 - Clients: 50 - Mode: Read Only

EXT4: pgbench: error: client 33 aborted in command 0 (set) of script 0; evaluation of meta-command failed

XFS: error: client 37 aborted in command 0 (set) of script 0; evaluation of meta-command failed

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

EXT4: pgbench: error: client 0 aborted in command 0 (set) of script 0; evaluation of meta-command failed

XFS: pgbench: error: client 0 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 10000 - Clients: 1 - Mode: Read Only

EXT4: pgbench: error: client 0 aborted in command 0 (set) of script 0; evaluation of meta-command failed

XFS: pgbench: error: client 0 aborted in command 0 (set) of script 0; evaluation of meta-command failed

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average LatencyXFSEXT4140280420560700SE +/- 49.27, N = 9SE +/- 37.22, N = 12671.08668.761. (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: 500 - Mode: Read Write - Average LatencyXFSEXT4120240360480600Min: 489.7 / Avg: 671.08 / Max: 1021.03Min: 536.59 / Avg: 668.75 / Max: 929.871. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read WriteXFSEXT4170340510680850SE +/- 47.92, N = 9SE +/- 38.50, N = 127727711. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read WriteXFSEXT4140280420560700Min: 489.7 / Avg: 772.18 / Max: 1021.04Min: 537.71 / Avg: 771.02 / Max: 931.81. (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: 250 - Mode: Read Write - Average LatencyXFSEXT44080120160200SE +/- 2.01, N = 12SE +/- 7.19, N = 12169.34177.011. (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: 250 - Mode: Read Write - Average LatencyXFSEXT4306090120150Min: 161.51 / Avg: 169.34 / Max: 182.77Min: 157.28 / Avg: 177.01 / Max: 246.221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read WriteXFSEXT430060090012001500SE +/- 17.14, N = 12SE +/- 47.54, N = 12147914331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read WriteXFSEXT430060090012001500Min: 1367.82 / Avg: 1478.6 / Max: 1547.87Min: 1015.36 / Avg: 1433.34 / Max: 1589.551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

MariaDB

This is a MariaDB MySQL database server benchmark making use of mysqlslap. Learn more via the OpenBenchmarking.org test page.

Clients: 4096

EXT4: ./mysqlslap: 3: ./bin/mysqlslap: not found

XFS: ./mysqlslap: 3: ./bin/mysqlslap: not found

Clients: 2048

EXT4: ./mysqlslap: 3: ./bin/mysqlslap: not found

XFS: ./mysqlslap: 3: ./bin/mysqlslap: not found

Clients: 1024

EXT4: ./mysqlslap: 3: ./bin/mysqlslap: not found

XFS: ./mysqlslap: 3: ./bin/mysqlslap: not found

Clients: 512

EXT4: ./mysqlslap: 3: ./bin/mysqlslap: not found

XFS: ./mysqlslap: 3: ./bin/mysqlslap: not found

Clients: 256

EXT4: ./mysqlslap: 3: ./bin/mysqlslap: not found

XFS: ./mysqlslap: 3: ./bin/mysqlslap: not found

Clients: 128

EXT4: ./mysqlslap: 3: ./bin/mysqlslap: not found

XFS: ./mysqlslap: 3: ./bin/mysqlslap: not found

Clients: 64

EXT4: ./mysqlslap: 3: ./bin/mysqlslap: not found

XFS: ./mysqlslap: 3: ./bin/mysqlslap: not found

Clients: 32

EXT4: ./mysqlslap: 3: ./bin/mysqlslap: not found

XFS: ./mysqlslap: 3: ./bin/mysqlslap: not found

Clients: 16

EXT4: ./mysqlslap: 3: ./bin/mysqlslap: not found

XFS: ./mysqlslap: 3: ./bin/mysqlslap: not found

Clients: 8

EXT4: ./mysqlslap: 3: ./bin/mysqlslap: not found

XFS: ./mysqlslap: 3: ./bin/mysqlslap: not found

Clients: 1

EXT4: ./mysqlslap: 3: ./bin/mysqlslap: not found

XFS: ./mysqlslap: 3: ./bin/mysqlslap: not found

180 Results Shown

Apache HBase:
  Rand Read - 128:
    Microseconds - Average Latency
    Rows Per Second
  Rand Read - 64:
    Microseconds - Average Latency
    Rows Per Second
  Rand Read - 32:
    Microseconds - Average Latency
    Rows Per Second
  Seq Read - 16:
    Microseconds - Average Latency
    Rows Per Second
  Async Rand Read - 32:
    Microseconds - Average Latency
    Rows Per Second
PostgreSQL pgbench:
  1000 - 500 - Read Write
  1000 - 500 - Read Write - Average Latency
Apache HBase:
  Rand Read - 16
  Increment - 1
  Rand Read - 16
  Increment - 1
  Seq Read - 32
  Seq Read - 32
PostgreSQL pgbench:
  1000 - 250 - Read Write
  1000 - 250 - Read Write - Average Latency
Apache HBase:
  Rand Read - 1:
    Microseconds - Average Latency
    Rows Per Second
  Rand Write - 1:
    Microseconds - Average Latency
  Increment - 4:
    Microseconds - Average Latency
    Rows Per Second
  Seq Read - 64:
    Microseconds - Average Latency
  Increment - 16:
    Rows Per Second
    Microseconds - Average Latency
  Seq Read - 64:
    Rows Per Second
  Rand Read - 4:
    Microseconds - Average Latency
    Rows Per Second
Facebook RocksDB
Apache HBase:
  Increment - 32:
    Microseconds - Average Latency
    Rows Per Second
PostgreSQL pgbench:
  1000 - 500 - Read Only
  1000 - 500 - Read Only - Average Latency
  100 - 250 - Read Write
  100 - 250 - Read Write - Average Latency
Apache HBase
PostgreSQL pgbench:
  100 - 500 - Read Write - Average Latency
  100 - 500 - Read Write
Apache HBase
Apache Cassandra
SQLite
PostgreSQL pgbench:
  100 - 100 - Read Write - Average Latency
  100 - 100 - Read Write
Redis
Apache HBase:
  Seq Read - 128:
    Microseconds - Average Latency
    Rows Per Second
Facebook RocksDB
PostgreSQL pgbench:
  100 - 100 - Read Only
  100 - 50 - Read Write - Average Latency
  100 - 50 - Read Write
  100 - 100 - Read Only - Average Latency
  1 - 500 - Read Only - Average Latency
  1 - 500 - Read Only
Redis
Apache HBase
PostgreSQL pgbench
Apache HBase
PostgreSQL pgbench
Apache CouchDB
LevelDB
PostgreSQL pgbench
InfluxDB
PostgreSQL pgbench:
  1000 - 100 - Read Write - Average Latency
  1000 - 100 - Read Write
Apache HBase
LevelDB
Apache HBase
PostgreSQL pgbench:
  1000 - 100 - Read Only
  100 - 250 - Read Only - Average Latency
  1000 - 100 - Read Only - Average Latency
  1 - 250 - Read Only
  1 - 250 - Read Only - Average Latency
  1 - 1 - Read Only
  100 - 250 - Read Only
  1 - 50 - Read Write - Average Latency
  1 - 50 - Read Write
  1000 - 1 - Read Only - Average Latency
InfluxDB
Facebook RocksDB
Apache HBase
Redis
Apache HBase
Apache Cassandra
Apache HBase
PostgreSQL pgbench:
  1000 - 1 - Read Write
  100 - 50 - Read Only - Average Latency
InfluxDB
PostgreSQL pgbench:
  100 - 500 - Read Only - Average Latency
  100 - 500 - Read Only
LevelDB:
  Overwrite
  Rand Fill
Redis
PostgreSQL pgbench
Apache HBase:
  Async Rand Read - 4
  Increment - 64
  Increment - 64
LevelDB
PostgreSQL pgbench
KeyDB
PostgreSQL pgbench
Apache HBase
Facebook RocksDB
Apache HBase:
  Seq Write - 1
  Async Rand Write - 32
  Increment - 128
PostgreSQL pgbench
Apache HBase:
  Async Rand Write - 32
  Async Rand Read - 4
PostgreSQL pgbench:
  100 - 1 - Read Write - Average Latency
  100 - 1 - Read Write
  1 - 100 - Read Only - Average Latency
  1 - 50 - Read Only - Average Latency
Apache HBase:
  Async Rand Write - 128:
    Rows Per Second
    Microseconds - Average Latency
LevelDB
Apache HBase
PostgreSQL pgbench
LevelDB
PostgreSQL pgbench:
  1000 - 50 - Read Only - Average Latency
  1 - 100 - Read Only
LevelDB
PostgreSQL pgbench
Apache Cassandra
Facebook RocksDB
PostgreSQL pgbench:
  100 - 1 - Read Only
  1000 - 50 - Read Write
  1000 - 50 - Read Write - Average Latency
LevelDB
Apache HBase
SQLite Speedtest
PostgreSQL pgbench:
  1 - 100 - Read Write - Average Latency
  1 - 100 - Read Write
Redis
PostgreSQL pgbench
LevelDB
Apache HBase
Facebook RocksDB
LevelDB
Apache HBase:
  Async Rand Write - 16
  Seq Read - 1
  Seq Read - 1
PostgreSQL pgbench
LevelDB
Apache HBase:
  Async Rand Read - 128:
    Microseconds - Average Latency
    Rows Per Second
  Seq Write - 128:
    Microseconds - Average Latency
    Rows Per Second
  Async Rand Read - 16:
    Microseconds - Average Latency
    Rows Per Second
  Seq Write - 64:
    Microseconds - Average Latency
    Rows Per Second
  Seq Write - 32:
    Microseconds - Average Latency
    Rows Per Second
  Seq Write - 16:
    Microseconds - Average Latency
    Rows Per Second
  Seq Write - 4:
    Microseconds - Average Latency
    Rows Per Second
  Seq Write - 1:
    Microseconds - Average Latency
  Seq Read - 4:
    Microseconds - Average Latency
    Rows Per Second
  Rand Write - 128:
    Microseconds - Average Latency
    Rows Per Second
  Rand Write - 64:
    Microseconds - Average Latency
    Rows Per Second
  Rand Write - 32:
    Microseconds - Average Latency
    Rows Per Second
  Rand Write - 16:
    Microseconds - Average Latency
    Rows Per Second
  Rand Write - 4:
    Microseconds - Average Latency
    Rows Per Second
Facebook RocksDB
Apache Cassandra
Memtier_benchmark
PostgreSQL pgbench:
  1 - 500 - Read Write - Average Latency
  1 - 500 - Read Write
  1 - 250 - Read Write - Average Latency
  1 - 250 - Read Write

EXT4

Processor: 2 x Intel Xeon E5-2630 v3 @ 3.20GHz (16 Cores / 32 Threads), Motherboard: Dell 0CNCJW (2.2.5 BIOS), Memory: 64GB, Disk: 731GB PERC H730P Mini, Graphics: mgadrmfb

OS: Ubuntu 20.04.3 LTS, Kernel: 3.10.0-1160.36.2.el7.x86_64 (x86_64), Compiler: GCC 9.3.0, File-System: ext4, Screen Resolution: 1024x768, System Layer: Docker

Kernel Notes: Transparent Huge Pages: never
Compiler Notes: --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++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-HskZEa/gcc-9-9.3.0/debian/tmp-nvptx/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-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
Processor Notes: Scaling Governor: intel_pstate performance - CPU Microcode: 0x44
Disk Scheduler Notes: DEADLINE
Java Notes: OpenJDK Runtime Environment (build 11.0.13+8-Ubuntu-0ubuntu1.20.04)
Security Notes: itlb_multihit: KVM: Mitigation of Split huge pages + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of Load fences usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full retpoline IBPB + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 18 December 2021 06:14 by user root.

XFS

Processor: 2 x Intel Xeon E5-2630 v3 @ 3.20GHz (16 Cores / 32 Threads), Motherboard: Dell 0CNCJW (2.2.5 BIOS), Memory: 64GB, Disk: 731GB PERC H730P Mini, Graphics: mgadrmfb

OS: Ubuntu 20.04.3 LTS, Kernel: 3.10.0-1160.36.2.el7.x86_64 (x86_64), Compiler: GCC 9.3.0, File-System: xfs, Screen Resolution: 1024x768, System Layer: Docker

Kernel Notes: Transparent Huge Pages: never
Compiler Notes: --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++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-HskZEa/gcc-9-9.3.0/debian/tmp-nvptx/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-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
Processor Notes: Scaling Governor: intel_pstate performance - CPU Microcode: 0x44
Disk Scheduler Notes: DEADLINE
Java Notes: OpenJDK Runtime Environment (build 11.0.13+8-Ubuntu-0ubuntu1.20.04)
Security Notes: itlb_multihit: KVM: Mitigation of Split huge pages + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of Load fences usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full retpoline IBPB + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 19 December 2021 19:14 by user root.