13900k db rad

Intel Core i9-13900K testing with a ASUS PRIME Z790-P WIFI (0812 BIOS) and AMD Radeon RX 7700S/7600S/7600M XT 8GB on Ubuntu 22.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 2309174-NE-13900KDBR03
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
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
a
September 16 2023
  1 Hour, 54 Minutes
b
September 16 2023
  1 Hour, 55 Minutes
c
September 16 2023
  9 Hours, 2 Minutes
d
September 17 2023
  1 Hour, 54 Minutes
e
September 17 2023
  1 Hour, 55 Minutes
Invert Hiding All Results Option
  3 Hours, 20 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):


13900k db radOpenBenchmarking.orgPhoronix Test SuiteIntel Core i9-13900K @ 5.50GHz (24 Cores / 32 Threads)ASUS PRIME Z790-P WIFI (0812 BIOS)Intel Device 7a2732GB1000GB Western Digital WDS100T1X0E-00AFY0AMD Radeon RX 7700S/7600S/7600M XT 8GB (1940/1124MHz)Realtek ALC897ASUS VP28UUbuntu 22.046.5.3-060503-generic (x86_64)GNOME Shell 42.9X Server 1.21.1.4 + Wayland4.6 Mesa 23.3~git2308070600.777734~oibaf~j (git-7777349 2023-08-07 jammy-oibaf-ppa) (LLVM 15.0.7 DRM 3.54)OpenCL 1.1 Mesa 23.3~git2308020600.4de7e0~oibaf~j (git-4de7e00 2023-08-02 jammy-oibaf-ppa) + OpenCL 3.01.3.258GCC 11.4.0 + Clang 16.0.6 + LLVM 16.0.6ext43840x2160ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorOSKernelDesktopDisplay ServerOpenGLOpenCLVulkanCompilerFile-SystemScreen Resolution13900k Db Rad BenchmarksSystem Logs- Transparent Huge Pages: madvise- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-cet --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-serialization=2 --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-11-XeT9lY/gcc-11-11.4.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-XeT9lY/gcc-11-11.4.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-build-config=bootstrap-lto-lean --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: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0x119 - Thermald 2.4.9- 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: 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 Enhanced / Automatic IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Not affected + tsx_async_abort: Not affected

abcdeResult OverviewPhoronix Test Suite100%117%134%150%167%PostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLOpenRadiossPostgreSQLPostgreSQLPostgreSQLPostgreSQLOpenRadiossOpenRadiossPostgreSQLPostgreSQLPostgreSQLOpenRadiossPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLOpenRadiossPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLOpenRadiossPostgreSQL1 - 800 - Read Write1 - 800 - Read Write - Average Latency1 - 250 - Read Write - Average Latency1 - 250 - Read Write1 - 1000 - Read Write1 - 1000 - Read Write - Average Latency1 - 500 - Read Write - Average Latency1 - 500 - Read Write100 - 100 - Read Write - Average Latency100 - 100 - Read Write100 - 250 - Read Write - Average Latency100 - 250 - Read Write100 - 500 - Read Write - Average Latency100 - 500 - Read WriteC.P.D.T100 - 800 - Read Write - Average Latency100 - 800 - Read Write100 - 500 - Read Only100 - 500 - Read Only - Average LatencyBumper BeamB.S.o.W1 - 250 - Read Only1 - 250 - Read Only - Average Latency1 - 500 - Read Only - Average LatencyR.O.R.S.I1 - 500 - Read Only1 - 1000 - Read Only1 - 1000 - Read Only - Average Latency1 - 100 - Read Only1 - 100 - Read Only - Average Latency100 - 250 - Read Only1 - 100 - Read Write - Average Latency1 - 100 - Read Write100 - 800 - Read Only100 - 800 - Read Only - Average Latency100 - 250 - Read Only - Average Latency100 - 1000 - Read Only100 - 1000 - Read Only - Average LatencyI.a.F.S.I.D.C1 - 800 - Read Only - Average Latency1 - 800 - Read Only100 - 100 - Read Only100 - 1000 - Read Write - Average Latency100 - 1000 - Read WriteChrysler Neon 1M100 - 100 - Read Only - Average Latency

