pg

2 x AMD EPYC 9334 32-Core testing with a Supermicro H13DSH (1.5 BIOS) and astdrmfb on AlmaLinux 9.2 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 2309164-NE-PG306658496
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
Show Result Confidence Charts
Allow Limiting Results To Certain Suite(s)

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
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
Toggle/Hide
Result
Result
Identifier
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
a
September 15 2023
  13 Hours, 37 Minutes
b
September 16 2023
  2 Hours, 33 Minutes
c
September 16 2023
  2 Hours, 33 Minutes
d
September 16 2023
  2 Hours, 33 Minutes
Invert Behavior (Only Show Selected Data)
  5 Hours, 19 Minutes

Only show results where is faster than
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):

a

Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=x86_64-redhat-linux --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-host-bind-now --enable-host-pie --enable-initfini-array --enable-languages=c,c++,fortran,lto --enable-link-serialization=1 --enable-multilib --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-arch_64=x86-64-v2 --with-build-config=bootstrap-lto --with-gcc-major-version-only --with-linker-hash-style=gnu --with-tune=generic --without-cuda-driver --without-isl
Processor Notes: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xa10113e
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional IBRS_FW STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

b

c

d

Processor: 2 x AMD EPYC 9334 32-Core @ 2.70GHz (64 Cores / 128 Threads), Motherboard: Supermicro H13DSH (1.5 BIOS), Memory: 24 x 32 GB DDR5-4800MT/s Samsung M321R4GA3BB6-CQKET, Disk: 2 x 1920GB SAMSUNG MZQL21T9HCJR-00A07, Graphics: astdrmfb, Monitor: DELL E207WFP

OS: AlmaLinux 9.2, Kernel: 5.14.0-284.25.1.el9_2.x86_64 (x86_64), Compiler: GCC 11.3.1 20221121, File-System: ext4, Screen Resolution: 1680x1050

pgOpenBenchmarking.orgPhoronix Test Suite2 x AMD EPYC 9334 32-Core @ 2.70GHz (64 Cores / 128 Threads)Supermicro H13DSH (1.5 BIOS)24 x 32 GB DDR5-4800MT/s Samsung M321R4GA3BB6-CQKET2 x 1920GB SAMSUNG MZQL21T9HCJR-00A07astdrmfbDELL E207WFPAlmaLinux 9.25.14.0-284.25.1.el9_2.x86_64 (x86_64)GCC 11.3.1 20221121ext41680x1050ProcessorMotherboardMemoryDiskGraphicsMonitorOSKernelCompilerFile-SystemScreen ResolutionPg BenchmarksSystem Logs- Transparent Huge Pages: always- --build=x86_64-redhat-linux --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-host-bind-now --enable-host-pie --enable-initfini-array --enable-languages=c,c++,fortran,lto --enable-link-serialization=1 --enable-multilib --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-arch_64=x86-64-v2 --with-build-config=bootstrap-lto --with-gcc-major-version-only --with-linker-hash-style=gnu --with-tune=generic --without-cuda-driver --without-isl - Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xa10113e - itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional IBRS_FW STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

abcdResult OverviewPhoronix Test Suite100%107%114%120%127%PostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQL1000 - 800 - Read Write - Average Latency1000 - 800 - Read Write1000 - 1000 - Read Write - Average Latency1000 - 1000 - Read Write1 - 800 - Read Write - Average Latency1 - 800 - Read Write1000 - 500 - Read Write - Average Latency1000 - 500 - Read Write1 - 1000 - Read Write1 - 1000 - Read Write - Average Latency100 - 100 - Read Write100 - 100 - Read Write - Average Latency100 - 1000 - Read Write100 - 1000 - Read Write - Average Latency1000 - 250 - Read Write1000 - 250 - Read Write - Average Latency100 - 800 - Read Write100 - 800 - Read Write - Average Latency1000 - 100 - Read Only - Average Latency100 - 250 - Read Write1 - 100 - Read Only100 - 250 - Read Write - Average Latency1 - 100 - Read Write - Average Latency1 - 100 - Read Write1000 - 100 - Read Write - Average Latency1000 - 100 - Read Write1 - 100 - Read Only - Average Latency100 - 500 - Read Write - Average Latency100 - 500 - Read Write1 - 500 - Read Write - Average Latency1 - 500 - Read Write1000 - 1000 - Read Only - Average Latency1000 - 500 - Read Only1000 - 1000 - Read Only1000 - 500 - Read Only - Average Latency1000 - 100 - Read Only1 - 250 - Read Write - Average Latency1 - 250 - Read Write1000 - 800 - Read Only - Average Latency1000 - 800 - Read Only1 - 1000 - Read Only - Average Latency1 - 1000 - Read Only1 - 800 - Read Only100 - 250 - Read Only - Average Latency1 - 800 - Read Only - Average Latency1 - 250 - Read Only100 - 250 - Read Only100 - 100 - Read Only100 - 800 - Read Only1000 - 250 - Read Only - Average Latency100 - 800 - Read Only - Average Latency100 - 1000 - Read Only1 - 500 - Read Only - Average Latency100 - 500 - Read Only - Average Latency100 - 1000 - Read Only - Average Latency1 - 500 - Read Only1000 - 250 - Read Only100 - 500 - Read Only1 - 250 - Read Only - Average Latency100 - 100 - Read Only - Average Latency

