SSD Storage

Benchmarks for a future article.

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

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 Storagecassandra: Writesclickhouse: 100M Rows Hits Dataset, First Run / Cold Cacheclickhouse: 100M Rows Hits Dataset, Second Runclickhouse: 100M Rows Hits Dataset, Third Runcockroach: KV, 50% Reads - 256cockroach: KV, 60% Reads - 256fio: Seq Read - IO_uring - Yes - 2MB - 64 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 2MB - 1 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 2MB - 16 - Default Test Directoryfio: Seq Read - IO_uring - Yes - 2MB - 64 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 2MB - 1 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 2MB - 16 - Default Test Directorymariadb: oltp_read_only - 128mariadb: oltp_read_write - 128mariadb: oltp_write_only - 128mariadb: oltp_point_select - 128mariadb: oltp_update_index - 128mariadb: oltp_update_non_index - 128mysqlslap: 32mysqlslap: 64mysqlslap: 128mysqlslap: 256mysqlslap: 512mysqlslap: 1024mysqlslap: 2048mysqlslap: 4096pgbench: 1000 - 1000 - Read Writepgbench: 1000 - 1000 - Read Write - Average Latencysqlite: 1sqlite: 8sqlite: 16Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-00007252621329.86336.49329.19101366.5107941.164205183499332092590249593647023911943474104624.3652.2194.4157.454250721325.58335.80340.1785287.594295.734333372337317151685168526432121810736343830052864393237395253301891014678812285943.86723.09392.752123.972252370328.03332.73338.1783953.092691.135621704112217808505592174746.17523.77387.676133.458250646320.33339.95330.6985748.492980.03432200410931715100054526294121314738023799151810383257645323341901014579812286843.90423.21293.244135.499257581323.26341.89341.09106033.3107353.9686124492448342912231222264491229242688253860311541616089714357954212181114062822970433.6662.5256.108OpenBenchmarking.org

Apache Cassandra

Test: Writes

OpenBenchmarking.orgOp/s, More Is BetterApache Cassandra 4.1.3Test: WritesSamsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB60K120K180K240K300KSE +/- 945.21, N = 3SE +/- 1354.41, N = 3SE +/- 856.73, N = 3SE +/- 415.66, N = 3SE +/- 1156.33, N = 3257581252621252370250721250646

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.2TBCrucial T705 2TBCorsair MP700 PRO 2TBSamsung MZWLJ1T9HBJR-00007Corsair MP700 2TB70140210280350SE +/- 3.71, N = 3SE +/- 3.65, N = 4SE +/- 3.47, N = 5SE +/- 0.47, N = 3SE +/- 4.03, N = 3329.86328.03325.58323.26320.33MIN: 38.34 / MAX: 5000MIN: 37.04 / MAX: 3529.41MIN: 37.81 / MAX: 4000MIN: 37.93 / MAX: 3750MIN: 36.97 / MAX: 3333.33

ClickHouse

100M Rows Hits Dataset, Second Run

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

ClickHouse

100M Rows Hits Dataset, Third Run

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

CockroachDB

Workload: KV, 50% Reads - Concurrency: 256

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

CockroachDB

