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):


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 LatencyIncrement - 117.9%Rand Read - 1617.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 Write - 128hbase: Rand Write - 128hbase: Async Rand Read - 128hbase: Async Rand Read - 128hbase: Seq Write - 64hbase: Seq Write - 64hbase: Rand Read - 128hbase: Rand Read - 128hbase: Async Rand Write - 128hbase: Async Rand Write - 128hbase: Seq Write - 128hbase: Seq Write - 128hbase: Increment - 128hbase: Increment - 128cassandra: Readshbase: Async Rand Read - 64hbase: Async Rand Read - 64hbase: Async Rand Read - 32hbase: Async Rand Read - 32pgbench: 1 - 250 - Read Write - Average Latencypgbench: 1 - 250 - Read Writecassandra: Mixed 1:3hbase: Rand Write - 64hbase: Rand Write - 64pgbench: 1 - 500 - Read Write - Average Latencypgbench: 1 - 500 - Read Writehbase: Async Rand Read - 16hbase: Async Rand Write - 64hbase: Async Rand Write - 64hbase: Seq Read - 1hbase: Rand Read - 64hbase: Rand Read - 64hbase: Seq Read - 64hbase: Seq Read - 64memtier-benchmark: Redishbase: Async Rand Read - 16hbase: Increment - 64hbase: Increment - 64pgbench: 1000 - 1 - Read Only - Average Latencypgbench: 1000 - 1 - Read Onlypgbench: 1000 - 100 - Read Only - Average Latencypgbench: 1000 - 100 - Read Onlypgbench: 1000 - 500 - Read Write - Average Latencypgbench: 1000 - 500 - Read Writepgbench: 1000 - 500 - Read Only - Average Latencypgbench: 1000 - 500 - Read Onlypgbench: 1000 - 50 - Read Only - Average Latencypgbench: 1000 - 50 - Read Onlypgbench: 1000 - 250 - Read Only - Average Latencypgbench: 1000 - 250 - Read Onlypgbench: 1000 - 100 - Read Write - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 250 - Read Write - Average Latencypgbench: 1000 - 250 - Read Writepgbench: 1000 - 50 - Read Write - Average Latencypgbench: 1000 - 50 - Read Writepgbench: 1000 - 1 - Read Write - Average Latencypgbench: 1000 - 1 - Read Writehbase: Seq Read - 128hbase: Seq Read - 128cassandra: Mixed 1:1pgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 50 - Read Writehbase: Rand Write - 32hbase: Rand Write - 32cassandra: Writeshbase: Async Rand Write - 32hbase: Async Rand Write - 32hbase: Seq Write - 32hbase: Seq Write - 32hbase: Seq Read - 4hbase: Seq Read - 4rocksdb: Seq Fillhbase: Async Rand Read - 4hbase: Async Rand Read - 4couchdb: 100 - 1000 - 24rocksdb: Read Rand Write Randhbase: Seq Read - 16hbase: Seq Read - 16hbase: Async Rand Read - 1hbase: Async Rand Read - 1hbase: Increment - 1hbase: Increment - 1hbase: Seq Read - 1hbase: Increment - 32hbase: Increment - 32hbase: Async Rand Write - 16hbase: Async Rand Write - 16sqlite-speedtest: Timed Time - Size 1,000pgbench: 100 - 500 - Read Only - Average Latencypgbench: 100 - 500 - Read Onlypgbench: 100 - 500 - Read Write - Average Latencypgbench: 100 - 500 - Read Writepgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 250 - Read Onlypgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 1 - Read Writepgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 100 - Read Writepgbench: 100 - 250 - Read Write - Average Latencypgbench: 100 - 250 - Read Writepgbench: 100 - 1 - Read Only - Average Latencypgbench: 100 - 1 - Read Onlypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 100 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 100 - 50 - Read Onlyleveldb: Rand Deleteleveldb: Seq Fillleveldb: Seq Fillpgbench: 1 - 50 - Read Write - Average Latencypgbench: 1 - 50 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 500 - Read Only - Average Latencypgbench: 1 - 500 - Read Onlypgbench: 1 - 250 - Read Only - Average Latencypgbench: 1 - 250 - Read Onlypgbench: 1 - 100 - Read Only - Average Latencypgbench: 1 - 100 - Read Onlypgbench: 1 - 50 - Read Only - Average Latencypgbench: 1 - 50 - Read Onlypgbench: 1 - 1 - Read Write - Average Latencypgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Onlyhbase: Rand Write - 16hbase: Rand Write - 16influxdb: 4 - 10000 - 2,5000,1 - 10000influxdb: 1024 - 10000 - 2,5000,1 - 10000influxdb: 64 - 10000 - 2,5000,1 - 10000hbase: Rand Read - 1hbase: Rand Read - 1hbase: Rand Read - 16hbase: Rand Read - 16leveldb: Hot Readhbase: Rand Read - 32hbase: Rand Read - 32hbase: Seq Write - 16hbase: Seq Write - 16hbase: Seq Read - 32hbase: Seq Read - 32keydb: hbase: Increment - 16hbase: Increment - 16hbase: Async Rand Write - 4hbase: Async Rand Write - 4hbase: Async Rand Write - 1hbase: Async Rand Write - 1hbase: Increment - 4hbase: Increment - 4rocksdb: Rand Fill Syncrocksdb: Rand Fillrocksdb: Update Randrocksdb: Read While Writingrocksdb: Rand Readhbase: Rand Read - 4hbase: Rand Read - 4hbase: Rand Write - 4hbase: Rand Write - 4leveldb: Seek Randhbase: Seq Write - 4hbase: Seq Write - 4leveldb: Rand Readleveldb: Overwriteleveldb: Overwriteleveldb: Rand Fillleveldb: Rand Fillhbase: Rand Write - 1hbase: Rand Write - 1hbase: Seq Write - 1hbase: Seq Write - 1redis: SETredis: GETredis: LPUSHredis: LPOPredis: SADDsqlite: 1leveldb: Fill Syncleveldb: Fill Syncmysqlslap: 1EXT4XFS131611015137203455924628285511851070304254300004992590643038419786907813814616247367261177.014143366998667110431668.755771542062115301826681633100261778817651549937.942941493426840.091109830.521191884118.40342232.9421699580.2551962671.26419774035.072285277.109324217.51428550.6311584133295539672504.14812061318124449789801146278391333179721822184614818318521404112.38057170726260689155639222344521487464260873421724149.3862.55419578145.280110471.1162240470.57117518.3001205021.527116140.078128770.4742110820.232215937288.116288.30012.213.784362736.59727332.3412136101.0452392720.4452247560.2232240840.53218800.07613247165147758859395.6867557.9886748.916659802237093035.284352900636034780743273558321216.8146833959474840338325973081290565263146594133336241098748097925166238724516214444.1433019773535.393288.49712.2287.32812.318538791465319878810.46873340.33877540.98880911.58899392.793.159543.7716.48551495203778341132432743213484367194273298664492840453058417257079813874605956955966169.336147965175449152697671.078772214129806135247175819779401490596.161482429980.092109110.51519423099.72550142.8361763250.2541965501.28619441034.632288867.610369817.56028470.6261598130097724674884.0591232217521918178269115327685983486811922117614978718421565110.56964576932549038160621426337827754103873421717149.7182.53319740443.921113871.1032265820.57417438.0881236420.852119910.078128400.4642157400.230217222289.401288.98312.213.939358736.52727382.2922181021.0332420590.4432256300.2222256980.53018880.0751339873289850848341.6860201.8877126.214966482636021635.252468679575139839350263518319106.4149132349466855638725723251224465252149915138575239542848239829173229275015672744.1383320134135.529292.07212.1288.48512.217543591465732857147.73882156.81876195.46873824.56883258.923.242539.8026.5OpenBenchmarking.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 Write - Clients: 128EXT4XFS30060090012001500SE +/- 185.46, N = 9SE +/- 67.50, N = 21316855
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Write - Clients: 128EXT4XFS2004006008001000Min: 719 / Avg: 1315.89 / Max: 2423Min: 787 / Avg: 854.5 / Max: 922

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

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

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

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

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

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

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

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

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

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

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

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

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

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: ReadsEXT4XFS15K30K45K60K75KSE +/- 983.14, N = 11SE +/- 1471.42, N = 126907870798
OpenBenchmarking.orgOp/s, More Is BetterApache Cassandra 4.0Test: ReadsEXT4XFS12K24K36K48K60KMin: 62633 / Avg: 69078 / Max: 74077Min: 63663 / Avg: 70798.42 / Max: 79213

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: 64EXT4XFS30060090012001500SE +/- 11.61, N = 3SE +/- 25.60, N = 913811387
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 64EXT4XFS2004006008001000Min: 1359 / Avg: 1381.33 / Max: 1398Min: 1342 / Avg: 1387.33 / Max: 1576

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

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: 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 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: 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 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

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: 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: 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

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: 32EXT4XFS120240360480600SE +/- 4.40, N = 15SE +/- 6.53, N = 15473569
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 32EXT4XFS100200300400500Min: 453 / Avg: 472.93 / Max: 520Min: 550 / Avg: 569.13 / Max: 649

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

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: 250 - Mode: Read Write - Average LatencyEXT4XFS4080120160200SE +/- 7.19, N = 12SE +/- 2.01, N = 12177.01169.341. (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 LatencyEXT4XFS306090120150Min: 157.28 / Avg: 177.01 / Max: 246.22Min: 161.51 / Avg: 169.34 / Max: 182.771. (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 WriteEXT4XFS30060090012001500SE +/- 47.54, N = 12SE +/- 17.14, N = 12143314791. (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 WriteEXT4XFS30060090012001500Min: 1015.36 / Avg: 1433.34 / Max: 1589.55Min: 1367.82 / Avg: 1478.6 / Max: 1547.871. (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:3EXT4XFS14K28K42K56K70KSE +/- 601.71, N = 7SE +/- 668.69, N = 126699865175
OpenBenchmarking.orgOp/s, More Is BetterApache Cassandra 4.0Test: Mixed 1:3EXT4XFS12K24K36K48K60KMin: 64879 / Avg: 66997.86 / Max: 69711Min: 61390 / Avg: 65174.92 / Max: 68881

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 Write - Clients: 64EXT4XFS140280420560700SE +/- 78.20, N = 9SE +/- 33.25, N = 15667449
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Write - Clients: 64EXT4XFS120240360480600Min: 301 / Avg: 666.56 / Max: 1041Min: 218 / Avg: 449 / Max: 777

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

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: 500 - Mode: Read Write - Average LatencyEXT4XFS140280420560700SE +/- 37.22, N = 12SE +/- 49.27, N = 9668.76671.081. (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 LatencyEXT4XFS120240360480600Min: 536.59 / Avg: 668.75 / Max: 929.87Min: 489.7 / Avg: 671.08 / Max: 1021.031. (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 WriteEXT4XFS170340510680850SE +/- 38.50, N = 12SE +/- 47.92, N = 97717721. (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 WriteEXT4XFS140280420560700Min: 537.71 / Avg: 771.02 / Max: 931.8Min: 489.7 / Avg: 772.18 / Max: 1021.041. (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: 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: Async Random Write - Clients: 64EXT4XFS5001000150020002500SE +/- 18.21, N = 3SE +/- 18.77, N = 321152141
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 64EXT4XFS400800120016002000Min: 2084 / Avg: 2114.67 / Max: 2147Min: 2106 / Avg: 2141.33 / Max: 2170

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

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.

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

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

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

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

Test: Random Write - Clients: 256

EXT4: Test failed to run.

XFS: Test failed to run.

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: RedisEXT4XFS300K600K900K1200K1500KSE +/- 49791.68, N = 12SE +/- 20674.68, N = 121549937.941490596.161. (CXX) g++ options: -O2 -levent -lpthread -lz -lpcre
OpenBenchmarking.orgOps/sec, More Is BetterMemtier_benchmark 1.2.17Protocol: RedisEXT4XFS300K600K900K1200K1500KMin: 1370400.32 / Avg: 1549937.94 / Max: 1947647.43Min: 1390445.05 / Avg: 1490596.16 / Max: 1679372.981. (CXX) g++ options: -O2 -levent -lpthread -lz -lpcre

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: 16EXT460120180240300SE +/- 5.80, N = 15294

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

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

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 Only - Average LatencyEXT4XFS0.02070.04140.06210.08280.1035SE +/- 0.001, N = 3SE +/- 0.001, N = 30.0910.0921. (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 LatencyEXT4XFS12345Min: 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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read OnlyEXT4XFS2K4K6K8K10KSE +/- 79.57, N = 3SE +/- 121.75, N = 310983109111. (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 OnlyEXT4XFS2K4K6K8K10KMin: 10855.12 / Avg: 10982.88 / Max: 11128.93Min: 10692.08 / Avg: 10910.51 / Max: 11112.941. (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 LatencyEXT4XFS0.11720.23440.35160.46880.586SE +/- 0.002, N = 3SE +/- 0.001, N = 30.5210.5151. (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 LatencyEXT4XFS246810Min: 0.52 / Avg: 0.52 / Max: 0.52Min: 0.51 / 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: 1000 - Clients: 100 - Mode: Read OnlyEXT4XFS40K80K120K160K200KSE +/- 701.91, N = 3SE +/- 354.76, N = 31918841942301. (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 OnlyEXT4XFS30K60K90K120K150KMin: 190683.15 / Avg: 191884.2 / Max: 193114.11Min: 193531.62 / Avg: 194230.04 / Max: 194687.541. (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 LatencyEXT4XFS306090120150SE +/- 0.62, N = 3SE +/- 0.60, N = 3118.4099.731. (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 LatencyEXT4XFS20406080100Min: 117.19 / Avg: 118.4 / Max: 119.27Min: 98.85 / Avg: 99.73 / Max: 100.861. (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 WriteEXT4XFS11002200330044005500SE +/- 22.33, N = 3SE +/- 29.81, N = 3422350141. (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 WriteEXT4XFS9001800270036004500Min: 4192.17 / Avg: 4223.1 / Max: 4266.47Min: 4957.25 / Avg: 5014.13 / Max: 5058.041. (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 LatencyEXT4XFS0.6621.3241.9862.6483.31SE +/- 0.016, N = 3SE +/- 0.008, N = 32.9422.8361. (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 LatencyEXT4XFS246810Min: 2.91 / Avg: 2.94 / Max: 2.96Min: 2.82 / Avg: 2.84 / Max: 2.851. (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 OnlyEXT4XFS40K80K120K160K200KSE +/- 917.32, N = 3SE +/- 464.17, N = 31699581763251. (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 OnlyEXT4XFS30K60K90K120K150KMin: 168946.3 / Avg: 169958.01 / Max: 171789.3Min: 175559.87 / Avg: 176325.29 / Max: 177162.931. (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 LatencyEXT4XFS0.05740.11480.17220.22960.287SE +/- 0.000, N = 3SE +/- 0.000, N = 30.2550.2541. (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 LatencyEXT4XFS12345Min: 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: 1000 - Clients: 50 - Mode: Read OnlyEXT4XFS40K80K120K160K200KSE +/- 172.61, N = 3SE +/- 352.21, N = 31962671965501. (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 OnlyEXT4XFS30K60K90K120K150KMin: 195943.92 / Avg: 196266.68 / Max: 196534.14Min: 195957.38 / Avg: 196549.77 / Max: 197176.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: 250 - Mode: Read Only - Average LatencyEXT4XFS0.28940.57880.86821.15761.447SE +/- 0.004, N = 3SE +/- 0.002, N = 31.2641.2861. (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 LatencyEXT4XFS246810Min: 1.26 / Avg: 1.26 / Max: 1.27Min: 1.28 / Avg: 1.29 / Max: 1.291. (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 OnlyEXT4XFS40K80K120K160K200KSE +/- 670.87, N = 3SE +/- 269.64, N = 31977401944101. (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 OnlyEXT4XFS30K60K90K120K150KMin: 196514.77 / Avg: 197739.97 / Max: 198826.26Min: 193870.89 / Avg: 194409.5 / Max: 194702.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: 100 - Mode: Read Write - Average LatencyEXT4XFS816243240SE +/- 0.22, N = 3SE +/- 0.23, N = 335.0734.631. (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 LatencyEXT4XFS714212835Min: 34.63 / Avg: 35.07 / Max: 35.32Min: 34.26 / Avg: 34.63 / Max: 35.061. (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 WriteEXT4XFS6001200180024003000SE +/- 18.10, N = 3SE +/- 19.33, N = 3285228881. (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 WriteEXT4XFS5001000150020002500Min: 2831.47 / Avg: 2851.52 / Max: 2887.65Min: 2852.21 / Avg: 2887.76 / Max: 2918.71. (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 LatencyEXT4XFS20406080100SE +/- 0.24, N = 3SE +/- 0.55, N = 377.1167.611. (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 LatencyEXT4XFS1530456075Min: 76.64 / Avg: 77.11 / Max: 77.38Min: 66.85 / Avg: 67.61 / Max: 68.681. (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 WriteEXT4XFS8001600240032004000SE +/- 9.96, N = 3SE +/- 29.98, N = 3324236981. (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 WriteEXT4XFS6001200180024003000Min: 3230.83 / Avg: 3242.24 / Max: 3262.09Min: 3639.94 / Avg: 3698.18 / Max: 3739.671. (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 LatencyEXT4XFS48121620SE +/- 0.03, N = 3SE +/- 0.07, N = 317.5117.561. (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 LatencyEXT4XFS48121620Min: 17.46 / Avg: 17.51 / Max: 17.56Min: 17.44 / Avg: 17.56 / Max: 17.681. (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 WriteEXT4XFS6001200180024003000SE +/- 4.82, N = 3SE +/- 11.14, N = 3285528471. (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 WriteEXT4XFS5001000150020002500Min: 2848.13 / Avg: 2854.96 / Max: 2864.26Min: 2828.36 / Avg: 2847.41 / Max: 2866.931. (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 LatencyEXT4XFS0.1420.2840.4260.5680.71SE +/- 0.001, N = 3SE +/- 0.002, N = 30.6310.6261. (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 LatencyEXT4XFS246810Min: 0.63 / Avg: 0.63 / Max: 0.63Min: 0.62 / Avg: 0.63 / Max: 0.631. (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 WriteEXT4XFS30060090012001500SE +/- 1.22, N = 3SE +/- 3.75, N = 3158415981. (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 WriteEXT4XFS30060090012001500Min: 1582.4 / Avg: 1583.86 / Max: 1586.28Min: 1590.74 / Avg: 1598.11 / Max: 1602.971. (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: Sequential Read - Clients: 128EXT4XFS30060090012001500SE +/- 4.67, N = 3SE +/- 4.81, N = 313321300
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 128EXT4XFS2004006008001000Min: 1325 / Avg: 1332.33 / Max: 1341Min: 1291 / Avg: 1300.33 / Max: 1307

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

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:1EXT4XFS14K28K42K56K70KSE +/- 805.19, N = 3SE +/- 670.05, N = 66725067488
OpenBenchmarking.orgOp/s, More Is BetterApache Cassandra 4.0Test: Mixed 1:1EXT4XFS12K24K36K48K60KMin: 65640 / Avg: 67250.33 / Max: 68065Min: 65896 / Avg: 67488.17 / Max: 69776

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: 50 - Mode: Read Write - Average LatencyEXT4XFS0.93331.86662.79993.73324.6665SE +/- 0.037, N = 8SE +/- 0.040, N = 34.1484.0591. (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 LatencyEXT4XFS246810Min: 4.05 / Avg: 4.15 / Max: 4.32Min: 3.99 / Avg: 4.06 / Max: 4.131. (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 WriteEXT4XFS3K6K9K12K15KSE +/- 106.55, N = 8SE +/- 121.71, N = 312061123221. (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 WriteEXT4XFS2K4K6K8K10KMin: 11567.01 / Avg: 12060.54 / Max: 12346.26Min: 12110.45 / Avg: 12322.34 / Max: 12532.041. (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 Write - Clients: 32EXT4XFS70140210280350SE +/- 37.02, N = 12SE +/- 23.38, N = 15318175
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Write - Clients: 32EXT4XFS60120180240300Min: 98 / Avg: 317.92 / Max: 486Min: 96 / Avg: 174.6 / Max: 382

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

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: WritesEXT4XFS20K40K60K80K100KSE +/- 670.12, N = 8SE +/- 353.38, N = 37898078269
OpenBenchmarking.orgOp/s, More Is BetterApache Cassandra 4.0Test: WritesEXT4XFS14K28K42K56K70KMin: 77006 / Avg: 78980 / Max: 83228Min: 77565 / Avg: 78269 / Max: 78675

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: 32EXT4XFS2004006008001000SE +/- 4.04, N = 3SE +/- 4.18, N = 311461153
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 32EXT4XFS2004006008001000Min: 1138 / Avg: 1146 / Max: 1151Min: 1148 / Avg: 1152.67 / Max: 1161

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

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: 32EXT4XFS306090120150SE +/- 10.62, N = 15SE +/- 2.61, N = 1513398
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 32EXT4XFS20406080100Min: 95 / Avg: 133.27 / Max: 229Min: 82 / Avg: 98.2 / Max: 112

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

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

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

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 FillEXT4XFS30K60K90K120K150KSE +/- 1750.15, N = 3SE +/- 641.02, N = 31481831497871. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread
OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 6.22.1Test: Sequential FillEXT4XFS30K60K90K120K150KMin: 146332 / Avg: 148182.67 / Max: 151681Min: 148507 / Avg: 149786.67 / Max: 1504941. (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 Read - Clients: 4EXT4XFS4080120160200SE +/- 2.06, N = 15SE +/- 1.86, N = 15185184
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 4EXT4XFS306090120150Min: 178 / Avg: 185.4 / Max: 211Min: 176 / Avg: 184 / Max: 205

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

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: 24EXT4XFS306090120150SE +/- 1.03, N = 7SE +/- 0.47, N = 3112.38110.571. (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: 24EXT4XFS20406080100Min: 109.51 / Avg: 112.38 / Max: 118.05Min: 109.69 / Avg: 110.57 / Max: 111.271. (CXX) g++ options: -std=c++14 -lmozjs-68 -lm -lei -fPIC -MMD

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 RandomEXT4XFS140K280K420K560K700KSE +/- 9698.77, N = 15SE +/- 4151.31, N = 35717076457691. (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 RandomEXT4XFS110K220K330K440K550KMin: 516867 / Avg: 571707.2 / Max: 632529Min: 640576 / Avg: 645769.33 / Max: 6539761. (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: Sequential Read - Clients: 16EXT4XFS70140210280350SE +/- 2.30, N = 15SE +/- 4.16, N = 3262325
OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 16EXT4XFS60120180240300Min: 252 / Avg: 261.8 / Max: 286Min: 317 / Avg: 325 / Max: 331

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

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

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

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

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

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

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

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

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

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

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,000EXT4XFS306090120150SE +/- 0.88, N = 3SE +/- 0.40, N = 3149.39149.721. (CC) gcc options: -O2 -ldl -lz -lpthread
OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite Speedtest 3.30Timed Time - Size 1,000EXT4XFS306090120150Min: 148.22 / Avg: 149.39 / Max: 151.12Min: 149.16 / Avg: 149.72 / Max: 150.511. (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: 100 - Clients: 500 - Mode: Read Only - Average LatencyEXT4XFS0.57471.14941.72412.29882.8735SE +/- 0.012, N = 3SE +/- 0.007, N = 32.5542.5331. (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 LatencyEXT4XFS246810Min: 2.54 / Avg: 2.55 / Max: 2.58Min: 2.52 / Avg: 2.53 / Max: 2.551. (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 OnlyEXT4XFS40K80K120K160K200KSE +/- 906.00, N = 3SE +/- 548.17, N = 31957811974041. (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 OnlyEXT4XFS30K60K90K120K150KMin: 194074.24 / Avg: 195781.44 / Max: 197160.99Min: 196345.19 / Avg: 197404.14 / Max: 198179.441. (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 LatencyEXT4XFS1020304050SE +/- 0.63, N = 3SE +/- 0.52, N = 345.2843.921. (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 LatencyEXT4XFS918273645Min: 44.3 / Avg: 45.28 / Max: 46.47Min: 42.9 / Avg: 43.92 / Max: 44.551. (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 WriteEXT4XFS2K4K6K8K10KSE +/- 153.46, N = 3SE +/- 134.98, N = 311047113871. (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 WriteEXT4XFS2K4K6K8K10KMin: 10760.52 / Avg: 11046.78 / Max: 11285.78Min: 11223.72 / Avg: 11387.19 / Max: 11654.981. (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 LatencyEXT4XFS0.25110.50220.75331.00441.2555SE +/- 0.002, N = 3SE +/- 0.003, N = 31.1161.1031. (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 LatencyEXT4XFS246810Min: 1.11 / Avg: 1.12 / Max: 1.12Min: 1.1 / Avg: 1.1 / Max: 1.111. (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 OnlyEXT4XFS50K100K150K200K250KSE +/- 466.97, N = 3SE +/- 688.93, N = 32240472265821. (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 OnlyEXT4XFS40K80K120K160K200KMin: 223121.14 / Avg: 224047.09 / Max: 224615.58Min: 225616.15 / Avg: 226581.99 / Max: 227915.931. (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 LatencyEXT4XFS0.12920.25840.38760.51680.646SE +/- 0.002, N = 3SE +/- 0.003, N = 30.5710.5741. (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 LatencyEXT4XFS246810Min: 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 WriteEXT4XFS400800120016002000SE +/- 6.13, N = 3SE +/- 8.81, N = 3175117431. (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 WriteEXT4XFS30060090012001500Min: 1740.61 / Avg: 1751.25 / Max: 1761.84Min: 1725.58 / Avg: 1742.94 / Max: 1754.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: 100 - Clients: 100 - Mode: Read Write - Average LatencyEXT4XFS246810SE +/- 0.059, N = 3SE +/- 0.051, N = 38.3008.0881. (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 LatencyEXT4XFS3691215Min: 8.24 / Avg: 8.3 / Max: 8.42Min: 7.99 / Avg: 8.09 / Max: 8.161. (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 WriteEXT4XFS3K6K9K12K15KSE +/- 85.22, N = 3SE +/- 78.18, N = 312050123641. (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 WriteEXT4XFS2K4K6K8K10KMin: 11879.48 / Avg: 12049.89 / Max: 12138.04Min: 12259.55 / Avg: 12364.34 / Max: 12517.221. (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 LatencyEXT4XFS510152025SE +/- 0.15, N = 3SE +/- 0.15, N = 321.5320.851. (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 LatencyEXT4XFS510152025Min: 21.23 / Avg: 21.53 / Max: 21.72Min: 20.67 / Avg: 20.85 / Max: 21.161. (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 WriteEXT4XFS3K6K9K12K15KSE +/- 80.58, N = 3SE +/- 88.54, N = 311614119911. (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 WriteEXT4XFS2K4K6K8K10KMin: 11512.76 / Avg: 11614.15 / Max: 11773.32Min: 11814.51 / Avg: 11990.5 / Max: 12095.431. (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 LatencyEXT4XFS0.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 LatencyEXT4XFS12345Min: 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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read OnlyEXT4XFS3K6K9K12K15KSE +/- 46.38, N = 3SE +/- 43.12, N = 312877128401. (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 OnlyEXT4XFS2K4K6K8K10KMin: 12794.72 / Avg: 12877.01 / Max: 12955.24Min: 12780.16 / Avg: 12839.68 / Max: 12923.51. (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 LatencyEXT4XFS0.10670.21340.32010.42680.5335SE +/- 0.004, N = 3SE +/- 0.001, N = 30.4740.4641. (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 LatencyEXT4XFS12345Min: 0.47 / Avg: 0.47 / Max: 0.48Min: 0.46 / Avg: 0.46 / Max: 0.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: 100 - Mode: Read OnlyEXT4XFS50K100K150K200K250KSE +/- 1749.85, N = 3SE +/- 517.47, N = 32110822157401. (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 OnlyEXT4XFS40K80K120K160K200KMin: 207777.27 / Avg: 211082.15 / Max: 213731.72Min: 214764.54 / Avg: 215740.43 / Max: 216526.791. (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 LatencyEXT4XFS0.05220.10440.15660.20880.261SE +/- 0.001, N = 3SE +/- 0.000, N = 30.2320.2301. (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 LatencyEXT4XFS12345Min: 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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read OnlyEXT4XFS50K100K150K200K250KSE +/- 968.71, N = 3SE +/- 353.34, N = 32159372172221. (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 OnlyEXT4XFS40K80K120K160K200KMin: 214342.15 / Avg: 215937 / Max: 217687.07Min: 216604.86 / Avg: 217222.25 / Max: 217828.711. (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 DeleteEXT4XFS60120180240300SE +/- 0.20, N = 3SE +/- 0.24, N = 3288.12289.401. (CXX) g++ options: -O3 -lsnappy -lpthread
OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random DeleteEXT4XFS50100150200250Min: 287.72 / Avg: 288.12 / Max: 288.36Min: 289.11 / Avg: 289.4 / Max: 289.881. (CXX) g++ options: -O3 -lsnappy -lpthread

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Sequential FillEXT4XFS60120180240300SE +/- 0.97, N = 3SE +/- 0.70, N = 3288.30288.981. (CXX) g++ options: -O3 -lsnappy -lpthread
OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Sequential FillEXT4XFS50100150200250Min: 286.48 / Avg: 288.3 / Max: 289.77Min: 287.66 / Avg: 288.98 / Max: 290.051. (CXX) g++ options: -O3 -lsnappy -lpthread

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Sequential FillEXT4XFS3691215SE +/- 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 FillEXT4XFS48121620Min: 12.2 / Avg: 12.23 / Max: 12.3Min: 12.2 / Avg: 12.23 / Max: 12.31. (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: 50 - Mode: Read Write - Average LatencyEXT4XFS48121620SE +/- 0.01, N = 3SE +/- 0.04, N = 313.7813.941. (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 LatencyEXT4XFS48121620Min: 13.77 / Avg: 13.78 / Max: 13.81Min: 13.86 / Avg: 13.94 / Max: 13.981. (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 WriteEXT4XFS8001600240032004000SE +/- 3.19, N = 3SE +/- 9.88, N = 3362735871. (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 WriteEXT4XFS6001200180024003000Min: 3621.03 / Avg: 3627.37 / Max: 3631.27Min: 3576.55 / Avg: 3587.01 / Max: 3606.751. (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 LatencyEXT4XFS816243240SE +/- 0.18, N = 3SE +/- 0.33, N = 336.6036.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: 1 - Clients: 100 - Mode: Read Write - Average LatencyEXT4XFS816243240Min: 36.23 / Avg: 36.6 / Max: 36.82Min: 35.88 / Avg: 36.53 / Max: 36.951. (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 WriteEXT4XFS6001200180024003000SE +/- 13.77, N = 3SE +/- 25.01, N = 3273327381. (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 WriteEXT4XFS5001000150020002500Min: 2715.94 / Avg: 2732.65 / Max: 2759.95Min: 2706.21 / Avg: 2738.11 / Max: 2787.421. (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 LatencyEXT4XFS0.52671.05341.58012.10682.6335SE +/- 0.010, N = 3SE +/- 0.012, N = 32.3412.2921. (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 LatencyEXT4XFS246810Min: 2.32 / Avg: 2.34 / Max: 2.36Min: 2.27 / Avg: 2.29 / Max: 2.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: 1 - Clients: 500 - Mode: Read OnlyEXT4XFS50K100K150K200K250KSE +/- 936.66, N = 3SE +/- 1176.20, N = 32136102181021. (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 OnlyEXT4XFS40K80K120K160K200KMin: 212345.97 / Avg: 213610.15 / Max: 215439.48Min: 215965.54 / Avg: 218102.41 / Max: 220022.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: 1 - Clients: 250 - Mode: Read Only - Average LatencyEXT4XFS0.23510.47020.70530.94041.1755SE +/- 0.002, N = 3SE +/- 0.004, N = 31.0451.0331. (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 LatencyEXT4XFS246810Min: 1.04 / Avg: 1.05 / Max: 1.05Min: 1.03 / Avg: 1.03 / Max: 1.041. (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 OnlyEXT4XFS50K100K150K200K250KSE +/- 435.69, N = 3SE +/- 1017.69, N = 32392722420591. (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 OnlyEXT4XFS40K80K120K160K200KMin: 238497.74 / Avg: 239271.98 / Max: 240005.36Min: 240226.93 / Avg: 242059.2 / Max: 243742.921. (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 LatencyEXT4XFS0.10010.20020.30030.40040.5005SE +/- 0.001, N = 3SE +/- 0.001, N = 30.4450.4431. (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 LatencyEXT4XFS12345Min: 0.44 / Avg: 0.45 / Max: 0.45Min: 0.44 / Avg: 0.44 / Max: 0.451. (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 OnlyEXT4XFS50K100K150K200K250KSE +/- 402.72, N = 3SE +/- 560.78, N = 32247562256301. (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 OnlyEXT4XFS40K80K120K160K200KMin: 224289.82 / Avg: 224756.03 / Max: 225557.93Min: 224971.67 / Avg: 225629.92 / Max: 226745.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: 1 - Clients: 50 - Mode: Read Only - Average LatencyEXT4XFS0.05020.10040.15060.20080.251SE +/- 0.001, N = 3SE +/- 0.001, N = 30.2230.2221. (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 LatencyEXT4XFS12345Min: 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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read OnlyEXT4XFS50K100K150K200K250KSE +/- 885.40, N = 3SE +/- 673.80, N = 32240842256981. (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 OnlyEXT4XFS40K80K120K160K200KMin: 223097.43 / Avg: 224084.38 / Max: 225851.13Min: 224671.08 / Avg: 225698.45 / Max: 226967.41. (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 LatencyEXT4XFS0.11970.23940.35910.47880.5985SE +/- 0.004, N = 3SE +/- 0.001, N = 30.5320.5301. (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 LatencyEXT4XFS246810Min: 0.53 / Avg: 0.53 / Max: 0.54Min: 0.53 / Avg: 0.53 / Max: 0.531. (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 WriteEXT4XFS400800120016002000SE +/- 14.82, N = 3SE +/- 2.19, N = 3188018881. (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 WriteEXT4XFS30060090012001500Min: 1850.29 / Avg: 1879.8 / Max: 1896.88Min: 1883.71 / Avg: 1887.98 / Max: 1890.961. (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 LatencyEXT4XFS0.01710.03420.05130.06840.0855SE +/- 0.001, N = 3SE +/- 0.000, N = 30.0760.0751. (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 LatencyEXT4XFS12345Min: 0.08 / Avg: 0.08 / Max: 0.08Min: 0.07 / Avg: 0.07 / Max: 0.081. (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 OnlyEXT4XFS3K6K9K12K15KSE +/- 93.30, N = 3SE +/- 32.01, N = 313247133981. (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 OnlyEXT4XFS2K4K6K8K10KMin: 13066.54 / Avg: 13246.99 / Max: 13378.35Min: 13362.49 / Avg: 13398.01 / Max: 13461.911. (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 Write - Clients: 16EXT4XFS4080120160200