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.

HTML result view exported from: https://openbenchmarking.org/result/2309164-NE-PG306658496&gru&sor.

pgProcessorMotherboardMemoryDiskGraphicsMonitorOSKernelCompilerFile-SystemScreen Resolutionabcd2 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 20221121ext41680x1050OpenBenchmarking.orgKernel Details- Transparent Huge Pages: alwaysCompiler Details- --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 Details- Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xa10113e Security Details- 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

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

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latencyabcd0.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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latencyabcd0.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

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latencybcda0.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

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latencycdab0.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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

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

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average Latencybcda714212835SE +/- 0.62, N = 1223.7525.4126.9330.191. (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 Latencybdca918273645SE +/- 0.57, N = 1230.5231.4331.5738.571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Phoronix Test Suite v10.8.4