Workload: KV, 60% Reads - Concurrency: 256

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

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 DirectorySamsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB15003000450060007500SE +/- 55.19, N = 3SE +/- 9.45, N = 3SE +/- 1.45, N = 3SE +/- 0.00, N = 3SE +/- 0.00, N = 3686165493562343334321. (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.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 DirectoryMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBSamsung MZWLJ1T9HBJR-00007Corsair MP700 2TBCrucial T705 2TB11002200330044005500SE +/- 4.81, N = 3SE +/- 0.33, N = 3SE +/- 0.88, N = 3SE +/- 171.84, N = 15SE +/- 130.58, N = 15518333742449200417041. (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: 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 DirectoryMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBSamsung MZWLJ1T9HBJR-00007Crucial T705 2TBCorsair MP700 2TB11002200330044005500SE +/- 11.98, N = 3SE +/- 0.00, N = 3SE +/- 1.53, N = 3SE +/- 143.79, N = 13SE +/- 77.06, N = 15499333732448112210931. (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 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 DirectorySamsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB7001400210028003500SE +/- 27.45, N = 3SE +/- 1.86, N = 3SE +/- 0.88, N = 3SE +/- 0.00, N = 3SE +/- 0.00, N = 3342932091780171517151. (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 2TBSamsung MZWLJ1T9HBJR-00007Corsair MP700 2TBCrucial T705 2TB6001200180024003000SE +/- 2.40, N = 3SE +/- 0.33, N = 3SE +/- 0.58, N = 3SE +/- 85.95, N = 15SE +/- 65.28, N = 1525901685122310008501. (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: 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 2TBSamsung MZWLJ1T9HBJR-00007Crucial T705 2TBCorsair MP700 2TB5001000150020002500SE +/- 5.86, N = 3SE +/- 0.00, N = 3SE +/- 0.67, N = 3SE +/- 71.93, N = 13SE +/- 38.56, N = 152495168512225595451. (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_read_only - Threads: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_read_only - Threads: 128Samsung MZWLJ1T9HBJR-00007Corsair MP700 PRO 2TBCorsair MP700 2TB6K12K18K24K30KSE +/- 23.88, N = 3SE +/- 20.46, N = 3SE +/- 9.76, N = 32644926432262941. (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: 128Samsung MZWLJ1T9HBJR-00007Corsair MP700 PRO 2TBCorsair MP700 2TB30K60K90K120K150KSE +/- 63.58, N = 3SE +/- 152.21, N = 3SE +/- 173.52, N = 31229241218101213141. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB

Test: oltp_write_only - Threads: 128

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

MariaDB

Test: oltp_point_select - Threads: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_point_select - Threads: 128Samsung MZWLJ1T9HBJR-00007Corsair MP700 PRO 2TBCorsair MP700 2TB8K16K24K32K40KSE +/- 23.41, N = 3SE +/- 26.99, N = 3SE +/- 24.16, N = 33860338300379911. (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: 128Samsung MZWLJ1T9HBJR-00007Corsair MP700 PRO 2TBCorsair MP700 2TB20K40K60K80K100KSE +/- 80.60, N = 3SE +/- 3430.94, N = 6SE +/- 2315.37, N = 911541652864518101. (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: 128Samsung MZWLJ1T9HBJR-00007Corsair MP700 PRO 2TBCorsair MP700 2TB30K60K90K120K150KSE +/- 91.45, N = 3SE +/- 2173.20, N = 9SE +/- 2550.78, N = 916089739323383251. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB mariadb-slap

Clients: 32

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 32Samsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCorsair MP700 2TBCorsair MP700 PRO 2TB30060090012001500SE +/- 2.47, N = 3SE +/- 2.78, N = 3SE +/- 0.39, N = 3SE +/- 9.35, N = 1214359367647391. (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: 64Samsung MZWLJ1T9HBJR-00007Corsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TB2004006008001000SE +/- 0.56, N = 3SE +/- 0.34, N = 3SE +/- 0.91, N = 3SE +/- 0.41, N = 37955325254701. (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: 128Samsung MZWLJ1T9HBJR-00007Corsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TB90180270360450SE +/- 0.18, N = 3SE +/- 0.04, N = 3SE +/- 0.32, N = 3SE +/- 0.52, N = 34213343302391. (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: 256Samsung MZWLJ1T9HBJR-00007Corsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TB50100150200250SE +/- 0.14, N = 3SE +/- 0.21, N = 3SE +/- 0.09, N = 3SE +/- 0.50, N = 32181901891191. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB mariadb-slap

Clients: 512

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

MariaDB mariadb-slap

Clients: 1024

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 1024Corsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TB1020304050SE +/- 0.47, N = 9SE +/- 0.53, N = 9SE +/- 0.13, N = 3SE +/- 0.05, N = 346454041. (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: 2048Corsair MP700 2TBCorsair MP700 PRO 2TBSamsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TB20406080100SE +/- 0.74, N = 9SE +/- 0.88, N = 3SE +/- 0.85, N = 3SE +/- 0.38, N = 379786271. (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: 4096Samsung MZWLJ1T9HBJR-00007Corsair MP700 PRO 2TBCorsair MP700 2TB20406080100SE +/- 0.95, N = 3SE +/- 0.73, N = 9SE +/- 0.57, N = 38281811. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

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.2TBSamsung MZWLJ1T9HBJR-00007Corsair MP700 2TBCorsair MP700 PRO 2TBCrucial T705 2TB9K18K27K36K45KSE +/- 310.04, N = 3SE +/- 77.34, N = 3SE +/- 446.86, N = 12SE +/- 371.60, N = 12SE +/- 448.34, N = 1241046297042286822859217471. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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.2TBSamsung MZWLJ1T9HBJR-00007Corsair MP700 PRO 2TBCorsair MP700 2TBCrucial T705 2TB1020304050SE +/- 0.18, N = 3SE +/- 0.09, N = 3SE +/- 0.68, N = 12SE +/- 0.82, N = 12SE +/- 0.85, N = 1224.3733.6743.8743.9046.181. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

SQLite

Threads / Copies: 1

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

SQLite

Threads / Copies: 8

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

SQLite

Threads / Copies: 16

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

Phoronix Test Suite v10.8.5