w2145alma

Intel Xeon W-2145 testing with a ASUS WS C422 DC (3205 BIOS) and ASPEED on AlmaLinux 8.6 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2210241-NE-W2145ALMA87.

w2145almaProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemHetzner PX92 W-1245 128GB 2x 1.92TBIntel Xeon W-2145 - ASPEED - ASUS WS C422 DC (3205Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1 superfast screeningIntel Xeon W-2145 @ 4.50GHz (8 Cores / 16 Threads)ASUS WS C422 DC (3205 BIOS)Intel Sky Lake-E DMI3 Registers4 x 32 GB DDR4-2666MT/s Micron 36ASF4G72PZ-2G6J12 x 1920GB SAMSUNG MZQLB1T9HAJR-00007ASPEEDIntel I210AlmaLinux 8.64.18.0-348.20.1.el8_5.x86_64 (x86_64)GCC 8.5.0 20210514ext4OpenBenchmarking.orgKernel Details- Transparent Huge Pages: alwaysCompiler Details- --build=x86_64-redhat-linux --disable-libmpx --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-initfini-array --enable-languages=c,c++,fortran,lto --enable-multilib --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-gcc-major-version-only --with-isl --with-linker-hash-style=gnu --with-tune=generic --without-cuda-driver Processor Details- Scaling Governor: intel_pstate performance (EPP: performance) - CPU Microcode: 0x2006d05Security Details- itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline IBPB: conditional IBRS_FW STIBP: conditional RSB filling + srbds: Not affected + tsx_async_abort: Mitigation of Clear buffers; SMT vulnerable Disk Details- Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1, Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1 superfast screening: NONE / relatime,rw,seclabel / raid1 nvme0n1p3[0] nvme1n1p3[1] Block Size: 4096Python Details- Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1: Python 3.6.8

w2145almasmallpt: Global Illumination Renderer; 128 Samplespgbench: 1 - 1 - Read Onlypgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Write - Average Latencyaio-stress: Rand Writesqlite: 8sqlite: 32sqlite: 64sqlite: 128unpack-linux: linux-5.19.tar.xzbuild-php: Time To Compilecompress-pbzip2: FreeBSD-13.0-RELEASE-amd64-memstick.img Compressioncompress-gzip: Linux Source Tree Archiving To .tar.gzencode-mp3: WAV To MP3system-decompress-xz: openssl: SHA256openssl: RSA4096openssl: RSA4096pgbench: 1 - 50 - Read Onlypgbench: 1 - 50 - Read Only - Average Latencypgbench: 1 - 100 - Read Onlypgbench: 1 - 100 - Read Only - Average Latencypgbench: 1 - 250 - Read Onlypgbench: 1 - 250 - Read Only - Average Latencypgbench: 1 - 50 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 1 - 500 - Read Onlypgbench: 1 - 500 - Read Only - Average Latencypgbench: 100 - 1 - Read Onlypgbench: 100 - 1 - Read Only - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 250 - Read Writepgbench: 1 - 250 - Read Write - Average Latencypgbench: 1 - 500 - Read Writepgbench: 1 - 500 - Read Write - Average Latencypgbench: 100 - 1 - Read Writepgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 50 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 1000 - 1 - Read Onlypgbench: 1000 - 1 - Read Only - Average Latencypgbench: 100 - 100 - Read Onlypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 250 - Read Onlypgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 500 - Read Onlypgbench: 100 - 500 - Read Only - Average Latencypgbench: 1000 - 1 - Read Writepgbench: 1000 - 1 - Read Write - Average Latencypgbench: 1000 - 50 - Read Onlypgbench: 1000 - 50 - Read Only - Average Latencypgbench: 10000 - 1 - Read Onlypgbench: 10000 - 1 - Read Only - Average Latencypgbench: 25000 - 1 - Read Onlypgbench: 25000 - 1 - Read Only - Average Latencypgbench: 100 - 100 - Read Writepgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 250 - Read Writepgbench: 100 - 250 - Read Write - Average Latencypgbench: 100 - 500 - Read Writepgbench: 100 - 500 - Read Write - Average Latencypgbench: 1000 - 100 - Read Onlypgbench: 1000 - 100 - Read Only - Average Latencypgbench: 1000 - 250 - Read Onlypgbench: 1000 - 250 - Read Only - Average Latencypgbench: 1000 - 50 - Read Writepgbench: 1000 - 50 - Read Write - Average Latencypgbench: 1000 - 500 - Read Onlypgbench: 1000 - 500 - Read Only - Average Latencypgbench: 10000 - 1 - Read Writepgbench: 10000 - 1 - Read Write - Average Latencypgbench: 10000 - 50 - Read Onlypgbench: 10000 - 50 - Read Only - Average Latencypgbench: 25000 - 1 - Read Writepgbench: 25000 - 1 - Read Write - Average Latencypgbench: 25000 - 50 - Read Onlypgbench: 25000 - 50 - Read Only - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 100 - Read Write - Average Latencypgbench: 1000 - 250 - Read Writepgbench: 1000 - 250 - Read Write - Average Latencypgbench: 1000 - 500 - Read Writepgbench: 1000 - 500 - Read Write - Average Latencypgbench: 10000 - 100 - Read Onlypgbench: 10000 - 100 - Read Only - Average Latencypgbench: 10000 - 250 - Read Onlypgbench: 10000 - 250 - Read Only - Average Latencypgbench: 10000 - 50 - Read Writepgbench: 10000 - 50 - Read Write - Average Latencypgbench: 10000 - 500 - Read Onlypgbench: 10000 - 500 - Read Only - Average Latencyfio: Rand Read - POSIX AIO - Yes - No - 4KB - Default Test Directoryfio: Rand Read - POSIX AIO - Yes - No - 4KB - Default Test Directoryfio: Rand Write - POSIX AIO - Yes - No - 4KB - Default Test Directoryfio: Rand Write - POSIX AIO - Yes - No - 4KB - Default Test Directorystream: Copyscimark2: Compositehimeno: Poisson Pressure Solverc-ray: Total Time - 4K, 16 Rays Per PixelHetzner PX92 W-1245 128GB 2x 1.92TBIntel Xeon W-2145 - ASPEED - ASUS WS C422 DC (3205Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1 superfast screening11.235349380.02943000.233348960.02943070.2323695.513.4497.63214.64137.0107.59080.31411.52136.2998.9493.58027853892402500.0163245.92763250.1812710950.3692164311.15567617.3951937862.580329770.03502919.8832484100.6631326379.31540100.2502636860.190286060.0352560820.3902050531.219339721.4721824962.74036700.2732347360.213126890.07967230.149296043.3792495410.0191595431.7802172660.4601791071.396169282.9541599433.12630190.3311792000.27924970.4011527190.327176425.6691548116.1531194441.8821583780.6321442681.733116794.6991264153.955597153000208453366755291.9682.573011.29602483.892OpenBenchmarking.org

Smallpt

Global Illumination Renderer; 128 Samples

OpenBenchmarking.orgSeconds, Fewer Is BetterSmallpt 1.0Global Illumination Renderer; 128 SamplesHetzner PX92 W-1245 128GB 2x 1.92TB3691215SE +/- 0.06, N = 311.241. (CXX) g++ options: -fopenmp -O3

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read OnlyIntel Xeon W-2145 - ASPEED - ASUS WS C422 DC (3205Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID17K14K21K28K35KSE +/- 158.11, N = 3SE +/- 161.56, N = 334938348961. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average LatencyIntel Xeon W-2145 - ASPEED - ASUS WS C422 DC (3205Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.00650.0130.01950.0260.0325SE +/- 0.000, N = 3SE +/- 0.000, N = 30.0290.0291. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read WriteIntel Xeon W-2145 - ASPEED - ASUS WS C422 DC (3205Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID19001800270036004500SE +/- 11.84, N = 3SE +/- 2.02, N = 3430043071. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average LatencyIntel Xeon W-2145 - ASPEED - ASUS WS C422 DC (3205Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.05240.10480.15720.20960.262SE +/- 0.001, N = 3SE +/- 0.000, N = 30.2330.2321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

AIO-Stress

Test: Random Write

OpenBenchmarking.orgMB/s, More Is BetterAIO-Stress 0.21Test: Random WriteHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID18001600240032004000SE +/- 15.84, N = 33695.511. (CC) gcc options: -O3 -pthread -laio

SQLite

Threads / Copies: 8

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 8Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.7761.5522.3283.1043.88SE +/- 0.020, N = 33.4491. (CC) gcc options: -O2 -lm -ldl -lpthread

SQLite

Threads / Copies: 32

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 32Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1246810SE +/- 0.026, N = 37.6321. (CC) gcc options: -O2 -lm -ldl -lpthread

SQLite

Threads / Copies: 64

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 64Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID148121620SE +/- 0.11, N = 314.641. (CC) gcc options: -O2 -lm -ldl -lpthread

SQLite

Threads / Copies: 128

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 128Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1918273645SE +/- 0.12, N = 337.011. (CC) gcc options: -O2 -lm -ldl -lpthread

Unpacking The Linux Kernel

linux-5.19.tar.xz

OpenBenchmarking.orgSeconds, Fewer Is BetterUnpacking The Linux Kernel 5.19linux-5.19.tar.xzHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1246810SE +/- 0.015, N = 47.590

Timed PHP Compilation

Time To Compile

OpenBenchmarking.orgSeconds, Fewer Is BetterTimed PHP Compilation 8.1.9Time To CompileHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID120406080100SE +/- 0.22, N = 380.31

Parallel BZIP2 Compression

FreeBSD-13.0-RELEASE-amd64-memstick.img Compression

OpenBenchmarking.orgSeconds, Fewer Is BetterParallel BZIP2 Compression 1.1.13FreeBSD-13.0-RELEASE-amd64-memstick.img CompressionHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID13691215SE +/- 0.01, N = 311.521. (CXX) g++ options: -O2 -pthread -lbz2 -lpthread

Gzip Compression

Linux Source Tree Archiving To .tar.gz

OpenBenchmarking.orgSeconds, Fewer Is BetterGzip CompressionLinux Source Tree Archiving To .tar.gzHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1816243240SE +/- 0.08, N = 336.30

LAME MP3 Encoding

WAV To MP3

OpenBenchmarking.orgSeconds, Fewer Is BetterLAME MP3 Encoding 3.100WAV To MP3Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1246810SE +/- 0.007, N = 38.9491. (CC) gcc options: -O3 -ffast-math -funroll-loops -fschedule-insns2 -fbranch-count-reg -fforce-addr -pipe -lm

System XZ Decompression

OpenBenchmarking.orgSeconds, Fewer Is BetterSystem XZ DecompressionHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.80551.6112.41653.2224.0275SE +/- 0.001, N = 33.580

OpenSSL

Algorithm: SHA256

OpenBenchmarking.orgbyte/s, More Is BetterOpenSSL 3.0Algorithm: SHA256Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1600M1200M1800M2400M3000MSE +/- 1273734.34, N = 327853892401. (CC) gcc options: -pthread -m64 -O3 -lssl -lcrypto -ldl

OpenSSL

Algorithm: RSA4096

OpenBenchmarking.orgsign/s, More Is BetterOpenSSL 3.0Algorithm: RSA4096Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID15001000150020002500SE +/- 1.53, N = 32500.01. (CC) gcc options: -pthread -m64 -O3 -lssl -lcrypto -ldl

OpenSSL

Algorithm: RSA4096

OpenBenchmarking.orgverify/s, More Is BetterOpenSSL 3.0Algorithm: RSA4096Hetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID130K60K90K120K150KSE +/- 106.84, N = 3163245.91. (CC) gcc options: -pthread -m64 -O3 -lssl -lcrypto -ldl

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID160K120K180K240K300KSE +/- 288.02, N = 32763251. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.04070.08140.12210.16280.2035SE +/- 0.000, N = 30.1811. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID160K120K180K240K300KSE +/- 439.16, N = 32710951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.0830.1660.2490.3320.415SE +/- 0.001, N = 30.3691. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 250 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID150K100K150K200K250KSE +/- 273.24, N = 32164311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.25990.51980.77971.03961.2995SE +/- 0.001, N = 31.1551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read WriteHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID114002800420056007000SE +/- 2.01, N = 367611. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1246810SE +/- 0.002, N = 37.3951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID140K80K120K160K200KSE +/- 214.38, N = 31937861. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.58051.1611.74152.3222.9025SE +/- 0.003, N = 32.5801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID17K14K21K28K35KSE +/- 123.27, N = 3329771. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.00680.01360.02040.02720.034SE +/- 0.00, N = 30.031. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read WriteHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID111002200330044005500SE +/- 7.49, N = 350291. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1510152025SE +/- 0.03, N = 319.881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 250 - Mode: Read WriteHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID15001000150020002500SE +/- 9.26, N = 324841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID120406080100SE +/- 0.38, N = 3100.661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read WriteHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID130060090012001500SE +/- 30.56, N = 1213261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID180160240320400SE +/- 9.27, N = 12379.321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read WriteHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID19001800270036004500SE +/- 4.92, N = 340101. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.05630.11260.16890.22520.2815SE +/- 0.000, N = 30.2501. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID160K120K180K240K300KSE +/- 596.93, N = 32636861. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.04280.08560.12840.17120.214SE +/- 0.000, N = 30.1901. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID16K12K18K24K30KSE +/- 55.03, N = 3286061. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.00790.01580.02370.03160.0395SE +/- 0.000, N = 30.0351. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID150K100K150K200K250KSE +/- 452.72, N = 32560821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.08780.17560.26340.35120.439SE +/- 0.001, N = 30.3901. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 250 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID140K80K120K160K200KSE +/- 78.55, N = 32050531. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.27430.54860.82291.09721.3715SE +/- 0.001, N = 31.2191. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read WriteHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID17K14K21K28K35KSE +/- 41.32, N = 3339721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.33120.66240.99361.32481.656SE +/- 0.002, N = 31.4721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID140K80K120K160K200KSE +/- 150.22, N = 31824961. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.61651.2331.84952.4663.0825SE +/- 0.002, N = 32.7401. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1 - Mode: Read WriteHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID18001600240032004000SE +/- 1.66, N = 336701. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.06140.12280.18420.24560.307SE +/- 0.000, N = 30.2731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID150K100K150K200K250KSE +/- 227.95, N = 32347361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.04790.09580.14370.19160.2395SE +/- 0.000, N = 30.2131. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 1 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID13K6K9K12K15KSE +/- 112.49, N = 3126891. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 1 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.01780.03560.05340.07120.089SE +/- 0.001, N = 30.0791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 1 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID114002800420056007000SE +/- 6.85, N = 367231. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 25000 - Clients: 1 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 1 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.03350.0670.10050.1340.1675SE +/- 0.000, N = 30.1491. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read WriteHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID16K12K18K24K30KSE +/- 333.82, N = 3296041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.76031.52062.28093.04123.8015SE +/- 0.039, N = 33.3791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 250 - Mode: Read WriteHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID15K10K15K20K25KSE +/- 132.69, N = 3249541. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID13691215SE +/- 0.05, N = 310.021. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read WriteHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID13K6K9K12K15KSE +/- 665.66, N = 9159541. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1714212835SE +/- 1.32, N = 931.781. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID150K100K150K200K250KSE +/- 531.92, N = 32172661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.10350.2070.31050.4140.5175SE +/- 0.001, N = 30.4601. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 250 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID140K80K120K160K200KSE +/- 409.55, N = 31791071. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.31410.62820.94231.25641.5705SE +/- 0.003, N = 31.3961. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read WriteHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID14K8K12K16K20KSE +/- 98.80, N = 3169281. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.66471.32941.99412.65883.3235SE +/- 0.017, N = 32.9541. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 500 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID130K60K90K120K150KSE +/- 270.92, N = 31599431. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.70341.40682.11022.81363.517SE +/- 0.005, N = 33.1261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 1 - Mode: Read WriteHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID16001200180024003000SE +/- 31.77, N = 530191. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 1 - Mode: Read Write - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.07450.1490.22350.2980.3725SE +/- 0.004, N = 50.3311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 50 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID140K80K120K160K200KSE +/- 224.55, N = 31792001. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 50 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.06280.12560.18840.25120.314SE +/- 0.001, N = 30.2791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 1 - Mode: Read WriteHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID15001000150020002500SE +/- 8.36, N = 324971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 25000 - Clients: 1 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 1 - Mode: Read Write - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.09020.18040.27060.36080.451SE +/- 0.001, N = 30.4011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 50 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID130K60K90K120K150KSE +/- 553.87, N = 31527191. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

Scaling Factor: 25000 - Clients: 50 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 50 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.07360.14720.22080.29440.368SE +/- 0.001, N = 30.3271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read WriteHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID14K8K12K16K20KSE +/- 149.96, N = 3176421. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID11.27552.5513.82655.1026.3775SE +/- 0.048, N = 35.6691. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 250 - Mode: Read WriteHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID13K6K9K12K15KSE +/- 169.01, N = 3154811. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID148121620SE +/- 0.17, N = 316.151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 500 - Mode: Read WriteHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID13K6K9K12K15KSE +/- 107.10, N = 7119441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID11020304050SE +/- 0.37, N = 741.881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 100 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID130K60K90K120K150KSE +/- 567.88, N = 31583781. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 100 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.14220.28440.42660.56880.711SE +/- 0.002, N = 30.6321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 250 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID130K60K90K120K150KSE +/- 191.22, N = 31442681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 250 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.38990.77981.16971.55961.9495SE +/- 0.002, N = 31.7331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 50 - Mode: Read WriteHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID13K6K9K12K15KSE +/- 1013.77, N = 9116791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 50 - Mode: Read Write - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID11.05732.11463.17194.22925.2865SE +/- 0.602, N = 94.6991. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 500 - Mode: Read OnlyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID130K60K90K120K150KSE +/- 128.08, N = 31264151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 500 - Mode: Read Only - Average LatencyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID10.88991.77982.66973.55964.4495SE +/- 0.004, N = 33.9551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Flexible IO Tester

Type: Random Read - IO Engine: POSIX AIO - Buffered: Yes - Direct: No - Block Size: 4KB - Disk Target: Default Test Directory

OpenBenchmarking.orgMB/s, More Is BetterFlexible IO Tester 3.1Type: Random Read - IO Engine: POSIX AIO - Buffered: Yes - Direct: No - Block Size: 4KB - Disk Target: Default Test DirectoryHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1 superfast screening130260390520650SE +/- 4.18, N = 35971. (CC) gcc options: -rdynamic -std=gnu99 -ffast-math -include -O3 -U_FORTIFY_SOURCE -lrt -laio -lz -lm -lpthread -ldl

Flexible IO Tester

Type: Random Read - IO Engine: POSIX AIO - Buffered: Yes - Direct: No - Block Size: 4KB - Disk Target: Default Test Directory

OpenBenchmarking.orgIOPS, More Is BetterFlexible IO Tester 3.1Type: Random Read - IO Engine: POSIX AIO - Buffered: Yes - Direct: No - Block Size: 4KB - Disk Target: Default Test DirectoryHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1 superfast screening30K60K90K120K150KSE +/- 1000.00, N = 31530001. (CC) gcc options: -rdynamic -std=gnu99 -ffast-math -include -O3 -U_FORTIFY_SOURCE -lrt -laio -lz -lm -lpthread -ldl

Flexible IO Tester

Type: Random Write - IO Engine: POSIX AIO - Buffered: Yes - Direct: No - Block Size: 4KB - Disk Target: Default Test Directory

OpenBenchmarking.orgMB/s, More Is BetterFlexible IO Tester 3.1Type: Random Write - IO Engine: POSIX AIO - Buffered: Yes - Direct: No - Block Size: 4KB - Disk Target: Default Test DirectoryHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1 superfast screening400800120016002000SE +/- 6.23, N = 320841. (CC) gcc options: -rdynamic -std=gnu99 -ffast-math -include -O3 -U_FORTIFY_SOURCE -lrt -laio -lz -lm -lpthread -ldl

Flexible IO Tester

Type: Random Write - IO Engine: POSIX AIO - Buffered: Yes - Direct: No - Block Size: 4KB - Disk Target: Default Test Directory

OpenBenchmarking.orgIOPS, More Is BetterFlexible IO Tester 3.1Type: Random Write - IO Engine: POSIX AIO - Buffered: Yes - Direct: No - Block Size: 4KB - Disk Target: Default Test DirectoryHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1 superfast screening110K220K330K440K550KSE +/- 1855.92, N = 35336671. (CC) gcc options: -rdynamic -std=gnu99 -ffast-math -include -O3 -U_FORTIFY_SOURCE -lrt -laio -lz -lm -lpthread -ldl

Stream

Type: Copy

OpenBenchmarking.orgMB/s, More Is BetterStream 2013-01-17Type: CopyHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1 superfast screening12K24K36K48K60KSE +/- 98.68, N = 555291.91. (CC) gcc options: -O3 -march=native -fopenmp

SciMark

Computational Test: Composite

OpenBenchmarking.orgMflops, More Is BetterSciMark 2.0Computational Test: CompositeHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1 superfast screening150300450600750SE +/- 0.09, N = 3682.571. (CC) gcc options: -lm

Himeno Benchmark

Poisson Pressure Solver

OpenBenchmarking.orgMFLOPS, More Is BetterHimeno Benchmark 3.0Poisson Pressure SolverHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1 superfast screening6001200180024003000SE +/- 9.35, N = 33011.301. (CC) gcc options: -O3 -mavx2

C-Ray

Total Time - 4K, 16 Rays Per Pixel

OpenBenchmarking.orgSeconds, Fewer Is BetterC-Ray 1.1Total Time - 4K, 16 Rays Per PixelHetzner PX92 ASUS-WS-C422 INTEL W-1245 128GB-ECC-2666 2x1.92TB-RAID1 superfast screening20406080100SE +/- 0.33, N = 383.891. (CC) gcc options: -lm -lpthread -O3

Phoronix Test Suite v10.8.4