pgpgbench: 1 - 100 - Read Onlypgbench: 1 - 250 - Read Onlypgbench: 1 - 500 - Read Onlypgbench: 1 - 800 - Read Onlypgbench: 1 - 100 - Read Writepgbench: 1 - 1000 - Read Onlypgbench: 1 - 250 - Read Writepgbench: 1 - 500 - Read Writepgbench: 1 - 800 - Read Writepgbench: 1 - 1000 - Read Writepgbench: 100 - 100 - Read Onlypgbench: 100 - 250 - Read Onlypgbench: 100 - 500 - Read Onlypgbench: 100 - 800 - Read Onlypgbench: 100 - 100 - Read Writepgbench: 100 - 1000 - Read Onlypgbench: 100 - 250 - Read Writepgbench: 100 - 500 - Read Writepgbench: 100 - 800 - Read Writepgbench: 1000 - 100 - Read Onlypgbench: 1000 - 250 - Read Onlypgbench: 1000 - 500 - Read Onlypgbench: 1000 - 800 - Read Onlypgbench: 100 - 1000 - Read Writepgbench: 1000 - 100 - Read Writepgbench: 1000 - 1000 - Read Onlypgbench: 1000 - 250 - Read Writepgbench: 1000 - 500 - Read Writepgbench: 1000 - 800 - Read Writepgbench: 1000 - 1000 - Read Writepgbench: 1 - 100 - Read Only - Average Latencypgbench: 1 - 250 - Read Only - Average Latencypgbench: 1 - 500 - Read Only - Average Latencypgbench: 1 - 800 - Read Only - Average Latencypgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 1000 - Read Only - Average Latencypgbench: 1 - 250 - Read Write - Average Latencypgbench: 1 - 500 - Read Write - Average Latencypgbench: 1 - 800 - Read Write - Average Latencypgbench: 1 - 1000 - Read Write - Average Latencypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 500 - Read Only - Average Latencypgbench: 100 - 800 - Read Only - Average Latencypgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 1000 - Read Only - Average Latencypgbench: 100 - 250 - Read Write - Average Latencypgbench: 100 - 500 - Read Write - Average Latencypgbench: 100 - 800 - Read Write - Average Latencypgbench: 1000 - 100 - Read Only - Average Latencypgbench: 1000 - 250 - Read Only - Average Latencypgbench: 1000 - 500 - Read Only - Average Latencypgbench: 1000 - 800 - Read Only - Average Latencypgbench: 100 - 1000 - Read Write - Average Latencypgbench: 1000 - 100 - Read Write - Average Latencypgbench: 1000 - 1000 - Read Only - Average Latencypgbench: 1000 - 250 - Read Write - Average Latencypgbench: 1000 - 500 - Read Write - Average Latencypgbench: 1000 - 800 - Read Write - Average Latencypgbench: 1000 - 1000 - Read Write - Average Latencyabcd2906916318450731883673191239658431715983822213811899732718842306794130750243053603446323038110438404168239048196081219657971867717169554536991520221659453476643356226625259930.0340.0790.1570.25115.1890.31565.422234.566677.8911034.0410.0370.0820.1630.2622.2470.3295.71011.99820.4940.0510.1270.2680.47227.0361.9220.6035.24514.95230.19238.5663018792314912631745123147653676431812953840209012409872718217309815730733973043460400593048993421944238838019198386419555691877805172121633332516571697494472123834433684327680.0330.0790.1580.25414.7850.31465.103239.213645.1411013.6250.0370.0810.1630.2632.4960.3285.92511.79621.0420.050.1280.2660.46530.0021.9360.5895.29513.0423.7530.5172905987316939831847543178549679631376693893214611309282693954308803530772213070971438793041993435014207437569197335719575101886110170296235833504741664444446183371431481316810.0340.0790.1570.25214.7140.31964.218232.955708.2491077.1420.0370.0810.1620.2612.2790.3295.74711.88421.2940.0510.1280.2650.4727.9071.9810.6015.60314.8325.41231.56529869913164898317079731881686783314775138242130136210602701414309870830851133050704441923059568431464287839097194096219563281843748172325236197504801683091467643590729707318140.0330.0790.1580.25114.7430.31865.383234.692587.187943.5260.0370.0810.1620.2622.2630.3275.79411.66120.4620.0520.1280.2710.46427.6271.9810.5945.34613.92526.9331.432OpenBenchmarking.org

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Onlydcba600K1200K1800K2400K3000KSE +/- 40247.86, N = 329869912905987301879229069161. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Onlydcba700K1400K2100K2800K3500KSE +/- 7746.31, N = 331648983169398314912631845071. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Onlydcba700K1400K2100K2800K3500KSE +/- 15402.95, N = 331707973184754317451231883671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Onlydcba700K1400K2100K2800K3500KSE +/- 2612.02, N = 331881683178549314765331912391. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Writedcba15003000450060007500SE +/- 32.21, N = 367836796676465841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 1000 - Mode: Read Onlydcba700K1400K2100K2800K3500KSE +/- 2661.02, N = 331477513137669318129531715981. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Writedcba8001600240032004000SE +/- 18.65, N = 338243893384038221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Writedcba5001000150020002500SE +/- 34.12, N = 1221302146209021381. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Writedcba30060090012001500SE +/- 36.50, N = 913621130124011891. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 1000 - Mode: Read Writedcba2004006008001000SE +/- 23.46, N = 1210609289879731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Onlydcba600K1200K1800K2400K3000KSE +/- 4978.80, N = 327014142693954271821727188421. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Onlydcba700K1400K2100K2800K3500KSE +/- 959.52, N = 330987083088035309815730679411. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Onlydcba700K1400K2100K2800K3500KSE +/- 2783.36, N = 330851133077221307339730750241. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Onlydcba700K1400K2100K2800K3500KSE +/- 1641.60, N = 330507043070971304346030536031. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Writedcba10K20K30K40K50KSE +/- 745.47, N = 12441924387940059446321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read Onlydcba700K1400K2100K2800K3500KSE +/- 11075.38, N = 330595683041993304899330381101. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Writedcba9K18K27K36K45KSE +/- 465.88, N = 12431464350142194438401. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Writedcba9K18K27K36K45KSE +/- 442.25, N = 3428784207442388416821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Writedcba8K16K24K32K40KSE +/- 490.95, N = 3390973756938019390481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 100 - Mode: Read Onlydcba400K800K1200K1600K2000KSE +/- 14890.85, N = 319409621973357198386419608121. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 250 - Mode: Read Onlydcba400K800K1200K1600K2000KSE +/- 1363.18, N = 319563281957510195556919657971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 500 - Mode: Read Onlydcba400K800K1200K1600K2000KSE +/- 9438.96, N = 318437481886110187780518677171. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 800 - Mode: Read Onlydcba400K800K1200K1600K2000KSE +/- 1528.61, N = 317232521702962172121616955451. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read Writedcba8K16K24K32K40KSE +/- 236.44, N = 3361973583333332369911. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 100 - Mode: Read Writedcba11K22K33K44K55KSE +/- 485.68, N = 3504805047451657520221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 1000 - Mode: Read Onlydcba400K800K1200K1600K2000KSE +/- 6736.49, N = 316830911664444169749416594531. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 250 - Mode: Read Writedcba10K20K30K40K50KSE +/- 261.46, N = 3467644461847212476641. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 500 - Mode: Read Writedcba8K16K24K32K40KSE +/- 594.38, N = 12359073371438344335621. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 800 - Mode: Read Writedcba7K14K21K28K35KSE +/- 569.90, N = 12297073148133684266251. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 1000 - Mode: Read Writedcba7K14K21K28K35KSE +/- 388.28, N = 12318143168132768259931. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latencydcba0.00770.01540.02310.03080.0385SE +/- 0.000, N = 30.0330.0340.0330.0341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latencydcba0.01780.03560.05340.07120.089SE +/- 0.000, N = 30.0790.0790.0790.0791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latencydcba0.03560.07120.10680.14240.178SE +/- 0.001, N = 30.1580.1570.1580.1571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latencydcba0.05720.11440.17160.22880.286SE +/- 0.000, N = 30.2510.2520.2540.2511. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latencydcba48121620SE +/- 0.07, N = 314.7414.7114.7915.191. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latencydcba0.07180.14360.21540.28720.359SE +/- 0.000, N = 30.3180.3190.3140.3151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latencydcba1530456075SE +/- 0.32, N = 365.3864.2265.1065.421. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latencydcba50100150200250SE +/- 3.95, N = 12234.69232.96239.21234.571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latencydcba150300450600750SE +/- 20.56, N = 9587.19708.25645.14677.891. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latencydcba2004006008001000SE +/- 25.32, N = 12943.531077.141013.631034.041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latencydcba0.00830.01660.02490.03320.0415SE +/- 0.000, N = 30.0370.0370.0370.0371. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latencydcba0.01850.0370.05550.0740.0925SE +/- 0.000, N = 30.0810.0810.0810.0821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latencydcba0.03670.07340.11010.14680.1835SE +/- 0.000, N = 30.1620.1620.1630.1631. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latencydcba0.05920.11840.17760.23680.296SE +/- 0.000, N = 30.2620.2610.2630.2621. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latencydcba0.56161.12321.68482.24642.808SE +/- 0.036, N = 122.2632.2792.4962.2471. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latencydcba0.0740.1480.2220.2960.37SE +/- 0.001, N = 30.3270.3290.3280.3291. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latencydcba1.33312.66623.99935.33246.6655SE +/- 0.063, N = 125.7945.7475.9255.7101. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latencydcba3691215SE +/- 0.13, N = 311.6611.8811.8012.001. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latencydcba510152025SE +/- 0.26, N = 320.4621.2921.0420.491. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latencydcba0.01170.02340.03510.04680.0585SE +/- 0.000, N = 30.0520.0510.0500.0511. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latencydcba0.02880.05760.08640.11520.144SE +/- 0.000, N = 30.1280.1280.1280.1271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latencydcba0.0610.1220.1830.2440.305SE +/- 0.001, N = 30.2710.2650.2660.2681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average Latencydcba0.10620.21240.31860.42480.531SE +/- 0.001, N = 30.4640.4700.4650.4721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latencydcba714212835SE +/- 0.17, N = 327.6327.9130.0027.041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latencydcba0.44570.89141.33711.78282.2285SE +/- 0.018, N = 31.9811.9811.9361.9221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latencydcba0.13570.27140.40710.54280.6785SE +/- 0.002, N = 30.5940.6010.5890.6031. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latencydcba1.26072.52143.78215.04286.3035SE +/- 0.029, N = 35.3465.6035.2955.2451. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latencydcba48121620SE +/- 0.28, N = 1213.9314.8313.0414.951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average Latencydcba714212835SE +/- 0.62, N = 1226.9325.4123.7530.191. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latencydcba918273645SE +/- 0.57, N = 1231.4331.5730.5238.571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

