postgresql Linux 6.10

Benchmarks for a future article.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2405281-NE-POSTGRESQ25
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

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
Linux 6.10-rc1
May 27
  5 Hours, 32 Minutes
Linux 6.9
May 27
  4 Hours, 14 Minutes
Invert Hiding All Results Option
  4 Hours, 53 Minutes
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 Linux 6.10OpenBenchmarking.orgPhoronix Test SuiteAMD Ryzen Threadripper 7980X 64-Cores @ 5.37GHz (64 Cores / 128 Threads)System76 Thelio Major (FA Z5 BIOS)AMD Device 14a44 x 32GB DDR5-4800MT/s Micron MTC20F1045S1RC48BA21000GB CT1000T700SSD5AMD Radeon Pro W7900 45GBAMD Device 14ccDELL P2415QAquantia AQC113C NBase-T/IEEE + Realtek RTL8125 2.5GbE + Intel Wi-Fi 6EUbuntu 24.046.10.0-061000rc1-generic (x86_64)6.9.0-060900-generic (x86_64)GNOME Shell 46.0X Server + Wayland4.6 Mesa 24.0.5-1ubuntu1 (LLVM 17.0.6 DRM 3.57)GCC 13.2.0ext41920x1200ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelsDesktopDisplay ServerOpenGLCompilerFile-SystemScreen ResolutionPostgresql Linux 6.10 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-backtrace --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-13-uJ7kn6/gcc-13-13.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-13-uJ7kn6/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-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v - Scaling Governor: amd-pstate-epp powersave (EPP: balance_performance) - CPU Microcode: 0xa108105- gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + reg_file_data_sampling: 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; BHI: Not affected + srbds: Not affected + tsx_async_abort: Not affected

Linux 6.10-rc1 vs. Linux 6.9 ComparisonPhoronix Test SuiteBaseline+2.8%+2.8%+5.6%+5.6%+8.4%+8.4%100 - 1000 - Read Write11%100 - 1000 - Read Write - Average Latency10.8%1000 - 250 - Read Write6.3%100 - 250 - Read Write6.2%100 - 250 - Read Write - Average Latency6%1000 - 250 - Read Write - Average Latency5.6%100 - 800 - Read Write5.4%100 - 800 - Read Write - Average Latency5.4%1000 - 800 - Read Write - Average Latency4%1000 - 800 - Read Write4%PostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQLLinux 6.10-rc1Linux 6.9

