0xO1-pts-pgbench-morph

AMD Ryzen 7 5700U testing with a LENOVO LNVNB161216 (GJCN20WW BIOS) and amdgpudrmfb on Ubuntu 20.04 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2111254-TJ-0XO1PTSPG08&sro.

0xO1-pts-pgbench-morphProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerCompilerFile-SystemScreen ResolutionConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637795683AMD Ryzen 7 5700U @ 1.80GHz (8 Cores / 16 Threads)LENOVO LNVNB161216 (GJCN20WW BIOS)AMD Renoir Root Complex16GB256GB HFM256GDJTNG-8310Aamdgpudrmfb (1900/400MHz)AMD Device 1637Realtek RTL8822CE 802.11ac PCIeUbuntu 20.045.11.0-40-generic (x86_64)GNOME Shell 3.36.9X Server 1.20.11GCC 9.3.0ext41920x1080OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseCompiler Details- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --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++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-HskZEa/gcc-9-9.3.0/debian/tmp-nvptx/usr,hsa --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 Processor Details- Scaling Governor: acpi-cpufreq ondemand (Boost: Enabled) - CPU Microcode: 0x8608103Security Details- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline IBPB: conditional IBRS_FW STIBP: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected

0xO1-pts-pgbench-morphpgbench: 1 - 1 - Read Onlypgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Write - Average Latencypgbench: 1 - 50 - Read Onlypgbench: 1 - 50 - Read Only - Average Latencypgbench: 1 - 100 - Read Onlypgbench: 1 - 100 - Read Only - Average Latencypgbench: 1 - 250 - Read Onlypgbench: 1 - 250 - Read Only - Average Latencypgbench: 1 - 50 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 1 - 500 - Read Onlypgbench: 1 - 500 - Read Only - Average Latencypgbench: 100 - 1 - Read Onlypgbench: 100 - 1 - Read Only - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 250 - Read Writepgbench: 1 - 250 - Read Write - Average Latencypgbench: 1 - 500 - Read Writepgbench: 1 - 500 - Read Write - Average Latencypgbench: 100 - 1 - Read Writepgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 50 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 1000 - 1 - Read Onlypgbench: 1000 - 1 - Read Only - Average Latencypgbench: 100 - 100 - Read Onlypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 250 - Read Onlypgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 500 - Read Onlypgbench: 100 - 500 - Read Only - Average Latencypgbench: 1000 - 1 - Read Writepgbench: 1000 - 1 - Read Write - Average Latencypgbench: 1000 - 50 - Read Onlypgbench: 1000 - 50 - Read Only - Average Latencypgbench: 100 - 100 - Read Writepgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 250 - Read Writepgbench: 100 - 250 - Read Write - Average Latencypgbench: 100 - 500 - Read Writepgbench: 100 - 500 - Read Write - Average Latencypgbench: 1000 - 100 - Read Onlypgbench: 1000 - 100 - Read Only - Average Latencypgbench: 1000 - 250 - Read Onlypgbench: 1000 - 250 - Read Only - Average Latencypgbench: 1000 - 50 - Read Writepgbench: 1000 - 50 - Read Write - Average Latencypgbench: 1000 - 500 - Read Onlypgbench: 1000 - 500 - Read Only - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 100 - Read Write - Average Latencypgbench: 1000 - 250 - Read Writepgbench: 1000 - 250 - Read Write - Average Latencypgbench: 10000 - 500 - Read WriteConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637795683223690.0459001.1121370760.3651103500.9061058122.363108246.2371225554.100285020.035113987.843962260.080723694.3527001.5031837810.27255300.1821354410.7381293951.933351110.02810131.3471966440.2541559040.6421471471.69969697.9891296513.874325530.031767180.144944264.7675691048.1775192.1861876960.26757590.1741471210.6801393001.79569237.2371259663.9722673.788776870.644690614.481810230.872796262.808786341.272646323.868495010.105588608.496602516.604613440.887OpenBenchmarking.org

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 1 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read OnlyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956838K16K24K32K40KSE +/- 62.18, N = 3SE +/- 284.90, N = 322369351111. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956830.01010.02020.03030.04040.0505SE +/- 0.000, N = 3SE +/- 0.000, N = 30.0450.0281. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 1 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read WriteConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956832004006008001000SE +/- 7.56, N = 8SE +/- 116.83, N = 1290010131. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956830.30310.60620.90931.21241.5155SE +/- 0.009, N = 8SE +/- 0.301, N = 121.1121.3471. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 50 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read OnlyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568340K80K120K160K200KSE +/- 534.91, N = 3SE +/- 191.79, N = 31370761966441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956830.08210.16420.24630.32840.4105SE +/- 0.001, N = 3SE +/- 0.000, N = 30.3650.2541. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 100 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read OnlyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568330K60K90K120K150KSE +/- 927.71, N = 3SE +/- 1558.11, N = 51103501559041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956830.20390.40780.61170.81561.0195SE +/- 0.008, N = 3SE +/- 0.006, N = 50.9060.6421. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 250 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read OnlyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568330K60K90K120K150KSE +/- 629.28, N = 3SE +/- 604.99, N = 31058121471471. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956830.53171.06341.59512.12682.6585SE +/- 0.014, N = 3SE +/- 0.007, N = 32.3631.6991. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read WriteConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956832004006008001000SE +/- 8.89, N = 9SE +/- 114.19, N = 1210826961. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568320406080100SE +/- 0.37, N = 9SE +/- 14.82, N = 1246.2497.991. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 500 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read OnlyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568330K60K90K120K150KSE +/- 2437.17, N = 12SE +/- 2525.47, N = 121225551296511. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956830.92251.8452.76753.694.6125SE +/- 0.090, N = 12SE +/- 0.081, N = 124.1003.8741. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 1 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read OnlyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956837K14K21K28K35KSE +/- 203.42, N = 3SE +/- 424.21, N = 328502325531. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956830.00790.01580.02370.03160.0395SE +/- 0.000, N = 3SE +/- 0.001, N = 30.0350.0311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 100 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read WriteConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956832004006008001000SE +/- 7.94, N = 3SE +/- 115.63, N = 1211397671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956834080120160200SE +/- 0.61, N = 3SE +/- 30.50, N = 1287.84180.141. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 250 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read WriteConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956832004006008001000SE +/- 11.57, N = 3SE +/- 8.71, N = 39629441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568360120180240300SE +/- 3.17, N = 3SE +/- 2.42, N = 3260.08264.771. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 500 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read WriteConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637795683160320480640800SE +/- 14.27, N = 12SE +/- 61.75, N = 127235691. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956832004006008001000SE +/- 14.48, N = 12SE +/- 143.74, N = 12694.351048.181. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 1 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read WriteConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637795683150300450600750SE +/- 52.91, N = 9SE +/- 56.48, N = 127005191. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956830.49190.98381.47571.96762.4595SE +/- 0.126, N = 9SE +/- 0.232, N = 121.5032.1861. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 50 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read OnlyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568340K80K120K160K200KSE +/- 661.53, N = 3SE +/- 642.31, N = 31837811876961. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956830.06120.12240.18360.24480.306SE +/- 0.001, N = 3SE +/- 0.001, N = 30.2720.2671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 1 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read OnlyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568312002400360048006000SE +/- 143.98, N = 6SE +/- 130.61, N = 9553057591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956830.0410.0820.1230.1640.205SE +/- 0.005, N = 6SE +/- 0.004, N = 90.1820.1741. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 100 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read OnlyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568330K60K90K120K150KSE +/- 1409.93, N = 3SE +/- 1469.05, N = 61354411471211. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956830.16610.33220.49830.66440.8305SE +/- 0.008, N = 3SE +/- 0.007, N = 60.7380.6801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 250 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read OnlyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568330K60K90K120K150KSE +/- 1245.46, N = 6SE +/- 1013.00, N = 31293951393001. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637758780Convertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956830.43490.86981.30471.73962.1745SE +/- 0.019, N = 6SE +/- 0.013, N = 31.9331.7951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read WriteConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568315003000450060007500SE +/- 94.14, N = 1269231. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637795683246810SE +/- 0.100, N = 127.2371. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 500 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read OnlyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568330K60K90K120K150KSE +/- 987.54, N = 101259661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956830.89371.78742.68113.57484.4685SE +/- 0.031, N = 103.9721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 1 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read WriteConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568360120180240300SE +/- 11.67, N = 92671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956830.85231.70462.55693.40924.2615SE +/- 0.128, N = 93.7881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 50 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read OnlyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568317K34K51K68K85KSE +/- 149.19, N = 3776871. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956830.14490.28980.43470.57960.7245SE +/- 0.001, N = 30.6441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 100 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read WriteConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568315003000450060007500SE +/- 16.02, N = 369061. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568348121620SE +/- 0.03, N = 314.481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 250 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read WriteConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956832K4K6K8K10KSE +/- 99.42, N = 481021. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637795683714212835SE +/- 0.39, N = 430.871. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 500 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read WriteConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956832K4K6K8K10KSE +/- 70.31, N = 379621. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956831428425670SE +/- 0.56, N = 362.811. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 100 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 100 - Mode: Read OnlyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568320K40K60K80K100KSE +/- 703.16, N = 9786341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956830.28620.57240.85861.14481.431SE +/- 0.012, N = 91.2721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 250 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read OnlyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568314K28K42K56K70KSE +/- 364.52, N = 3646321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956830.87031.74062.61093.48124.3515SE +/- 0.022, N = 33.8681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read WriteConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568311002200330044005500SE +/- 66.33, N = 349501. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-16377956833691215SE +/- 0.14, N = 310.111. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 500 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 500 - Mode: Read OnlyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568313K26K39K52K65KSE +/- 384.35, N = 3588601. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637795683246810SE +/- 0.055, N = 38.4961. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 100 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 100 - Mode: Read WriteConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568313002600390052006500SE +/- 64.21, N = 460251. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568348121620SE +/- 0.18, N = 416.601. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 250 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read WriteConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-163779568313002600390052006500SE +/- 177.78, N = 561341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average LatencyConvertible-x86_64-Ubuntu-20.04-pts-pgbench-morph-1637795683918273645SE +/- 1.14, N = 540.891. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm


Phoronix Test Suite v10.8.4