pgbench threadripper

AMD Ryzen Threadripper 3990X 64-Core testing with a Gigabyte TRX40 AORUS PRO WIFI (F4p BIOS) and AMD Radeon RX 5700 8GB on Ubuntu 22.10 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 2301066-NE-PGBENCHTH55
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
January 05 2023
  4 Hours, 3 Minutes
b
January 05 2023
  22 Hours, 16 Minutes
c
January 06 2023
  4 Hours, 11 Minutes
Invert Behavior (Only Show Selected Data)
  10 Hours, 10 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):


pgbench threadripperOpenBenchmarking.orgPhoronix Test SuiteAMD Ryzen Threadripper 3990X 64-Core @ 2.90GHz (64 Cores / 128 Threads)Gigabyte TRX40 AORUS PRO WIFI (F4p BIOS)AMD Starship/Matisse128GBSamsung SSD 970 EVO Plus 500GBAMD Radeon RX 5700 8GB (1750/875MHz)AMD Navi 10 HDMI AudioDELL P2415QIntel I211 + Intel Wi-Fi 6 AX200Ubuntu 22.106.1.0-rc8-phx-mglru (x86_64)GNOME Shell 43.0X Server 1.21.1.4 + Wayland4.6 Mesa 22.2.1 (LLVM 15.0.2 DRM 3.49)1.3.224GCC 12.2.0 + LLVM 15.0.2ext43840x2160ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerOpenGLVulkanCompilerFile-SystemScreen ResolutionPgbench Threadripper 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-U8K4Qv/gcc-12-12.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-12-U8K4Qv/gcc-12-12.2.0/debian/tmp-gcn/usr --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-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: acpi-cpufreq schedutil (Boost: Enabled) - CPU Microcode: 0x8301055- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Mitigation of untrained return thunk; SMT enabled with STIBP protection + 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 STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

abcResult OverviewPhoronix Test Suite100%110%121%131%141%PostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQL100 - 50 - Read Write100 - 50 - Read Write - Average Latency1000 - 50 - Read Write - Average Latency1000 - 50 - Read Write1000 - 100 - Read Write - Average Latency1000 - 100 - Read Write100 - 100 - Read Write100 - 100 - Read Write - Average Latency1000 - 1000 - Read Write1000 - 1000 - Read Write - Average Latency100 - 1000 - Read Write100 - 1000 - Read Write - Average Latency100 - 250 - Read Write - Average Latency100 - 250 - Read Write1 - 1000 - Read Write1 - 1000 - Read Write - Average Latency1000 - 250 - Read Write - Average Latency1000 - 250 - Read Write1000 - 800 - Read Write - Average Latency1000 - 800 - Read Write1 - 500 - Read Write1 - 500 - Read Write - Average Latency1000 - 500 - Read Write - Average Latency1000 - 500 - Read Write1 - 800 - Read Write1 - 800 - Read Write - Average Latency100 - 800 - Read Write - Average Latency100 - 800 - Read Write100 - 500 - Read Write100 - 500 - Read Write - Average Latency1000 - 500 - Read Only - Average Latency1000 - 500 - Read Only1 - 50 - Read Only1 - 1 - Read Only - Average Latency1 - 250 - Read Only - Average Latency100 - 1 - Read Only - Average Latency1 - 50 - Read Only - Average Latency1 - 250 - Read Only1000 - 1 - Read Only1 - 1 - Read Only1000 - 50 - Read Only - Average Latency100 - 500 - Read Only - Average Latency100 - 1 - Read Only1 - 500 - Read Only - Average Latency100 - 500 - Read Only1 - 500 - Read Only1000 - 250 - Read Only1000 - 250 - Read Only - Average Latency1000 - 1 - Read Write1000 - 1 - Read Write - Average Latency1000 - 50 - Read Only1 - 100 - Read Only - Average Latency100 - 100 - Read Only - Average Latency1 - 100 - Read Write1 - 250 - Read Write - Average Latency100 - 250 - Read Only - Average Latency1 - 250 - Read Write1 - 100 - Read Write - Average Latency1000 - 800 - Read Only100 - 250 - Read Only1000 - 800 - Read Only - Average Latency1000 - 100 - Read Only1 - 50 - Read Write - Average Latency1 - 50 - Read Write1000 - 100 - Read Only - Average Latency1000 - 1000 - Read Only1000 - 1000 - Read Only - Average Latency1 - 100 - Read Only100 - 1 - Read Write100 - 1 - Read Write - Average Latency100 - 800 - Read Only100 - 800 - Read Only - Average Latency100 - 100 - Read Only1 - 1 - Read Write - Average Latency1 - 800 - Read Only - Average Latency1 - 800 - Read Only1 - 1 - Read Write1 - 1000 - Read Only100 - 50 - Read Only1 - 1000 - Read Only - Average Latency100 - 1000 - Read Only100 - 1000 - Read Only - Average Latency1000 - 1 - Read Only - Average Latency100 - 50 - Read Only - Average Latency

