SSD Storage

Benchmarks for a future article.

HTML result view exported from: https://openbenchmarking.org/result/2404022-NE-SSDSTORAG76&rdt&grs.

SSD StorageProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelDesktopDisplay ServerCompilerFile-SystemScreen ResolutionMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-00007AMD EPYC 8534P 64-Core @ 2.30GHz (64 Cores / 128 Threads)AMD Cinnabar (RCB1009C BIOS)AMD Device 14a46 x 32GB DRAM-4800MT/s Samsung M321R4GA0BB0-CQKMG3201GB Micron_7450_MTFDKCB3T2TFSASPEED2 x Broadcom NetXtreme BCM5720 PCIeUbuntu 23.106.8.1-060801-generic (x86_64)GNOME Shell 45.2X Server 1.21.1.7GCC 13.2.0ext41920x12003201GB Micron_7450_MTFDKCB3T2TFS + 2000GB Corsair MP700 PRO3201GB Micron_7450_MTFDKCB3T2TFS + 2000GB CT2000T705SSD53201GB Micron_7450_MTFDKCB3T2TFS + 2000GB Corsair MP7003201GB Micron_7450_MTFDKCB3T2TFS + 2 x 1920GB SAMSUNG MZWLJ1T9HBJR-00007OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseCompiler Details- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-cet --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-serialization=2 --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-defaulted --enable-offload-targets=nvptx-none=/build/gcc-13-XYspKM/gcc-13-13.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-13-XYspKM/gcc-13-13.2.0/debian/tmp-gcn/usr --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-build-config=bootstrap-lto-lean --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v Disk Details- Micron 7450 Max 3.2TB: NONE / relatime,rw,stripe=64 / Block Size: 4096- Corsair MP700 PRO 2TB: NONE / relatime,rw / Block Size: 4096- Crucial T705 2TB: NONE / relatime,rw / Block Size: 4096- Corsair MP700 2TB: NONE / relatime,rw / Block Size: 4096- Samsung MZWLJ1T9HBJR-00007: NONE / relatime,rw / Block Size: 4096Processor Details- Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xaa00212Java Details- OpenJDK Runtime Environment (build 11.0.22+7-post-Ubuntu-0ubuntu223.10.1)Python Details- Micron 7450 Max 3.2TB: Python 3.11.6Security Details- gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + reg_file_data_sampling: Not affected + retbleed: Not affected + spec_rstack_overflow: Mitigation of Safe RET + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced / Automatic IBRS IBPB: conditional STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

SSD Storagefio: Seq Write - IO_uring - Yes - 2MB - 16 - Default Test Directorymariadb: oltp_write_only - 128fio: Seq Write - IO_uring - Yes - 2MB - 1 - Default Test Directorymysqlslap: 512fio: Seq Read - IO_uring - Yes - 2MB - 64 - Default Test Directorymysqlslap: 1024sqlite: 1fio: Seq Read - IO_uring - Yes - 2MB - 64 - Default Test Directorymysqlslap: 32mysqlslap: 256mysqlslap: 128mysqlslap: 64cockroach: KV, 50% Reads - 256clickhouse: 100M Rows Hits Dataset, Third Runclickhouse: 100M Rows Hits Dataset, First Run / Cold Cachecassandra: Writesclickhouse: 100M Rows Hits Dataset, Second Runmariadb: oltp_point_select - 128mariadb: oltp_read_write - 128mysqlslap: 4096mariadb: oltp_read_only - 128mariadb: oltp_update_non_index - 128mariadb: oltp_update_index - 128mysqlslap: 2048fio: Seq Write - IO_uring - Yes - 2MB - 16 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 2MB - 1 - Default Test Directorypgbench: 1000 - 1000 - Read Write - Average Latencypgbench: 1000 - 1000 - Read Writecockroach: KV, 60% Reads - 256sqlite: 16sqlite: 8Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000074990495243654942.2193209936119239470101366.5329.19329.86252621336.4972495259024.36541046107941.17.4544.415334173634337410134174623.093171573918933052585287.5340.17325.58250721335.803830012181081264323932352864781685168543.8672285994295.7123.97292.75211221704356223.773178083953.0338.17328.03252370332.7355985046.1752174792691.1133.45887.676109373802200410134324523.212171576419033453285748.4330.69320.33250646339.95379911213148126294383255181079545100043.9042286892980.0135.49993.2442448268825244911168614034291435218421795106033.3341.09323.26257581341.89386031229248226449160897115416621222122333.66629704107353.96.1082.525OpenBenchmarking.org

Flexible IO Tester

Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 16 - Disk Target: Default Test Directory

OpenBenchmarking.orgMB/s, More Is BetterFlexible IO Tester 3.36Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 16 - Disk Target: Default Test DirectoryCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000711002200330044005500SE +/- 0.00, N = 3SE +/- 11.98, N = 3SE +/- 143.79, N = 13SE +/- 77.06, N = 15SE +/- 1.53, N = 3337349931122109324481. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native