13900k db radpgbench: 1 - 250 - Read Write - Average Latencypgbench: 1 - 250 - Read Writepgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 100 - Read Writepgbench: 100 - 250 - Read Write - Average Latencypgbench: 100 - 250 - Read Writepgbench: 100 - 500 - Read Write - Average Latencypgbench: 100 - 500 - Read Writeopenradioss: Cell Phone Drop Testpgbench: 100 - 800 - Read Write - Average Latencypgbench: 100 - 800 - Read Writepgbench: 100 - 500 - Read Onlypgbench: 100 - 500 - Read Only - Average Latencyopenradioss: Bumper Beamopenradioss: Bird Strike on Windshieldpgbench: 1 - 250 - Read Onlypgbench: 1 - 250 - Read Only - Average Latencypgbench: 1 - 500 - Read Only - Average Latencyopenradioss: Rubber O-Ring Seal Installationpgbench: 1 - 500 - Read Onlypgbench: 1 - 1000 - Read Onlypgbench: 1 - 1000 - Read Only - Average Latencypgbench: 1 - 100 - Read Onlypgbench: 1 - 100 - Read Only - Average Latencypgbench: 100 - 250 - Read Onlypgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 100 - Read Writepgbench: 100 - 800 - Read Onlypgbench: 100 - 800 - Read Only - Average Latencypgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 1000 - Read Onlypgbench: 100 - 1000 - Read Only - Average Latencyopenradioss: INIVOL and Fluid Structure Interaction Drop Containerpgbench: 1 - 800 - Read Only - Average Latencypgbench: 1 - 800 - Read Onlypgbench: 100 - 100 - Read Onlypgbench: 100 - 1000 - Read Write - Average Latencypgbench: 100 - 1000 - Read Writeopenradioss: Chrysler Neon 1Mpgbench: 100 - 100 - Read Only - Average Latencypgbench: 1 - 1000 - Read Write - Average Latencypgbench: 1 - 1000 - Read Writepgbench: 1 - 800 - Read Write - Average Latencypgbench: 1 - 800 - Read Writepgbench: 1 - 500 - Read Write - Average Latencypgbench: 1 - 500 - Read Writeabcde148.51316831.661602153.598694847.8796345764.3114.6395464917256880.29116.71172.5118648060.1340.27111.45184931918551800.53918890530.053175296458.153172016550380.4830.14316252910.615298.960.4351839635176368319.59251040712.280.0571282.5297801045.906765443.8451127172.08114531.634612183.568700727.7416459267.9614.3865560917069660.293117.86178.3518192060.1370.271113.93184331718513450.5418836630.053173329758.339171416736460.4780.14416343610.612299.280.441819321176650919.75250628713.950.0571548.475646764.0911047492.371015179.98013901.644608443.533707777.8906345466.6814.2475615516831340.297119.33177.4418615030.1340.269113.33185425018193150.55018667890.054172437157.491173916527130.4840.14516280940.615300.390.4361836284175430219.59851026716.980.0571589.9746661062.254771499.4241014188.9213231.607622293.267765157.2476899463.2513.6545859016451550.304115.35173.3918785880.1330.276112.1181435118194170.5518916190.053174354658.423171216484000.4850.14316471000.607297.310.4361833891176978619.54851156714.460.0571529.5076541275.227627428.9271166192.82212971.491670523.48718407.7686436763.4714.3385579616725950.299118.72178.418716800.1340.272112.35184118518177810.5518538920.054175383457.721173216613600.4820.14316468830.607300.980.4371829392175083119.63250936718.50.0571628.1456141106.802723495.5561009OpenBenchmarking.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 16Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latencyabcde4080120160200SE +/- 1.63, N = 12148.51172.08179.98188.92192.821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latencyabcde4080120160200Min: 169.69 / Avg: 179.98 / Max: 191.351. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Writeabcde400800120016002000SE +/- 12.58, N = 12168314531390132312971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Writeabcde30060090012001500Min: 1306.51 / Avg: 1390.3 / Max: 1473.311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latencyabcde0.37370.74741.12111.49481.8685SE +/- 0.013, N = 31.6611.6341.6441.6071.4911. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latencyabcde246810Min: 1.62 / Avg: 1.64 / Max: 1.661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Writeabcde14K28K42K56K70KSE +/- 475.74, N = 360215612186084462229670521. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Writeabcde12K24K36K48K60KMin: 60217.16 / Avg: 60844.38 / Max: 61777.611. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latencyabcde0.80961.61922.42883.23844.048SE +/- 0.034, N = 33.5983.5683.5333.2673.4801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latencyabcde246810Min: 3.47 / Avg: 3.53 / Max: 3.591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Writeabcde16K32K48K64K80KSE +/- 681.05, N = 369484700727077776515718401. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Writeabcde13K26K39K52K65KMin: 69667.04 / Avg: 70776.55 / Max: 72015.571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latencyabcde246810SE +/- 0.086, N = 127.8797.7417.8907.2477.7681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latencyabcde3691215Min: 7.71 / Avg: 7.89 / Max: 8.551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Writeabcde15K30K45K60K75KSE +/- 652.79, N = 1263457645926345468994643671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Writeabcde12K24K36K48K60KMin: 58506.62 / Avg: 63453.76 / Max: 64813.391. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenRadioss

OpenBenchmarking.orgSeconds, Fewer Is BetterOpenRadioss 2023.09.15Model: Cell Phone Drop Testabcde1530456075SE +/- 0.50, N = 1564.3167.9666.6863.2563.47
OpenBenchmarking.orgSeconds, Fewer Is BetterOpenRadioss 2023.09.15Model: Cell Phone Drop Testabcde1326395265Min: 63.92 / Avg: 66.68 / Max: 69.69

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 16Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latencyabcde48121620SE +/- 0.04, N = 314.6414.3914.2513.6514.341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latencyabcde48121620Min: 14.18 / Avg: 14.25 / Max: 14.311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Writeabcde13K26K39K52K65KSE +/- 155.88, N = 354649556095615558590557961. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Writeabcde10K20K30K40K50KMin: 55899.66 / Avg: 56154.54 / Max: 56437.451. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Onlyabcde400K800K1200K1600K2000KSE +/- 11467.76, N = 3172568817069661683134164515516725951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Onlyabcde300K600K900K1200K1500KMin: 1665083.42 / Avg: 1683133.69 / Max: 1704413.191. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latencyabcde0.06840.13680.20520.27360.342SE +/- 0.002, N = 30.2900.2930.2970.3040.2991. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latencyabcde12345Min: 0.29 / Avg: 0.3 / Max: 0.31. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenRadioss

OpenBenchmarking.orgSeconds, Fewer Is BetterOpenRadioss 2023.09.15Model: Bumper Beamabcde306090120150SE +/- 0.55, N = 3116.71117.86119.33115.35118.72
OpenBenchmarking.orgSeconds, Fewer Is BetterOpenRadioss 2023.09.15Model: Bumper Beamabcde20406080100Min: 118.42 / Avg: 119.33 / Max: 120.32

OpenBenchmarking.orgSeconds, Fewer Is BetterOpenRadioss 2023.09.15Model: Bird Strike on Windshieldabcde4080120160200SE +/- 1.47, N = 3172.51178.35177.44173.39178.40
OpenBenchmarking.orgSeconds, Fewer Is BetterOpenRadioss 2023.09.15Model: Bird Strike on Windshieldabcde306090120150Min: 174.53 / Avg: 177.44 / Max: 179.31

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Onlyabcde400K800K1200K1600K2000KSE +/- 10496.80, N = 3186480618192061861503187858818716801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Onlyabcde300K600K900K1200K1500KMin: 1841256.88 / Avg: 1861503.15 / Max: 1876434.071. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latencyabcde0.03080.06160.09240.12320.154SE +/- 0.001, N = 30.1340.1370.1340.1330.1341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latencyabcde12345Min: 0.13 / Avg: 0.13 / Max: 0.141. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latencyabcde0.06210.12420.18630.24840.3105SE +/- 0.001, N = 30.2700.2710.2690.2760.2721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latencyabcde12345Min: 0.27 / Avg: 0.27 / Max: 0.271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenRadioss

OpenBenchmarking.orgSeconds, Fewer Is BetterOpenRadioss 2023.09.15Model: Rubber O-Ring Seal Installationabcde306090120150SE +/- 0.41, N = 3111.45113.93113.33112.10112.35
OpenBenchmarking.orgSeconds, Fewer Is BetterOpenRadioss 2023.09.15Model: Rubber O-Ring Seal Installationabcde20406080100Min: 112.72 / Avg: 113.33 / Max: 114.1

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Onlyabcde400K800K1200K1600K2000KSE +/- 5262.56, N = 3184931918433171854250181435118411851. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Onlyabcde300K600K900K1200K1500KMin: 1844306.82 / Avg: 1854249.51 / Max: 1862210.991. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 1000 - Mode: Read Onlyabcde400K800K1200K1600K2000KSE +/- 17169.84, N = 3185518018513451819315181941718177811. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 1000 - Mode: Read Onlyabcde300K600K900K1200K1500KMin: 1792894.77 / Avg: 1819314.59 / Max: 1851522.011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latencyabcde0.12380.24760.37140.49520.619SE +/- 0.005, N = 30.5390.5400.5500.5500.5501. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latencyabcde246810Min: 0.54 / Avg: 0.55 / Max: 0.561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Onlyabcde400K800K1200K1600K2000KSE +/- 5742.85, N = 3188905318836631866789189161918538921. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Onlyabcde300K600K900K1200K1500KMin: 1856279.96 / Avg: 1866788.94 / Max: 1876057.411. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latencyabcde0.01220.02440.03660.04880.061SE +/- 0.000, N = 30.0530.0530.0540.0530.0541. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latencyabcde12345Min: 0.05 / Avg: 0.05 / Max: 0.051. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Onlyabcde400K800K1200K1600K2000KSE +/- 3129.78, N = 3175296417332971724371174354617538341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Onlyabcde300K600K900K1200K1500KMin: 1719786.65 / Avg: 1724370.98 / Max: 1730354.291. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latencyabcde1326395265SE +/- 0.20, N = 358.1558.3457.4958.4257.721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latencyabcde1224364860Min: 57.12 / Avg: 57.49 / Max: 57.811. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Writeabcde400800120016002000SE +/- 6.15, N = 3172017141739171217321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Writeabcde30060090012001500Min: 1729.72 / Avg: 1739.45 / Max: 1750.841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Onlyabcde400K800K1200K1600K2000KSE +/- 3858.11, N = 3165503816736461652713164840016613601. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Onlyabcde300K600K900K1200K1500KMin: 1647599.04 / Avg: 1652713.45 / Max: 1660274.371. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latencyabcde0.10910.21820.32730.43640.5455SE +/- 0.001, N = 30.4830.4780.4840.4850.4821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latencyabcde246810Min: 0.48 / Avg: 0.48 / Max: 0.491. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latencyabcde0.03260.06520.09780.13040.163SE +/- 0.000, N = 30.1430.1440.1450.1430.1431. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latencyabcde12345Min: 0.14 / Avg: 0.14 / Max: 0.151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read Onlyabcde400K800K1200K1600K2000KSE +/- 19985.86, N = 3162529116343611628094164710016468831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read Onlyabcde300K600K900K1200K1500KMin: 1600604.46 / Avg: 1628093.84 / Max: 1666969.271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latencyabcde0.13840.27680.41520.55360.692SE +/- 0.008, N = 30.6150.6120.6150.6070.6071. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latencyabcde246810Min: 0.6 / Avg: 0.61 / Max: 0.631. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenRadioss

OpenBenchmarking.orgSeconds, Fewer Is BetterOpenRadioss 2023.09.15Model: INIVOL and Fluid Structure Interaction Drop Containerabcde70140210280350SE +/- 0.36, N = 3298.96299.28300.39297.31300.98
OpenBenchmarking.orgSeconds, Fewer Is BetterOpenRadioss 2023.09.15Model: INIVOL and Fluid Structure Interaction Drop Containerabcde50100150200250Min: 299.87 / Avg: 300.39 / Max: 301.08

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 16Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latencyabcde0.0990.1980.2970.3960.495SE +/- 0.002, N = 30.4350.4400.4360.4360.4371. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latencyabcde12345Min: 0.43 / Avg: 0.44 / Max: 0.441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Onlyabcde400K800K1200K1600K2000KSE +/- 7653.62, N = 3183963518193211836284183389118293921. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Onlyabcde300K600K900K1200K1500KMin: 1826633.89 / Avg: 1836284.1 / Max: 1851399.431. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Onlyabcde400K800K1200K1600K2000KSE +/- 8032.58, N = 3176368317665091754302176978617508311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Onlyabcde300K600K900K1200K1500KMin: 1743998.59 / Avg: 1754302.17 / Max: 1770128.421. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latencyabcde510152025SE +/- 0.02, N = 319.5919.7519.6019.5519.631. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latencyabcde510152025Min: 19.56 / Avg: 19.6 / Max: 19.621. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read Writeabcde11K22K33K44K55KSE +/- 48.63, N = 351040506285102651156509361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read Writeabcde9K18K27K36K45KMin: 50957.17 / Avg: 51026.32 / Max: 51120.141. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenRadioss

OpenBenchmarking.orgSeconds, Fewer Is BetterOpenRadioss 2023.09.15Model: Chrysler Neon 1Mabcde150300450600750SE +/- 1.17, N = 3712.28713.95716.98714.46718.50
OpenBenchmarking.orgSeconds, Fewer Is BetterOpenRadioss 2023.09.15Model: Chrysler Neon 1Mabcde130260390520650Min: 715.09 / Avg: 716.98 / Max: 719.13

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 16Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latencyabcde0.01280.02560.03840.05120.064SE +/- 0.000, N = 30.0570.0570.0570.0570.0571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latencyabcde12345Min: 0.06 / Avg: 0.06 / Max: 0.061. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latencyabcde30060090012001500SE +/- 114.06, N = 121282.531548.481589.971529.511628.151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latencyabcde30060090012001500Min: 1033.52 / Avg: 1589.97 / Max: 2317.451. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 1000 - Mode: Read Writeabcde2004006008001000SE +/- 49.10, N = 127806466666546141. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 1000 - Mode: Read Writeabcde140280420560700Min: 431.51 / Avg: 666.28 / Max: 967.571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latencyabcde30060090012001500SE +/- 47.94, N = 121045.91764.091062.251275.231106.801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latencyabcde2004006008001000Min: 809.35 / Avg: 1062.25 / Max: 1296.171. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Writeabcde2004006008001000SE +/- 35.88, N = 1276510477716277231. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Writeabcde2004006008001000Min: 617.2 / Avg: 770.79 / Max: 988.451. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latencyabcde110220330440550SE +/- 18.79, N = 9443.85492.37499.42428.93495.561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latencyabcde90180270360450Min: 378.05 / Avg: 499.42 / Max: 579.971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Writeabcde30060090012001500SE +/- 43.72, N = 9112710151014116610091. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Writeabcde2004006008001000Min: 862.11 / Avg: 1014.17 / Max: 1322.591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

46 Results Shown

PostgreSQL:
  1 - 250 - Read Write - Average Latency
  1 - 250 - Read Write
  100 - 100 - Read Write - Average Latency
  100 - 100 - Read Write
  100 - 250 - Read Write - Average Latency
  100 - 250 - Read Write
  100 - 500 - Read Write - Average Latency
  100 - 500 - Read Write
OpenRadioss
PostgreSQL:
  100 - 800 - Read Write - Average Latency
  100 - 800 - Read Write
  100 - 500 - Read Only
  100 - 500 - Read Only - Average Latency
OpenRadioss:
  Bumper Beam
  Bird Strike on Windshield
PostgreSQL:
  1 - 250 - Read Only
  1 - 250 - Read Only - Average Latency
  1 - 500 - Read Only - Average Latency
OpenRadioss
PostgreSQL:
  1 - 500 - Read Only
  1 - 1000 - Read Only
  1 - 1000 - Read Only - Average Latency
  1 - 100 - Read Only
  1 - 100 - Read Only - Average Latency
  100 - 250 - Read Only
  1 - 100 - Read Write - Average Latency
  1 - 100 - Read Write
  100 - 800 - Read Only
  100 - 800 - Read Only - Average Latency
  100 - 250 - Read Only - Average Latency
  100 - 1000 - Read Only
  100 - 1000 - Read Only - Average Latency
OpenRadioss
PostgreSQL:
  1 - 800 - Read Only - Average Latency
  1 - 800 - Read Only
  100 - 100 - Read Only
  100 - 1000 - Read Write - Average Latency
  100 - 1000 - Read Write
OpenRadioss
PostgreSQL:
  100 - 100 - Read Only - Average Latency
  1 - 1000 - Read Write - Average Latency
  1 - 1000 - Read Write
  1 - 800 - Read Write - Average Latency
  1 - 800 - Read Write
  1 - 500 - Read Write - Average Latency
  1 - 500 - Read Write