60 Results Shown

PostgreSQL:
  1 - 100 - Read Only
  1 - 250 - Read Only
  1 - 500 - Read Only
  1 - 800 - Read Only
  1 - 100 - Read Write
  1 - 1000 - Read Only
  1 - 250 - Read Write
  1 - 500 - Read Write
  1 - 800 - Read Write
  1 - 1000 - Read Write
  100 - 100 - Read Only
  100 - 250 - Read Only
  100 - 500 - Read Only
  100 - 800 - Read Only
  100 - 100 - Read Write
  100 - 1000 - Read Only
  100 - 250 - Read Write
  100 - 500 - Read Write
  100 - 800 - Read Write
  1000 - 100 - Read Only
  1000 - 250 - Read Only
  1000 - 500 - Read Only
  1000 - 800 - Read Only
  100 - 1000 - Read Write
  1000 - 100 - Read Write
  1000 - 1000 - Read Only
  1000 - 250 - Read Write
  1000 - 500 - Read Write
  1000 - 800 - Read Write
  1000 - 1000 - Read Write
  1 - 100 - Read Only - Average Latency
  1 - 250 - Read Only - Average Latency
  1 - 500 - Read Only - Average Latency
  1 - 800 - Read Only - Average Latency
  1 - 100 - Read Write - Average Latency
  1 - 1000 - Read Only - Average Latency
  1 - 250 - Read Write - Average Latency
  1 - 500 - Read Write - Average Latency
  1 - 800 - Read Write - Average Latency
  1 - 1000 - Read Write - Average Latency
  100 - 100 - Read Only - Average Latency
  100 - 250 - Read Only - Average Latency
  100 - 500 - Read Only - Average Latency
  100 - 800 - Read Only - Average Latency
  100 - 100 - Read Write - Average Latency
  100 - 1000 - Read Only - Average Latency
  100 - 250 - Read Write - Average Latency
  100 - 500 - Read Write - Average Latency
  100 - 800 - Read Write - Average Latency
  1000 - 100 - Read Only - Average Latency
  1000 - 250 - Read Only - Average Latency
  1000 - 500 - Read Only - Average Latency
  1000 - 800 - Read Only - Average Latency
  100 - 1000 - Read Write - Average Latency
  1000 - 100 - Read Write - Average Latency
  1000 - 1000 - Read Only - Average Latency
  1000 - 250 - Read Write - Average Latency
  1000 - 500 - Read Write - Average Latency
  1000 - 800 - Read Write - Average Latency
  1000 - 1000 - Read Write - Average Latency