MariaDB

Test: oltp_write_only - Threads: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_write_only - Threads: 128Corsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000760K120K180K240K300KSE +/- 558.10, N = 3SE +/- 566.85, N = 3SE +/- 222.32, N = 373634738022688251. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

Flexible IO Tester

Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 1 - Disk Target: Default Test Directory

OpenBenchmarking.orgMB/s, More Is BetterFlexible IO Tester 3.36Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 1 - Disk Target: Default Test DirectoryCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000711002200330044005500SE +/- 0.67, N = 3SE +/- 4.81, N = 3SE +/- 130.58, N = 15SE +/- 171.84, N = 15SE +/- 0.88, N = 3337251831704200424491. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native

MariaDB mariadb-slap

Clients: 512

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 512Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000720406080100SE +/- 0.17, N = 3SE +/- 0.04, N = 3SE +/- 0.14, N = 3SE +/- 0.17, N = 3431011011111. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

Flexible IO Tester

Type: Sequential Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 64 - Disk Target: Default Test Directory

OpenBenchmarking.orgMB/s, More Is BetterFlexible IO Tester 3.36Type: Sequential Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 64 - Disk Target: Default Test DirectoryCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000715003000450060007500SE +/- 0.00, N = 3SE +/- 3.84, N = 3SE +/- 1.45, N = 3SE +/- 0.00, N = 3SE +/- 55.19, N = 3343364203562343268611. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native

MariaDB mariadb-slap

Clients: 1024

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 1024Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000071020304050SE +/- 0.05, N = 3SE +/- 0.47, N = 9SE +/- 0.53, N = 9SE +/- 0.13, N = 344645401. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

SQLite

Threads / Copies: 1

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 1Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TB612182430SE +/- 0.000, N = 3SE +/- 0.186, N = 3SE +/- 0.220, N = 3SE +/- 0.080, N = 32.21923.09323.77323.2121. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm

Flexible IO Tester

Type: Sequential Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 64 - Disk Target: Default Test Directory

OpenBenchmarking.orgIOPS, More Is BetterFlexible IO Tester 3.36Type: Sequential Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 64 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000077001400210028003500SE +/- 1.86, N = 3SE +/- 0.00, N = 3SE +/- 0.88, N = 3SE +/- 0.00, N = 3SE +/- 27.45, N = 3320917151780171534291. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native

MariaDB mariadb-slap

Clients: 32

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 32Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000730060090012001500SE +/- 2.78, N = 3SE +/- 9.35, N = 12SE +/- 0.39, N = 3SE +/- 2.47, N = 393673976414351. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB mariadb-slap

Clients: 256

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 256Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000750100150200250SE +/- 0.50, N = 3SE +/- 0.09, N = 3SE +/- 0.21, N = 3SE +/- 0.14, N = 31191891902181. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB mariadb-slap

Clients: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 128Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000790180270360450SE +/- 0.52, N = 3SE +/- 0.32, N = 3SE +/- 0.04, N = 3SE +/- 0.18, N = 32393303344211. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB mariadb-slap

Clients: 64

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 64Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000072004006008001000SE +/- 0.41, N = 3SE +/- 0.91, N = 3SE +/- 0.34, N = 3SE +/- 0.56, N = 34705255327951. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

CockroachDB

Workload: KV, 50% Reads - Concurrency: 256

OpenBenchmarking.orgops/s, More Is BetterCockroachDB 22.2Workload: KV, 50% Reads - Concurrency: 256Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000720K40K60K80K100KSE +/- 1341.10, N = 15SE +/- 624.14, N = 3SE +/- 477.68, N = 3SE +/- 302.48, N = 3SE +/- 828.24, N = 3101366.585287.583953.085748.4106033.3

ClickHouse

100M Rows Hits Dataset, Third Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, Third RunMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000770140210280350SE +/- 2.21, N = 3SE +/- 2.43, N = 5SE +/- 2.11, N = 4SE +/- 2.52, N = 3SE +/- 1.63, N = 3329.19340.17338.17330.69341.09MIN: 38.63 / MAX: 3000MIN: 38.27 / MAX: 4000MIN: 38.14 / MAX: 5454.55MIN: 37.5 / MAX: 3529.41MIN: 38.36 / MAX: 5000

ClickHouse

100M Rows Hits Dataset, First Run / Cold Cache

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, First Run / Cold CacheMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000770140210280350SE +/- 3.71, N = 3SE +/- 3.47, N = 5SE +/- 3.65, N = 4SE +/- 4.03, N = 3SE +/- 0.47, N = 3329.86325.58328.03320.33323.26MIN: 38.34 / MAX: 5000MIN: 37.81 / MAX: 4000MIN: 37.04 / MAX: 3529.41MIN: 36.97 / MAX: 3333.33MIN: 37.93 / MAX: 3750

Apache Cassandra

Test: Writes

