postgresql 16 ryzen

AMD Ryzen 9 7950X 16-Core testing with a ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS) and AMD Radeon 16GB on Ubuntu 23.04 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 2309153-PTS-POSTGRES77
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

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
Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
a
September 14
  6 Hours, 17 Minutes
b
September 14
  5 Hours, 46 Minutes
c
September 15
  1 Hour, 29 Minutes
d
September 15
  1 Hour, 29 Minutes
e
September 15
  1 Hour, 30 Minutes
Invert Hiding All Results Option
  3 Hours, 18 Minutes

Only show results where is faster than
Only show results matching title/arguments (delimit multiple options with a comma):


postgresql 16 ryzenOpenBenchmarking.orgPhoronix Test SuiteAMD Ryzen 9 7950X 16-Core @ 5.88GHz (16 Cores / 32 Threads)ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS)AMD Device 14d832GBWestern Digital WD_BLACK SN850X 1000GB + 4001GB Western Digital WD_BLACK SN850X 4000GBAMD Radeon 16GB (2124/1218MHz)AMD Device ab30ASUS MG28UIntel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411Ubuntu 23.046.5.0-060500daily20230909-generic (x86_64)GNOME Shell 44.3X Server 1.21.1.7 + Wayland4.6 Mesa 23.3~git2308310600.c8687a~oibaf~l (git-c8687a4 2023-08-31 lunar-oibaf-ppa) (LLVM 15.0.7 DRM 3.54)GCC 12.3.0ext43840x2160ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerOpenGLCompilerFile-SystemScreen ResolutionPostgresql 16 Ryzen BenchmarksSystem Logs- Transparent Huge Pages: madvise- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-cet --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-defaulted --enable-offload-targets=nvptx-none=/build/gcc-12-DAPbBt/gcc-12-12.3.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-12-DAPbBt/gcc-12-12.3.0/debian/tmp-gcn/usr --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v - Scaling Governor: amd-pstate-epp powersave (EPP: performance) - CPU Microcode: 0xa601203- gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_rstack_overflow: Mitigation of safe RET no microcode + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced / Automatic IBRS IBPB: conditional STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

abcdeResult OverviewPhoronix Test Suite100%104%109%113%117%PostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQL1 - 800 - Read Write - Average Latency1 - 800 - Read Write1 - 500 - Read Write - Average Latency1 - 500 - Read Write1 - 800 - Read Only - Average Latency1 - 800 - Read Only100 - 50 - Read Write - Average Latency100 - 50 - Read Write100 - 250 - Read Write - Average Latency1 - 50 - Read Only - Average Latency100 - 250 - Read Write100 - 100 - Read Write100 - 800 - Read Write - Average Latency100 - 800 - Read Write100 - 100 - Read Write - Average Latency100 - 800 - Read Only - Average Latency100 - 500 - Read Only - Average Latency100 - 800 - Read Only100 - 500 - Read Only100 - 100 - Read Only1 - 50 - Read Only100 - 100 - Read Only - Average Latency1 - 50 - Read Write - Average Latency1 - 50 - Read Write1 - 500 - Read Only - Average Latency1 - 500 - Read Only100 - 250 - Read Only - Average Latency100 - 250 - Read Only1 - 250 - Read Write - Average Latency1 - 250 - Read Write1 - 100 - Read Write1 - 100 - Read Write - Average Latency100 - 50 - Read Only100 - 500 - Read Write100 - 500 - Read Write - Average Latency1 - 250 - Read Only1 - 250 - Read Only - Average Latency1 - 100 - Read Only1 - 100 - Read Only - Average Latency100 - 50 - Read Only - Average Latency

postgresql 16 ryzenpgbench: 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: 1 - 800 - Read Onlypgbench: 1 - 800 - 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: 1 - 800 - Read Writepgbench: 1 - 800 - Read Write - Average Latencypgbench: 100 - 50 - Read Onlypgbench: 100 - 50 - 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: 100 - 800 - Read Onlypgbench: 100 - 800 - 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: 100 - 800 - Read Writepgbench: 100 - 800 - Read Write - Average Latencyabcde14865290.03415420200.06515768000.159395012.65815668730.31913762500.581366427.296283188.8241972255.7471153699.69414197620.03514339950.07014460140.173544360.91914110560.35411892880.673642981.555638483.916556428.9864890716.35815014370.03315426550.06515758940.159397712.57215661670.31913498910.593366627.276283088.3392050244.0921142703.41714218530.03514381100.06914536350.172554780.90114007150.35712155570.658648731.542630523.967560948.9144812616.62414963240.03315419900.06515709380.159399712.50815593470.32113704520.584368227.156284187.9912167230.7041233648.71314322330.03514273690.0714386370.174561980.8913818030.36212035570.665659701.516649253.851556618.9834937216.20415098790.03315439120.06515803240.158399912.50515702150.31813812880.579369927.038281388.881854269.7511102725.88514245000.03514538080.06914498180.172562410.88914022390.35712155030.658658921.518649503.849558178.9584925616.24215036320.03315473790.06515823860.158400612.4815513670.32214081650.568368327.152284387.9331905262.4211052760.40314192520.03514373340.0714544780.172562980.88814118720.35412079030.662656701.523643403.886560178.9264919216.263OpenBenchmarking.org

