PostgreSQL 16 AMD EPYC

AMD EPYC 9684X 96-Core testing with a AMD Titanite_4G (RTI1007B BIOS) and ASPEED on Ubuntu 23.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 2309165-NE-POSTGRESQ26
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

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

Additional Graphs

Show Perf Per Core/Thread Calculation Graphs Where Applicable
Show Perf Per Clock Calculation Graphs Where Applicable

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
9754 a
September 14 2023
  2 Hours, 31 Minutes
9654
September 15 2023
  2 Hours, 28 Minutes
9654 2
September 16 2023
  2 Hours, 23 Minutes
9684x
September 16 2023
  2 Hours, 28 Minutes
9684x 2
September 16 2023
  2 Hours, 28 Minutes
Invert Hiding All Results Option
  2 Hours, 28 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):


PostgreSQL 16 AMD EPYCProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelDesktopDisplay ServerCompilerFile-SystemScreen Resolution9754 a96549654 29684x9684x 2AMD EPYC 9754 128-Core @ 2.25GHz (128 Cores / 256 Threads)AMD Titanite_4G (RTI1007B BIOS)AMD Device 14a4768GB3201GB Micron_7450_MTFDKCC3T2TFSASPEEDBroadcom NetXtreme BCM5720 PCIeUbuntu 23.106.5.1-060501-generic (x86_64)GNOME ShellX Server 1.21.1.7GCC 13.2.0ext4640x480AMD EPYC 9654 96-Core @ 2.40GHz (96 Cores / 192 Threads)6.6.0-060600rc1-generic (x86_64)1920x1200AMD EPYC 9684X 96-Core @ 2.55GHz (96 Cores / 192 Threads)OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseCompiler Details- --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,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-defaulted --enable-offload-targets=nvptx-none=/build/gcc-13-nEN1TP/gcc-13-13.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-13-nEN1TP/gcc-13-13.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-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 Processor Details- 9754 a: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xaa00116- 9654: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xa10113e- 9654 2: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xa10113e- 9684x: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xa10113e- 9684x 2: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xa10113eSecurity Details- 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 + 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

9754 a96549654 29684x9684x 2Result OverviewPhoronix Test Suite100%166%231%297%363%PostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQL1000 - 50 - Read Write1000 - 50 - Read Write - Average Latency100 - 800 - Read Write - Average Latency100 - 800 - Read Write100 - 250 - Read Write - Average Latency100 - 250 - Read Write100 - 500 - Read Write - Average Latency100 - 500 - Read Write100 - 50 - Read Write100 - 50 - Read Write - Average Latency100 - 100 - Read Write - Average Latency100 - 100 - Read Write1 - 800 - Read Write - Average Latency1 - 800 - Read Write1000 - 800 - Read Only1000 - 800 - Read Only - Average Latency1 - 500 - Read Write - Average Latency1 - 500 - Read Write1000 - 100 - Read Only - Average Latency1000 - 100 - Read Only1 - 100 - Read Write1 - 100 - Read Write - Average Latency1000 - 500 - Read Only - Average Latency1000 - 500 - Read Only1 - 50 - Read Write1 - 50 - Read Write - Average Latency1 - 1000 - Read Only1 - 1000 - Read Only - Average Latency1000 - 250 - Read Only - Average Latency1000 - 250 - Read Only1 - 1000 - Read Write - Average Latency1 - 1000 - Read Write100 - 1000 - Read Only100 - 1000 - Read Only - Average Latency1 - 250 - Read Only1 - 250 - Read Only - Average Latency1 - 250 - Read Write1 - 250 - Read Write - Average Latency1 - 50 - Read Only - Average Latency1 - 800 - Read Only - Average Latency1 - 800 - Read Only100 - 50 - Read Only - Average Latency1 - 50 - Read Only100 - 50 - Read Only1 - 100 - Read Only - Average Latency100 - 800 - Read Only100 - 800 - Read Only - Average Latency100 - 500 - Read Only - Average Latency100 - 100 - Read Only - Average Latency100 - 250 - Read Only100 - 500 - Read Only1000 - 50 - Read Only1000 - 50 - Read Only - Average Latency1 - 100 - Read Only100 - 250 - Read Only - Average Latency100 - 100 - Read Only1 - 500 - Read Only1 - 500 - Read Only - Average Latency