OpenBenchmarking.orgOp/s, More Is BetterApache Cassandra 4.1.3Test: WritesMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000760K120K180K240K300KSE +/- 1354.41, N = 3SE +/- 415.66, N = 3SE +/- 856.73, N = 3SE +/- 1156.33, N = 3SE +/- 945.21, N = 3252621250721252370250646257581

ClickHouse

100M Rows Hits Dataset, Second Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, Second RunMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000770140210280350SE +/- 3.46, N = 3SE +/- 2.74, N = 5SE +/- 4.87, N = 4SE +/- 3.15, N = 3SE +/- 3.94, N = 3336.49335.80332.73339.95341.89MIN: 37.9 / MAX: 3750MIN: 38.07 / MAX: 3750MIN: 38.17 / MAX: 3750MIN: 37.64 / MAX: 4000MIN: 38.44 / MAX: 5000

MariaDB

Test: oltp_point_select - Threads: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_point_select - Threads: 128Corsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000078K16K24K32K40KSE +/- 26.99, N = 3SE +/- 24.16, N = 3SE +/- 23.41, N = 33830037991386031. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB

Test: oltp_read_write - Threads: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_read_write - Threads: 128Corsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000730K60K90K120K150KSE +/- 152.21, N = 3SE +/- 173.52, N = 3SE +/- 63.58, N = 31218101213141229241. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB mariadb-slap

Clients: 4096

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 4096Corsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000720406080100SE +/- 0.73, N = 9SE +/- 0.57, N = 3SE +/- 0.95, N = 38181821. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB

Test: oltp_read_only - Threads: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_read_only - Threads: 128Corsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000076K12K18K24K30KSE +/- 20.46, N = 3SE +/- 9.76, N = 3SE +/- 23.88, N = 32643226294264491. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB

Test: oltp_update_non_index - Threads: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_update_non_index - Threads: 128Corsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000730K60K90K120K150KSE +/- 2173.20, N = 9SE +/- 2550.78, N = 9SE +/- 91.45, N = 339323383251608971. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB

Test: oltp_update_index - Threads: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_update_index - Threads: 128Corsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000720K40K60K80K100KSE +/- 3430.94, N = 6SE +/- 2315.37, N = 9SE +/- 80.60, N = 352864518101154161. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB mariadb-slap

Clients: 2048

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 2048Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000720406080100SE +/- 0.38, N = 3SE +/- 0.88, N = 3SE +/- 0.74, N = 9SE +/- 0.85, N = 377879621. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

Flexible IO Tester

Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 16 - Disk Target: Default Test Directory

OpenBenchmarking.orgIOPS, More Is BetterFlexible IO Tester 3.36Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 16 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000075001000150020002500SE +/- 5.86, N = 3SE +/- 0.00, N = 3SE +/- 71.93, N = 13SE +/- 38.56, N = 15SE +/- 0.67, N = 32495168555954512221. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native

Flexible IO Tester

Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 1 - Disk Target: Default Test Directory

OpenBenchmarking.orgIOPS, More Is BetterFlexible IO Tester 3.36Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 1 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000076001200180024003000SE +/- 2.40, N = 3SE +/- 0.33, N = 3SE +/- 65.28, N = 15SE +/- 85.95, N = 15SE +/- 0.58, N = 325901685850100012231. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native

PostgreSQL

Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average LatencyMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000071020304050SE +/- 0.18, N = 3SE +/- 0.68, N = 12SE +/- 0.85, N = 12SE +/- 0.82, N = 12SE +/- 0.09, N = 324.3743.8746.1843.9033.671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 1000 - Mode: Read WriteMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000079K18K27K36K45KSE +/- 310.04, N = 3SE +/- 371.60, N = 12SE +/- 448.34, N = 12SE +/- 446.86, N = 12SE +/- 77.34, N = 341046228592174722868297041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

CockroachDB

Workload: KV, 60% Reads - Concurrency: 256

OpenBenchmarking.orgops/s, More Is BetterCockroachDB 22.2Workload: KV, 60% Reads - Concurrency: 256Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000720K40K60K80K100KSE +/- 1417.12, N = 15SE +/- 504.72, N = 3SE +/- 733.23, N = 3SE +/- 388.03, N = 3SE +/- 1826.76, N = 15107941.194295.792691.192980.0107353.9

SQLite

Threads / Copies: 16

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 16Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-00007306090120150SE +/- 0.031, N = 3SE +/- 1.278, N = 12SE +/- 1.241, N = 3SE +/- 0.565, N = 3SE +/- 0.371, N = 127.454123.972133.458135.4996.1081. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm

SQLite

Threads / Copies: 8

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 8Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000720406080100SE +/- 0.036, N = 3SE +/- 0.843, N = 3SE +/- 0.737, N = 3SE +/- 0.864, N = 3SE +/- 0.087, N = 124.41592.75287.67693.2442.5251. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm


Phoronix Test Suite v10.8.5