a

Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=x86_64-redhat-linux --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-host-bind-now --enable-host-pie --enable-initfini-array --enable-languages=c,c++,fortran,lto --enable-link-serialization=1 --enable-multilib --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-arch_64=x86-64-v2 --with-build-config=bootstrap-lto --with-gcc-major-version-only --with-linker-hash-style=gnu --with-tune=generic --without-cuda-driver --without-isl
Processor Notes: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xa10113e
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional IBRS_FW STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 15 September 2023 17:49 by user .

b

Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=x86_64-redhat-linux --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-host-bind-now --enable-host-pie --enable-initfini-array --enable-languages=c,c++,fortran,lto --enable-link-serialization=1 --enable-multilib --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-arch_64=x86-64-v2 --with-build-config=bootstrap-lto --with-gcc-major-version-only --with-linker-hash-style=gnu --with-tune=generic --without-cuda-driver --without-isl
Processor Notes: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xa10113e
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional IBRS_FW STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 16 September 2023 00:53 by user .

c

Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=x86_64-redhat-linux --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-host-bind-now --enable-host-pie --enable-initfini-array --enable-languages=c,c++,fortran,lto --enable-link-serialization=1 --enable-multilib --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-arch_64=x86-64-v2 --with-build-config=bootstrap-lto --with-gcc-major-version-only --with-linker-hash-style=gnu --with-tune=generic --without-cuda-driver --without-isl
Processor Notes: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xa10113e
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional IBRS_FW STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 16 September 2023 02:30 by user .

d

Processor: 2 x AMD EPYC 9334 32-Core @ 2.70GHz (64 Cores / 128 Threads), Motherboard: Supermicro H13DSH (1.5 BIOS), Memory: 24 x 32 GB DDR5-4800MT/s Samsung M321R4GA3BB6-CQKET, Disk: 2 x 1920GB SAMSUNG MZQL21T9HCJR-00A07, Graphics: astdrmfb, Monitor: DELL E207WFP

OS: AlmaLinux 9.2, Kernel: 5.14.0-284.25.1.el9_2.x86_64 (x86_64), Compiler: GCC 11.3.1 20221121, File-System: ext4, Screen Resolution: 1680x1050

Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=x86_64-redhat-linux --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-host-bind-now --enable-host-pie --enable-initfini-array --enable-languages=c,c++,fortran,lto --enable-link-serialization=1 --enable-multilib --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-arch_64=x86-64-v2 --with-build-config=bootstrap-lto --with-gcc-major-version-only --with-linker-hash-style=gnu --with-tune=generic --without-cuda-driver --without-isl
Processor Notes: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xa10113e
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional IBRS_FW STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 16 September 2023 03:54 by user .