PostgreSQL 16 AMD EPYCpgbench: 1000 - 50 - Read Writepgbench: 1000 - 50 - Read Write - Average Latencypgbench: 100 - 800 - Read Write - Average Latencypgbench: 100 - 800 - Read Writepgbench: 100 - 250 - Read Write - Average Latencypgbench: 100 - 250 - Read Writepgbench: 100 - 500 - Read Write - Average Latencypgbench: 100 - 500 - Read Writepgbench: 100 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 100 - Read Writepgbench: 100 - 1000 - Read Writepgbench: 100 - 1000 - Read Write - Average Latencypgbench: 1 - 800 - Read Write - Average Latencypgbench: 1 - 800 - Read Writepgbench: 1000 - 800 - Read Onlypgbench: 1000 - 800 - Read Only - Average Latencypgbench: 1 - 500 - Read Write - Average Latencypgbench: 1 - 500 - Read Writepgbench: 1000 - 100 - Read Only - Average Latencypgbench: 1000 - 100 - Read Onlypgbench: 1 - 100 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1000 - 500 - Read Only - Average Latencypgbench: 1000 - 500 - Read Onlypgbench: 1 - 50 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 1 - 1000 - Read Onlypgbench: 1 - 1000 - Read Only - Average Latencypgbench: 1000 - 250 - Read Only - Average Latencypgbench: 1000 - 250 - Read Onlypgbench: 1 - 1000 - Read Write - Average Latencypgbench: 1 - 1000 - Read Writepgbench: 100 - 1000 - Read Onlypgbench: 100 - 1000 - Read Only - Average Latencypgbench: 1 - 250 - Read Onlypgbench: 1 - 250 - Read Only - Average Latencypgbench: 1 - 250 - Read Writepgbench: 1 - 250 - Read Write - Average Latencypgbench: 1 - 50 - Read Only - Average Latencypgbench: 1 - 800 - Read Only - Average Latencypgbench: 1 - 800 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 1 - 50 - Read Onlypgbench: 100 - 50 - Read Onlypgbench: 1 - 100 - Read Only - Average Latencypgbench: 100 - 800 - Read Onlypgbench: 100 - 800 - Read Only - Average Latencypgbench: 100 - 500 - Read Only - Average Latencypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 250 - Read Onlypgbench: 100 - 500 - Read Onlypgbench: 1000 - 50 - Read Onlypgbench: 1000 - 50 - Read Only - Average Latencypgbench: 1 - 100 - Read Onlypgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 100 - Read Onlypgbench: 1 - 500 - Read Onlypgbench: 1 - 500 - Read Only - Average Latency9754 a96549654 29684x9684x 2287271.74114.503551623.802657498.45259156748440.6681.221818675052419.793739.206108222935910.349293.27517050.0551827118543018.4160.222224858368507.29932530600.3070.11721308661123.22889034497940.2934370870.073346872.0780.0250.23833654690.026201915719014160.03433690080.2370.1520.0363362423329591116311060.03129112960.074277026135389760.141183152.7320.068398655.2874728411.05945212458981.0891.735576474403522.709595.369134420486670.39232.74121480.0462170402604416.5460.237211377671307.01237665600.2650.12619763441051.62495137324250.26839304690.064379165.940.0220.2138137830.024223074720972430.03337722210.2120.1360.0353731124366940816567040.0330061160.067281784737854160.132664170.7539.876810012.748909635.83185743841800.5941.13887883735.622108817439530.459245.60120360.0442274877626715.9560.249201037978876.3437945260.2640.12120689381212.51682534805550.28738059430.066395163.2820.0220.22136280660.023228127421355400.03435845380.2230.1370.0363746240364382718100140.02829770700.067279105938118230.131631830.79111.556692283.107804686.70674563788650.6341.164859246497015.392840.6295216622140.481247.08720240.0472131667636315.7160.262190667076956.49835911560.2780.13618354501113.47489832732300.30637280840.067389264.2280.0230.21836627780.025213496319992820.03734246510.2340.1440.0393568078346705017116270.02927164150.07256612936986990.135637400.78411.571691393.085810266.7574074787920.6351.187842536575215.209734.464108916980860.471308.04616230.0482097171649715.3920.262190883179916.25736063410.2770.12919330471045.60195632225730.3136872600.068388164.4210.0230.22236075440.025212920719722460.03733844200.2360.1440.0393588981346736617141980.02927245120.07255636636834450.136OpenBenchmarking.org

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 50 - Mode: Read Write96549754 a9684x9684x 29654 214K28K42K56K70K18315287276318363740664171. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency96549754 a9684x9684x 29654 20.61431.22861.84292.45723.07152.7301.7410.7910.7840.7531. (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 Latency96549754 a9684x 29684x9654 251015202520.06814.50311.57111.5569.8761. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Write96549754 a9684x 29684x9654 220K40K60K80K100K39865551626913969228810011. (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 Latency96549754 a9684x9684x 29654 21.18962.37923.56884.75845.9485.2873.8023.1073.0852.7481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Write96549754 a9684x9684x 29654 220K40K60K80K100K47284657498046881026909631. (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 Latency96549754 a9684x 29684x9654 2369121511.0598.4526.7506.7065.8311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Write96549754 a9684x 29684x9654 220K40K60K80K100K45212591567407474563857431. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Write96549754 a9684x 29684x9654 220K40K60K80K100K45898748447879278865841801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency96549754 a9684x 29684x9654 20.2450.490.7350.981.2251.0890.6680.6350.6340.5941. (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 Latency96549754 a9684x 29684x9654 20.39040.78081.17121.56161.9521.7351.2211.1871.1641.1381. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Write96549754 a9684x 29684x9654 220K40K60K80K100K57647818678425385924878831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read Write96549754 a9684x9684x 214K28K42K56K70K440355052464970657521. (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 Latency96549754 a9684x9684x 251015202522.7119.7915.3915.211. (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 Latency9684x9754 a9654 29684x 296542004006008001000840.62739.21735.62734.46595.371. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Write9684x9754 a9654 29684x 296543006009001200150095210821088108913441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 800 - Mode: Read Only9684x9684x 29654 296549754 a500K1000K1500K2000K2500K166221416980861743953204866722935911. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average Latency9684x9684x 29654 296549754 a0.10820.21640.32460.43280.5410.4810.4710.4590.3900.3491. (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 Latency9684x 29754 a9684x9654 2965470140210280350308.05293.28247.09245.60232.741. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Write9684x 29754 a9684x9654 296545001000150020002500162317052024203621481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency9754 a9684x 29684x96549654 20.01240.02480.03720.04960.0620.0550.0480.0470.0460.0441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 100 - Mode: Read Only9754 a9684x 29684x96549654 2500K1000K1500K2000K2500K182711820971712131667217040222748771. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Write9754 a96549654 29684x9684x 214002800420056007000543060446267636364971. (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 Latency9754 a96549654 29684x9684x 251015202518.4216.5515.9615.7215.391. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency9684x 29684x9654 296549754 a0.0590.1180.1770.2360.2950.2620.2620.2490.2370.2221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 500 - Mode: Read Only9684x9684x 29654 296549754 a500K1000K1500K2000K2500K190667019088312010379211377622485831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 50 - Mode: Read Write9754 a96549684x9654 29684x 22K4K6K8K10K685071307695788779911. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency9754 a96549684x9654 29684x 22468107.2997.0126.4986.3406.2571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 1000 - Mode: Read Only9754 a9684x9684x 296549654 2800K1600K2400K3200K4000K325306035911563606341376656037945261. (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 Latency9754 a9684x9684x 296549654 20.06910.13820.20730.27640.34550.3070.2780.2770.2650.2641. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency9684x9684x 296549654 29754 a0.03060.06120.09180.12240.1530.1360.1290.1260.1210.1171. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 250 - Mode: Read Only9684x9684x 296549654 29754 a500K1000K1500K2000K2500K183545019330471976344206893821308661. (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 Latency9654 29754 a9684x96549684x 2300600900120015001212.521123.231113.471051.621045.601. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 1000 - Mode: Read Write9654 29754 a9684x96549684x 220040060080010008258908989519561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read Only9684x 29684x9754 a9654 29654800K1600K2400K3200K4000K322257332732303449794348055537324251. (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 Latency9684x 29684x9754 a9654 296540.06980.13960.20940.27920.3490.3100.3060.2900.2870.2681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Only9754 a9684x 29684x9654 29654800K1600K2400K3200K4000K343708736872603728084380594339304691. (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 Latency9754 a9684x 29684x9654 296540.01640.03280.04920.06560.0820.0730.0680.0670.0660.0641. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 250 - Mode: Read Write9754 a96549684x 29684x9654 28001600240032004000346837913881389239511. (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 Latency9754 a96549684x 29684x9654 2163248648072.0865.9464.4264.2363.281. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency9754 a9684x 29684x9654 296540.00560.01120.01680.02240.0280.0250.0230.0230.0220.0221. (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 Latency9754 a9684x 29654 29684x96540.05360.10720.16080.21440.2680.2380.2220.2210.2180.2101. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 800 - Mode: Read Only9754 a9684x 29654 29684x9654800K1600K2400K3200K4000K336546936075443628066366277838137831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency9754 a9684x 29684x96549654 20.00590.01180.01770.02360.02950.0260.0250.0250.0240.0231. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 50 - Mode: Read Only9754 a9684x 29684x96549654 2500K1000K1500K2000K2500K201915721292072134963223074722812741. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Only9754 a9684x 29684x96549654 2500K1000K1500K2000K2500K190141619722461999282209724321355401. (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 Latency9684x 29684x9654 29754 a96540.00830.01660.02490.03320.04150.0370.0370.0340.0340.0331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read Only9754 a9684x 29684x9654 29654800K1600K2400K3200K4000K336900833844203424651358453837722211. (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 Latency9754 a9684x 29684x9654 296540.05330.10660.15990.21320.26650.2370.2360.2340.2230.2121. (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 Latency9754 a9684x 29684x9654 296540.03420.06840.10260.13680.1710.1520.1440.1440.1370.1361. (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 Latency9684x 29684x9654 29754 a96540.00880.01760.02640.03520.0440.0390.0390.0360.0360.0351. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Only9754 a9684x9684x 296549654 2800K1600K2400K3200K4000K336242335680783588981373112437462401. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Only9754 a9684x9684x 29654 29654800K1600K2400K3200K4000K329591134670503467366364382736694081. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 50 - Mode: Read Only9754 a96549684x9684x 29654 2400K800K1200K1600K2000K163110616567041711627171419818100141. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency9754 a96549684x 29684x9654 20.0070.0140.0210.0280.0350.0310.0300.0290.0290.0281. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 100 - Mode: Read Only9684x9684x 29754 a9654 29654600K1200K1800K2400K3000K271641527245122911296297707030061161. (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 Latency9754 a9684x 29684x9654 296540.01670.03340.05010.06680.08350.0740.0700.0700.0670.0671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Only9684x 29684x9754 a9654 29654600K1200K1800K2400K3000K255636625661292770261279105928178471. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1 - Clients: 500 - Mode: Read Only9754 a9684x 29684x96549654 2800K1600K2400K3200K4000K353897636834453698699378541638118231. (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 Latency9754 a9684x 29684x96549654 20.03170.06340.09510.12680.15850.1410.1360.1350.1320.1311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

60 Results Shown

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