pgbench threadripperpgbench: 1000 - 800 - Read Write - Average Latencypgbench: 1000 - 800 - Read Writepgbench: 1000 - 1000 - Read Write - Average Latencypgbench: 1000 - 1000 - Read Writepgbench: 1000 - 1 - Read Only - Average Latencypgbench: 1000 - 1 - Read Onlypgbench: 1000 - 1000 - Read Only - Average Latencypgbench: 1000 - 1000 - Read Onlypgbench: 1000 - 500 - Read Only - Average Latencypgbench: 1000 - 500 - Read Onlypgbench: 1000 - 250 - Read Only - Average Latencypgbench: 1000 - 250 - Read Onlypgbench: 1000 - 500 - Read Write - Average Latencypgbench: 1000 - 500 - Read Writepgbench: 1000 - 800 - Read Only - Average Latencypgbench: 1000 - 800 - Read Onlypgbench: 100 - 1000 - Read Write - Average Latencypgbench: 100 - 1000 - Read Writepgbench: 1 - 1000 - Read Write - Average Latencypgbench: 1 - 1000 - Read Writepgbench: 100 - 1 - Read Only - Average Latencypgbench: 100 - 1 - Read Onlypgbench: 1 - 800 - Read Write - Average Latencypgbench: 1 - 800 - Read Writepgbench: 1 - 500 - Read Write - Average Latencypgbench: 1 - 500 - Read Writepgbench: 1000 - 250 - Read Write - Average Latencypgbench: 1000 - 250 - Read Writepgbench: 1000 - 50 - Read Write - Average Latencypgbench: 1000 - 50 - Read Writepgbench: 100 - 800 - Read Write - Average Latencypgbench: 100 - 800 - Read Writepgbench: 1000 - 1 - Read Write - Average Latencypgbench: 1000 - 1 - Read Writepgbench: 1000 - 100 - Read Write - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 100 - Read Only - Average Latencypgbench: 1000 - 100 - Read Onlypgbench: 1000 - 50 - Read Only - Average Latencypgbench: 1000 - 50 - Read Onlypgbench: 100 - 500 - Read Write - Average Latencypgbench: 100 - 500 - Read Writepgbench: 100 - 1000 - Read Only - Average Latencypgbench: 100 - 1000 - Read Onlypgbench: 100 - 250 - Read Write - Average Latencypgbench: 100 - 250 - Read Writepgbench: 100 - 800 - Read Only - Average Latencypgbench: 100 - 800 - Read Onlypgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 1 - Read Writepgbench: 100 - 50 - Read Only - Average Latencypgbench: 100 - 50 - Read Onlypgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 100 - Read Writepgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 250 - Read Onlypgbench: 100 - 500 - Read Only - Average Latencypgbench: 100 - 500 - Read Onlypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 100 - Read Onlypgbench: 1 - 250 - Read Write - Average Latencypgbench: 1 - 250 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 1 - 50 - Read Writepgbench: 1 - 500 - Read Only - Average Latencypgbench: 1 - 500 - Read Onlypgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Onlypgbench: 1 - 1000 - Read Only - Average Latencypgbench: 1 - 1000 - Read Onlypgbench: 1 - 1 - Read Write - Average Latencypgbench: 1 - 1 - Read Writepgbench: 1 - 800 - Read Only - Average Latencypgbench: 1 - 800 - Read Onlypgbench: 1 - 100 - Read Only - Average Latencypgbench: 1 - 100 - Read Onlypgbench: 1 - 50 - Read Only - Average Latencypgbench: 1 - 50 - Read Onlypgbench: 1 - 250 - Read Only - Average Latencypgbench: 1 - 250 - Read Onlyabc106.847488131.9375800.029349981.1858441380.5069871800.227110172876.61165260.967827644111.22589912867.3293490.028358712244.4743561035.99948335.21710010.3834816106.9174832.82335414.46869120.06515369650.036138700471.43270000.456219065630.41382200.36721810558.44359222.2944360.031162396813.17475910.11421911200.23121670820.0551811132396.402631146.82568171.3177010.20524355080.026385340.41524076751.4326980.33523865490.05318875390.02817849560.1022440508118.1366793107.27293530.029348251.1868439690.5329406040.228109525181.59461490.983813927133.76974862736.5273680.027367762061.537392917.41754641.013609713.6483664109.13873342.87834718.90752900.06415591990.037136056667.66373930.456219129736.69068150.367217841311.12744942.3204310.031161095816.77059630.11421955790.22522173740.0561791916396.940630147.11768072.4586900.21023802980.025396730.41324239981.4197040.33723747790.05418704970.02817546640.1062363709121.1256605139.22271830.029339641.2028316900.5049924880.223112000486.13558050.969825397142.74570052377.0924210.027364392137.697374999.63350041.243606214.5453438114.80269692.86634919.39751560.06415616820.036137321170.27771150.455219874936.71268100.363220285111.93841882.2954360.031162319417.28957840.11222274770.2321772990.0551807598403.506620149.41866971.9876950.2123823440.025394410.41224273001.4237030.33423955350.05318959730.02718275110.1042409891OpenBenchmarking.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.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average Latencycba306090120150SE +/- 2.28, N = 9121.13118.14106.841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

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

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

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

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latencycba0.27050.5410.81151.0821.3525SE +/- 0.012, N = 91.2021.1861.1851. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latencybac0.11970.23940.35910.47880.5985SE +/- 0.006, N = 90.5320.5060.5041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

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

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

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

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average Latencybca0.22120.44240.66360.88481.106SE +/- 0.009, N = 60.9830.9690.9671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

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

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

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

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

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

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

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

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

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

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latencycba918273645SE +/- 0.49, N = 341.2441.0135.211. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latencycba48121620SE +/- 0.08, N = 314.5513.6510.381. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read Writecba10002000300040005000SE +/- 22.15, N = 33438366448161. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latencybca0.64761.29521.94282.59043.238SE +/- 0.026, N = 32.8782.8662.8231. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

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

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

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

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

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read Onlybca300K600K900K1200K1500KSE +/- 5452.02, N = 31360566137321113870041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latencybac0.10260.20520.30780.41040.513SE +/- 0.005, N = 30.4560.4560.4551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latencycba816243240SE +/- 0.39, N = 336.7136.6930.411. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latencybac0.08260.16520.24780.33040.413SE +/- 0.001, N = 30.3670.3670.3631. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latencycba3691215SE +/- 0.054, N = 311.93811.1278.4431. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read Writecba13002600390052006500SE +/- 21.59, N = 34188449459221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latencybca0.5221.0441.5662.0882.61SE +/- 0.022, N = 32.3202.2952.2941. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read Onlybca300K600K900K1200K1500KSE +/- 10456.01, N = 31610958162319416239681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latencycba48121620SE +/- 0.08, N = 317.2916.7713.171. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latencybac0.02570.05140.07710.10280.1285SE +/- 0.001, N = 30.1140.1140.1121. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

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

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

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

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

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

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

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

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

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Writebca150300450600750SE +/- 3.03, N = 36906957011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

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

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Onlyacb8K16K24K32K40KSE +/- 393.90, N = 33853439441396731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latencyabc0.09340.18680.28020.37360.467SE +/- 0.005, N = 30.4150.4130.4121. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latencyacb0.32220.64440.96661.28881.611SE +/- 0.007, N = 31.4321.4231.4191. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Writeacb150300450600750SE +/- 3.42, N = 36987037041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latencybac0.07580.15160.22740.30320.379SE +/- 0.001, N = 30.3370.3350.3341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

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

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latencybac0.00630.01260.01890.02520.0315SE +/- 0.000, N = 30.0280.0280.0271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Onlybac400K800K1200K1600K2000KSE +/- 12447.92, N = 31754664178495618275111. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latencybca0.02390.04780.07170.09560.1195SE +/- 0.001, N = 30.1060.1040.1021. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

84 Results Shown

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