PostgreSQL

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 50 - Mode: Read Onlyabcde300K600K900K1200K1500KSE +/- 14877.89, N = 3SE +/- 1586.76, N = 3148652915014371496324150987915036321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 50 - Mode: Read Onlyabcde300K600K900K1200K1500KMin: 1458938.45 / Avg: 1486529.4 / Max: 1509974.21Min: 1499573.57 / Avg: 1501437.39 / Max: 1504593.721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latencyabcde0.00770.01540.02310.03080.0385SE +/- 0.000, N = 3SE +/- 0.000, N = 30.0340.0330.0330.0330.0331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latencyabcde12345Min: 0.03 / Avg: 0.03 / Max: 0.03Min: 0.03 / Avg: 0.03 / Max: 0.031. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Onlyabcde300K600K900K1200K1500KSE +/- 5450.25, N = 3SE +/- 1633.39, N = 3154202015426551541990154391215473791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Onlyabcde300K600K900K1200K1500KMin: 1531176.85 / Avg: 1542019.67 / Max: 1548410.94Min: 1539889.94 / Avg: 1542654.7 / Max: 1545544.061. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latencyabcde0.01460.02920.04380.05840.073SE +/- 0.000, N = 3SE +/- 0.000, N = 30.0650.0650.0650.0650.0651. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latencyabcde12345Min: 0.07 / Avg: 0.07 / Max: 0.07Min: 0.07 / Avg: 0.07 / Max: 0.071. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Onlyabcde300K600K900K1200K1500KSE +/- 2098.20, N = 3SE +/- 3713.99, N = 3157680015758941570938158032415823861. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Onlyabcde300K600K900K1200K1500KMin: 1574688.41 / Avg: 1576800.1 / Max: 1580996.47Min: 1571075.18 / Avg: 1575894.36 / Max: 1583199.131. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latencyabcde0.03580.07160.10740.14320.179SE +/- 0.000, N = 3SE +/- 0.000, N = 30.1590.1590.1590.1580.1581. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latencyabcde12345Min: 0.16 / Avg: 0.16 / Max: 0.16Min: 0.16 / Avg: 0.16 / Max: 0.161. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 50 - Mode: Read Writeabcde9001800270036004500SE +/- 24.84, N = 3SE +/- 1.27, N = 3395039773997399940061. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 50 - Mode: Read Writeabcde7001400210028003500Min: 3900.79 / Avg: 3950.43 / Max: 3976.88Min: 3974.9 / Avg: 3977.02 / Max: 3979.281. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latencyabcde3691215SE +/- 0.08, N = 3SE +/- 0.00, N = 312.6612.5712.5112.5112.481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latencyabcde48121620Min: 12.57 / Avg: 12.66 / Max: 12.82Min: 12.57 / Avg: 12.57 / Max: 12.581. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Onlyabcde300K600K900K1200K1500KSE +/- 2910.69, N = 3SE +/- 4064.56, N = 3156687315661671559347157021515513671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Onlyabcde300K600K900K1200K1500KMin: 1561068.5 / Avg: 1566872.69 / Max: 1570161.86Min: 1558250.92 / Avg: 1566167.28 / Max: 1571725.571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latencyabcde0.07250.1450.21750.290.3625SE +/- 0.001, N = 3SE +/- 0.001, N = 30.3190.3190.3210.3180.3221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latencyabcde12345Min: 0.32 / Avg: 0.32 / Max: 0.32Min: 0.32 / Avg: 0.32 / Max: 0.321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Onlyabcde300K600K900K1200K1500KSE +/- 2756.67, N = 3SE +/- 15531.90, N = 3137625013498911370452138128814081651. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Onlyabcde200K400K600K800K1000KMin: 1373123.4 / Avg: 1376250.31 / Max: 1381746.26Min: 1330765.23 / Avg: 1349891.04 / Max: 1380652.351. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latencyabcde0.13340.26680.40020.53360.667SE +/- 0.001, N = 3SE +/- 0.007, N = 30.5810.5930.5840.5790.5681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latencyabcde246810Min: 0.58 / Avg: 0.58 / Max: 0.58Min: 0.58 / Avg: 0.59 / Max: 0.61. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Writeabcde8001600240032004000SE +/- 13.30, N = 3SE +/- 4.63, N = 3366436663682369936831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Writeabcde6001200180024003000Min: 3637.39 / Avg: 3663.62 / Max: 3680.56Min: 3657.54 / Avg: 3666.21 / Max: 3673.381. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latencyabcde612182430SE +/- 0.10, N = 3SE +/- 0.03, N = 327.3027.2827.1627.0427.151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latencyabcde612182430Min: 27.17 / Avg: 27.3 / Max: 27.49Min: 27.22 / Avg: 27.28 / Max: 27.341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Writeabcde6001200180024003000SE +/- 59.81, N = 12SE +/- 22.68, N = 3283128302841281328431. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Writeabcde5001000150020002500Min: 2243.97 / Avg: 2831.07 / Max: 2949.7Min: 2793.3 / Avg: 2830.36 / Max: 2871.541. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latencyabcde20406080100SE +/- 2.24, N = 12SE +/- 0.71, N = 388.8288.3487.9988.8887.931. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latencyabcde20406080100Min: 84.75 / Avg: 88.82 / Max: 111.41Min: 87.06 / Avg: 88.34 / Max: 89.51. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Writeabcde5001000150020002500SE +/- 52.08, N = 11SE +/- 17.35, N = 12197220502167185419051. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Writeabcde400800120016002000Min: 1486.32 / Avg: 1972.13 / Max: 2087.84Min: 1964.9 / Avg: 2050.02 / Max: 2144.391. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latencyabcde60120180240300SE +/- 8.41, N = 11SE +/- 2.06, N = 12255.75244.09230.70269.75262.421. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latencyabcde50100150200250Min: 239.48 / Avg: 255.75 / Max: 336.4Min: 233.17 / Avg: 244.09 / Max: 254.471. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Writeabcde30060090012001500SE +/- 33.33, N = 11SE +/- 22.47, N = 12115311421233110210521. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Writeabcde2004006008001000Min: 979.11 / Avg: 1152.73 / Max: 1380.89Min: 1026.64 / Avg: 1142.1 / Max: 1278.391. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latencyabcde160320480640800SE +/- 19.81, N = 11SE +/- 13.68, N = 12699.69703.42648.71725.89760.401. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latencyabcde130260390520650Min: 579.34 / Avg: 699.69 / Max: 817.07Min: 625.79 / Avg: 703.42 / Max: 779.241. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Onlyabcde300K600K900K1200K1500KSE +/- 8737.73, N = 3SE +/- 3271.06, N = 3141976214218531432233142450014192521. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Onlyabcde200K400K600K800K1000KMin: 1403087.22 / Avg: 1419762.09 / Max: 1432627.81Min: 1417870.2 / Avg: 1421852.69 / Max: 1428338.861. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latencyabcde0.00790.01580.02370.03160.0395SE +/- 0.000, N = 3SE +/- 0.000, N = 30.0350.0350.0350.0350.0351. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latencyabcde12345Min: 0.04 / Avg: 0.04 / Max: 0.04Min: 0.04 / Avg: 0.04 / Max: 0.041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Onlyabcde300K600K900K1200K1500KSE +/- 5069.29, N = 3SE +/- 7316.19, N = 3143399514381101427369145380814373341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Onlyabcde300K600K900K1200K1500KMin: 1424476.92 / Avg: 1433994.9 / Max: 1441778.65Min: 1423477.33 / Avg: 1438109.66 / Max: 1445454.621. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latencyabcde0.01580.03160.04740.06320.079SE +/- 0.000, N = 3SE +/- 0.000, N = 30.0700.0690.0700.0690.0701. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latencyabcde12345Min: 0.07 / Avg: 0.07 / Max: 0.07Min: 0.07 / Avg: 0.07 / Max: 0.071. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Onlyabcde300K600K900K1200K1500KSE +/- 7044.20, N = 3SE +/- 6322.18, N = 3144601414536351438637144981814544781. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Onlyabcde300K600K900K1200K1500KMin: 1435142.49 / Avg: 1446013.62 / Max: 1459209.73Min: 1440999.7 / Avg: 1453635.42 / Max: 1460358.151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latencyabcde0.03920.07840.11760.15680.196SE +/- 0.001, N = 3SE +/- 0.001, N = 30.1730.1720.1740.1720.1721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latencyabcde12345Min: 0.17 / Avg: 0.17 / Max: 0.17Min: 0.17 / Avg: 0.17 / Max: 0.171. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Writeabcde12K24K36K48K60KSE +/- 660.01, N = 3SE +/- 103.62, N = 354436554785619856241562981. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Writeabcde10K20K30K40K50KMin: 53173.11 / Avg: 54436.24 / Max: 55399.8Min: 55271.29 / Avg: 55477.88 / Max: 55595.231. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latencyabcde0.20680.41360.62040.82721.034SE +/- 0.011, N = 3SE +/- 0.002, N = 30.9190.9010.8900.8890.8881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latencyabcde246810Min: 0.9 / Avg: 0.92 / Max: 0.94Min: 0.9 / Avg: 0.9 / Max: 0.911. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Onlyabcde300K600K900K1200K1500KSE +/- 6676.89, N = 3SE +/- 4589.53, N = 3141105614007151381803140223914118721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Onlyabcde200K400K600K800K1000KMin: 1402410.96 / Avg: 1411056.39 / Max: 1424193Min: 1392962.76 / Avg: 1400715.12 / Max: 1408847.711. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latencyabcde0.08150.1630.24450.3260.4075SE +/- 0.002, N = 3SE +/- 0.001, N = 30.3540.3570.3620.3570.3541. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latencyabcde12345Min: 0.35 / Avg: 0.35 / Max: 0.36Min: 0.36 / Avg: 0.36 / Max: 0.361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Onlyabcde300K600K900K1200K1500KSE +/- 7529.89, N = 3SE +/- 4251.82, N = 3118928812155571203557121550312079031. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Onlyabcde200K400K600K800K1000KMin: 1174436.67 / Avg: 1189288.48 / Max: 1198874.42Min: 1210501.14 / Avg: 1215556.77 / Max: 1224006.111. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latencyabcde0.15140.30280.45420.60560.757SE +/- 0.004, N = 3SE +/- 0.002, N = 30.6730.6580.6650.6580.6621. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latencyabcde246810Min: 0.67 / Avg: 0.67 / Max: 0.68Min: 0.65 / Avg: 0.66 / Max: 0.661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Writeabcde14K28K42K56K70KSE +/- 117.45, N = 3SE +/- 131.20, N = 364298648736597065892656701. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Writeabcde11K22K33K44K55KMin: 64130.14 / Avg: 64298.39 / Max: 64524.48Min: 64612.44 / Avg: 64872.59 / Max: 65032.311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latencyabcde0.34990.69981.04971.39961.7495SE +/- 0.003, N = 3SE +/- 0.003, N = 31.5551.5421.5161.5181.5231. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latencyabcde246810Min: 1.55 / Avg: 1.56 / Max: 1.56Min: 1.54 / Avg: 1.54 / Max: 1.551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Writeabcde14K28K42K56K70KSE +/- 122.05, N = 3SE +/- 896.30, N = 363848630526492564950643401. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Writeabcde11K22K33K44K55KMin: 63699.64 / Avg: 63847.81 / Max: 64089.89Min: 61280.65 / Avg: 63051.71 / Max: 64177.181. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latencyabcde0.89261.78522.67783.57044.463SE +/- 0.007, N = 3SE +/- 0.057, N = 33.9163.9673.8513.8493.8861. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latencyabcde246810Min: 3.9 / Avg: 3.92 / Max: 3.93Min: 3.9 / Avg: 3.97 / Max: 4.081. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Writeabcde12K24K36K48K60KSE +/- 60.51, N = 3SE +/- 146.88, N = 355642560945566155817560171. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Writeabcde10K20K30K40K50KMin: 55527.17 / Avg: 55642.16 / Max: 55732.36Min: 55879.18 / Avg: 56094.12 / Max: 56375.011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latencyabcde3691215SE +/- 0.010, N = 3SE +/- 0.023, N = 38.9868.9148.9838.9588.9261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latencyabcde3691215Min: 8.97 / Avg: 8.99 / Max: 9.01Min: 8.87 / Avg: 8.91 / Max: 8.951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Writeabcde11K22K33K44K55KSE +/- 255.27, N = 3SE +/- 315.44, N = 348907481264937249256491921. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Writeabcde9K18K27K36K45KMin: 48604.96 / Avg: 48907.27 / Max: 49414.72Min: 47723.52 / Avg: 48126.1 / Max: 48748.051. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latencyabcde48121620SE +/- 0.08, N = 3SE +/- 0.11, N = 316.3616.6216.2016.2416.261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latencyabcde48121620Min: 16.19 / Avg: 16.36 / Max: 16.46Min: 16.41 / Avg: 16.62 / Max: 16.761. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lm -licui18n -licuuc -licudata