postgresql Linux 6.10pgbench: 100 - 250 - Read Onlypgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 800 - Read Onlypgbench: 100 - 800 - Read Only - Average Latencypgbench: 100 - 1000 - Read Onlypgbench: 100 - 1000 - Read Only - Average Latencypgbench: 100 - 250 - Read Writepgbench: 100 - 250 - Read Write - Average Latencypgbench: 100 - 800 - Read Writepgbench: 100 - 800 - Read Write - Average Latencypgbench: 1000 - 250 - Read Onlypgbench: 1000 - 250 - Read Only - Average Latencypgbench: 1000 - 800 - Read Onlypgbench: 1000 - 800 - Read Only - Average Latencypgbench: 100 - 1000 - Read Writepgbench: 100 - 1000 - Read Write - Average Latencypgbench: 1000 - 1000 - Read Onlypgbench: 1000 - 1000 - Read Only - Average Latencypgbench: 1000 - 250 - Read Writepgbench: 1000 - 250 - Read Write - Average Latencypgbench: 1000 - 800 - Read Writepgbench: 1000 - 800 - Read Write - Average Latencypgbench: 1000 - 1000 - Read Writepgbench: 1000 - 1000 - Read Write - Average LatencyLinux 6.10-rc1Linux 6.937801230.06638308140.20938335360.261345377.2503526222.69324895250.10120646120.3883538228.31920137690.4961986812.6651978440.4471981350.47438254540.06538651700.20738155680.262325237.6883344523.92124889060.10120861990.3833187831.37820386720.4901869313.3781902542.0641975950.723OpenBenchmarking.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: 100 - Clients: 250 - Mode: Read OnlyLinux 6.9Linux 6.10-rc1800K1600K2400K3200K4000KSE +/- 17254.37, N = 3SE +/- 25574.02, N = 3382545437801231. (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 LatencyLinux 6.9Linux 6.10-rc10.01490.02980.04470.05960.0745SE +/- 0.000, N = 3SE +/- 0.000, N = 30.0650.0661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read OnlyLinux 6.9Linux 6.10-rc1800K1600K2400K3200K4000KSE +/- 7303.48, N = 3SE +/- 2592.22, N = 3386517038308141. (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 LatencyLinux 6.9Linux 6.10-rc10.0470.0940.1410.1880.235SE +/- 0.000, N = 3SE +/- 0.000, N = 30.2070.2091. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read OnlyLinux 6.9Linux 6.10-rc1800K1600K2400K3200K4000KSE +/- 26098.31, N = 3SE +/- 6471.11, N = 3381556838335361. (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 LatencyLinux 6.9Linux 6.10-rc10.0590.1180.1770.2360.295SE +/- 0.002, N = 3SE +/- 0.000, N = 30.2620.2611. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read WriteLinux 6.9Linux 6.10-rc17K14K21K28K35KSE +/- 216.12, N = 3SE +/- 432.86, N = 1232523345371. (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 LatencyLinux 6.9Linux 6.10-rc1246810SE +/- 0.051, N = 3SE +/- 0.085, N = 127.6887.2501. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 800 - Mode: Read WriteLinux 6.9Linux 6.10-rc18K16K24K32K40KSE +/- 170.98, N = 3SE +/- 382.48, N = 333445352621. (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 LatencyLinux 6.9Linux 6.10-rc1612182430SE +/- 0.12, N = 3SE +/- 0.25, N = 323.9222.691. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 250 - Mode: Read OnlyLinux 6.9Linux 6.10-rc1500K1000K1500K2000K2500KSE +/- 11804.87, N = 3SE +/- 17981.79, N = 3248890624895251. (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 LatencyLinux 6.9Linux 6.10-rc10.02270.04540.06810.09080.1135SE +/- 0.000, N = 3SE +/- 0.001, N = 30.1010.1011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 800 - Mode: Read OnlyLinux 6.9Linux 6.10-rc1400K800K1200K1600K2000KSE +/- 11013.57, N = 3SE +/- 6866.97, N = 3208619920646121. (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 LatencyLinux 6.9Linux 6.10-rc10.08730.17460.26190.34920.4365SE +/- 0.002, N = 3SE +/- 0.001, N = 30.3830.3881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1000 - Mode: Read WriteLinux 6.9Linux 6.10-rc18K16K24K32K40KSE +/- 372.54, N = 3SE +/- 495.84, N = 1231878353821. (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 LatencyLinux 6.9Linux 6.10-rc1714212835SE +/- 0.36, N = 3SE +/- 0.36, N = 1231.3828.321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 1000 - Mode: Read OnlyLinux 6.9Linux 6.10-rc1400K800K1200K1600K2000KSE +/- 2289.88, N = 3SE +/- 7837.91, N = 3203867220137691. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average LatencyLinux 6.9Linux 6.10-rc10.11160.22320.33480.44640.558SE +/- 0.001, N = 3SE +/- 0.002, N = 30.4900.4961. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 250 - Mode: Read WriteLinux 6.9Linux 6.10-rc14K8K12K16K20KSE +/- 228.44, N = 3SE +/- 487.98, N = 1218693198681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average LatencyLinux 6.9Linux 6.10-rc13691215SE +/- 0.16, N = 3SE +/- 0.30, N = 1213.3812.671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 800 - Mode: Read WriteLinux 6.9Linux 6.10-rc14K8K12K16K20KSE +/- 249.63, N = 3SE +/- 212.06, N = 319025197841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average LatencyLinux 6.9Linux 6.10-rc11020304050SE +/- 0.55, N = 3SE +/- 0.44, N = 342.0640.451. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 1000 - Mode: Read WriteLinux 6.9Linux 6.10-rc14K8K12K16K20KSE +/- 279.30, N = 12SE +/- 58.63, N = 319759198131. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average LatencyLinux 6.9Linux 6.10-rc11122334455SE +/- 0.72, N = 12SE +/- 0.15, N = 350.7250.471. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm