0xO1-pts-pgbench-nightcrawler AMD Ryzen 3 2200G testing with a ASUS ROG STRIX B450-F GAMING (3003 BIOS) and ASUS AMD Radeon Vega / Mobile 2GB on Ubuntu 20.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2111266-TJ-0XO1PTSPG50&grr&sor&rro .
0xO1-pts-pgbench-nightcrawler Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server Compiler File-System Screen Resolution Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 AMD Ryzen 3 2200G @ 3.50GHz (4 Cores) ASUS ROG STRIX B450-F GAMING (3003 BIOS) AMD Raven/Raven2 30GB 2048GB T-FORCE TM8FP8002T ASUS AMD Radeon Vega / Mobile 2GB (1100/1067MHz) AMD Raven/Raven2/Fenghuang Sceptre C27 Intel I211 Ubuntu 20.04 5.11.0-40-generic (x86_64) GNOME Shell 3.36.9 X Server 1.20.11 GCC 9.3.0 ext4 1920x1080 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Compiler 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: 0x8101016 Security 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 STIBP: disabled RSB filling + srbds: Not affected + tsx_async_abort: Not affected
0xO1-pts-pgbench-nightcrawler pgbench: 10000 - 100 - Read Write - Average Latency pgbench: 10000 - 100 - Read Write pgbench: 10000 - 250 - Read Write - Average Latency pgbench: 10000 - 250 - Read Write pgbench: 10000 - 500 - Read Write - Average Latency pgbench: 10000 - 500 - Read Write pgbench: 10000 - 1 - Read Write - Average Latency pgbench: 10000 - 1 - Read Write pgbench: 10000 - 50 - Read Write - Average Latency pgbench: 10000 - 50 - Read Write pgbench: 10000 - 1 - Read Only - Average Latency pgbench: 10000 - 1 - Read Only pgbench: 10000 - 500 - Read Only - Average Latency pgbench: 10000 - 500 - Read Only pgbench: 10000 - 100 - Read Only - Average Latency pgbench: 10000 - 100 - Read Only pgbench: 10000 - 50 - Read Only - Average Latency pgbench: 10000 - 50 - Read Only pgbench: 10000 - 250 - Read Only - Average Latency pgbench: 10000 - 250 - Read Only pgbench: 1 - 500 - Read Write - Average Latency pgbench: 1 - 500 - Read Write pgbench: 1000 - 1 - Read Only - Average Latency pgbench: 1000 - 1 - Read Only pgbench: 100 - 100 - Read Write - Average Latency pgbench: 100 - 100 - Read Write pgbench: 1000 - 500 - Read Write - Average Latency pgbench: 1000 - 500 - Read Write pgbench: 1000 - 250 - Read Write - Average Latency pgbench: 1000 - 250 - Read Write pgbench: 1000 - 250 - Read Only - Average Latency pgbench: 1000 - 250 - Read Only pgbench: 1000 - 100 - Read Only - Average Latency pgbench: 1000 - 100 - Read Only pgbench: 1000 - 500 - Read Only - Average Latency pgbench: 1000 - 500 - Read Only pgbench: 1000 - 100 - Read Write - Average Latency pgbench: 1000 - 100 - Read Write pgbench: 1000 - 50 - Read Write - Average Latency pgbench: 1000 - 50 - Read Write pgbench: 1000 - 50 - Read Only - Average Latency pgbench: 1000 - 50 - Read Only pgbench: 1000 - 1 - Read Write - Average Latency pgbench: 1000 - 1 - Read Write pgbench: 100 - 500 - Read Only - Average Latency pgbench: 100 - 500 - Read Only pgbench: 100 - 250 - Read Only - Average Latency pgbench: 100 - 250 - Read Only pgbench: 100 - 500 - Read Write - Average Latency pgbench: 100 - 500 - Read Write pgbench: 100 - 250 - Read Write - Average Latency pgbench: 100 - 250 - Read Write pgbench: 100 - 100 - Read Only - Average Latency pgbench: 100 - 100 - Read Only pgbench: 100 - 50 - Read Only - Average Latency pgbench: 100 - 50 - Read Only pgbench: 100 - 50 - Read Write - Average Latency pgbench: 100 - 50 - Read Write pgbench: 100 - 1 - Read Write - Average Latency pgbench: 100 - 1 - Read Write pgbench: 100 - 1 - Read Only - Average Latency pgbench: 100 - 1 - Read Only pgbench: 1 - 250 - Read Write - Average Latency pgbench: 1 - 250 - Read Write pgbench: 1 - 100 - Read Write - Average Latency pgbench: 1 - 100 - Read Write pgbench: 1 - 500 - Read Only - Average Latency pgbench: 1 - 500 - Read Only pgbench: 1 - 250 - Read Only - Average Latency pgbench: 1 - 250 - Read Only pgbench: 1 - 100 - Read Only - Average Latency pgbench: 1 - 100 - Read Only pgbench: 1 - 50 - Read Write - Average Latency pgbench: 1 - 50 - Read Write pgbench: 1 - 50 - Read Only - Average Latency pgbench: 1 - 50 - Read Only pgbench: 1 - 1 - Read Only - Average Latency pgbench: 1 - 1 - Read Only pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 1 - Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 0.396 2528 901.724 555 0.095 10606 18.290 5477 7.830 31930 2.841 35201 20.818 24020 9.377 5334 1.383 36150 0.860 1163 14.683 34056 6.924 36108 112.699 4437 49.586 5042 2.508 39871 1.194 41868 8.281 6038 0.833 1200 0.079 12688 248.083 1008 65.834 1519 13.130 38081 6.308 39640 2.333 42868 27.895 1792 1.122 44556 0.075 13346 0.773 1294 28.697 3626 74.868 3436 144.502 3487 1.297 772 15.502 3558 0.401 2497 30.737 16268 4.469 22376 2.250 22228 12.342 20264 916.220 546 0.092 10847 17.844 5606 101.607 4921 49.360 5065 7.666 32615 2.856 35012 19.541 25591 19.090 5239 9.832 5085 1.380 36244 0.856 1169 14.592 34268 6.861 36441 112.011 4465 49.272 5074 2.532 39499 1.186 42171 8.322 6009 0.834 1199 0.079 12689 252.220 991 66.409 1506 13.020 38404 6.306 39645 2.332 42873 27.819 1797 1.128 44348 0.075 13256 0.775 1291 OpenBenchmarking.org
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 100 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 100 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 7 14 21 28 35 SE +/- 2.05, N = 9 28.70 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 100 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 100 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 800 1600 2400 3200 4000 SE +/- 248.74, N = 9 3626 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 250 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 250 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 20 40 60 80 100 SE +/- 4.51, N = 9 74.87 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 250 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 250 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 700 1400 2100 2800 3500 SE +/- 203.84, N = 9 3436 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 500 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 500 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 30 60 90 120 150 SE +/- 4.58, N = 9 144.50 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 500 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 500 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 700 1400 2100 2800 3500 SE +/- 104.40, N = 9 3487 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 1 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 1 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 0.2918 0.5836 0.8754 1.1672 1.459 SE +/- 0.015, N = 9 1.297 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 1 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 1 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 170 340 510 680 850 SE +/- 9.15, N = 9 772 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 50 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 50 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 4 8 12 16 20 SE +/- 2.49, N = 6 15.50 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 50 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 50 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 800 1600 2400 3200 4000 SE +/- 424.25, N = 6 3558 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 1 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 1 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 0.0902 0.1804 0.2706 0.3608 0.451 SE +/- 0.005, N = 9 SE +/- 0.001, N = 3 0.401 0.396 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 1 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 1 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 500 1000 1500 2000 2500 SE +/- 32.77, N = 9 SE +/- 8.29, N = 3 2497 2528 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 500 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 500 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 7 14 21 28 35 SE +/- 0.13, N = 3 30.74 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 500 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 500 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 3K 6K 9K 12K 15K SE +/- 70.70, N = 3 16268 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 100 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 100 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 1.0055 2.011 3.0165 4.022 5.0275 SE +/- 0.010, N = 3 4.469 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 100 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 100 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 5K 10K 15K 20K 25K SE +/- 51.70, N = 3 22376 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 50 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 50 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 0.5063 1.0126 1.5189 2.0252 2.5315 SE +/- 0.004, N = 3 2.250 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 50 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 50 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 5K 10K 15K 20K 25K SE +/- 40.28, N = 3 22228 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 250 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 250 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 3 6 9 12 15 SE +/- 0.18, N = 3 12.34 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 10000 - Clients: 250 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 250 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 4K 8K 12K 16K 20K SE +/- 292.30, N = 3 20264 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 200 400 600 800 1000 SE +/- 7.70, N = 12 SE +/- 9.47, N = 12 916.22 901.72 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 120 240 360 480 600 SE +/- 4.61, N = 12 SE +/- 5.91, N = 12 546 555 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 0.0214 0.0428 0.0642 0.0856 0.107 SE +/- 0.002, N = 9 SE +/- 0.000, N = 3 0.095 0.092 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 2K 4K 6K 8K 10K SE +/- 171.82, N = 9 SE +/- 23.64, N = 3 10606 10847 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 5 10 15 20 25 SE +/- 0.24, N = 12 SE +/- 0.20, N = 4 18.29 17.84 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 1200 2400 3600 4800 6000 SE +/- 67.57, N = 12 SE +/- 64.85, N = 4 5477 5606 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 20 40 60 80 100 SE +/- 0.45, N = 3 101.61 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 500 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 1100 2200 3300 4400 5500 SE +/- 21.93, N = 3 4921 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 11 22 33 44 55 SE +/- 0.19, N = 3 49.36 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 1100 2200 3300 4400 5500 SE +/- 19.10, N = 3 5065 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 2 4 6 8 10 SE +/- 0.028, N = 3 SE +/- 0.040, N = 3 7.830 7.666 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 7K 14K 21K 28K 35K SE +/- 113.49, N = 3 SE +/- 173.43, N = 3 31930 32615 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 0.6426 1.2852 1.9278 2.5704 3.213 SE +/- 0.006, N = 3 SE +/- 0.020, N = 3 2.856 2.841 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 8K 16K 24K 32K 40K SE +/- 76.72, N = 3 SE +/- 245.81, N = 3 35012 35201 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 5 10 15 20 25 SE +/- 0.15, N = 3 SE +/- 0.17, N = 3 20.82 19.54 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 5K 10K 15K 20K 25K SE +/- 177.13, N = 3 SE +/- 230.54, N = 3 24020 25591 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 5 10 15 20 25 SE +/- 0.11, N = 3 19.09 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 1100 2200 3300 4400 5500 SE +/- 28.83, N = 3 5239 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 3 6 9 12 15 SE +/- 0.033, N = 3 SE +/- 0.120, N = 3 9.832 9.377 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 1100 2200 3300 4400 5500 SE +/- 17.20, N = 3 SE +/- 68.80, N = 3 5085 5334 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 0.3112 0.6224 0.9336 1.2448 1.556 SE +/- 0.010, N = 3 SE +/- 0.006, N = 3 1.383 1.380 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 8K 16K 24K 32K 40K SE +/- 254.98, N = 3 SE +/- 151.24, N = 3 36150 36244 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 0.1935 0.387 0.5805 0.774 0.9675 SE +/- 0.002, N = 3 SE +/- 0.001, N = 3 0.860 0.856 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 300 600 900 1200 1500 SE +/- 2.46, N = 3 SE +/- 1.07, N = 3 1163 1169 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 4 8 12 16 20 SE +/- 0.08, N = 3 SE +/- 0.08, N = 3 14.68 14.59 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 7K 14K 21K 28K 35K SE +/- 197.78, N = 3 SE +/- 195.44, N = 3 34056 34268 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 2 4 6 8 10 SE +/- 0.005, N = 3 SE +/- 0.013, N = 3 6.924 6.861 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 8K 16K 24K 32K 40K SE +/- 26.21, N = 3 SE +/- 70.81, N = 3 36108 36441 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 30 60 90 120 150 SE +/- 0.39, N = 3 SE +/- 1.26, N = 3 112.70 112.01 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 1000 2000 3000 4000 5000 SE +/- 15.14, N = 3 SE +/- 49.91, N = 3 4437 4465 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 11 22 33 44 55 SE +/- 0.30, N = 3 SE +/- 0.14, N = 3 49.59 49.27 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 1100 2200 3300 4400 5500 SE +/- 30.10, N = 3 SE +/- 14.70, N = 3 5042 5074 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 0.5697 1.1394 1.7091 2.2788 2.8485 SE +/- 0.019, N = 3 SE +/- 0.007, N = 3 2.532 2.508 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 9K 18K 27K 36K 45K SE +/- 300.83, N = 3 SE +/- 108.95, N = 3 39499 39871 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 0.2687 0.5374 0.8061 1.0748 1.3435 SE +/- 0.007, N = 3 SE +/- 0.003, N = 3 1.194 1.186 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 9K 18K 27K 36K 45K SE +/- 232.40, N = 3 SE +/- 118.12, N = 3 41868 42171 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 2 4 6 8 10 SE +/- 0.009, N = 3 SE +/- 0.012, N = 3 8.322 8.281 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 1300 2600 3900 5200 6500 SE +/- 6.22, N = 3 SE +/- 8.94, N = 3 6009 6038 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 0.1877 0.3754 0.5631 0.7508 0.9385 SE +/- 0.002, N = 3 SE +/- 0.002, N = 3 0.834 0.833 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 300 600 900 1200 1500 SE +/- 2.30, N = 3 SE +/- 2.77, N = 3 1199 1200 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 0.0178 0.0356 0.0534 0.0712 0.089 SE +/- 0.000, N = 3 SE +/- 0.000, N = 3 0.079 0.079 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 3K 6K 9K 12K 15K SE +/- 48.94, N = 3 SE +/- 50.49, N = 3 12688 12689 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 60 120 180 240 300 SE +/- 2.40, N = 3 SE +/- 1.16, N = 3 252.22 248.08 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 200 400 600 800 1000 SE +/- 9.44, N = 3 SE +/- 4.70, N = 3 991 1008 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 15 30 45 60 75 SE +/- 0.40, N = 3 SE +/- 0.19, N = 3 66.41 65.83 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 300 600 900 1200 1500 SE +/- 9.11, N = 3 SE +/- 4.43, N = 3 1506 1519 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 3 6 9 12 15 SE +/- 0.03, N = 3 SE +/- 0.04, N = 3 13.13 13.02 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 8K 16K 24K 32K 40K SE +/- 78.91, N = 3 SE +/- 123.04, N = 3 38081 38404 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 2 4 6 8 10 SE +/- 0.061, N = 3 SE +/- 0.030, N = 3 6.308 6.306 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 8K 16K 24K 32K 40K SE +/- 384.22, N = 3 SE +/- 190.02, N = 3 39640 39645 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 0.5249 1.0498 1.5747 2.0996 2.6245 SE +/- 0.010, N = 3 SE +/- 0.001, N = 3 2.333 2.332 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 9K 18K 27K 36K 45K SE +/- 178.17, N = 3 SE +/- 11.17, N = 3 42868 42873 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 7 14 21 28 35 SE +/- 0.07, N = 3 SE +/- 0.05, N = 3 27.90 27.82 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 400 800 1200 1600 2000 SE +/- 4.48, N = 3 SE +/- 3.22, N = 3 1792 1797 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 0.2538 0.5076 0.7614 1.0152 1.269 SE +/- 0.007, N = 3 SE +/- 0.011, N = 3 1.128 1.122 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 10K 20K 30K 40K 50K SE +/- 278.40, N = 3 SE +/- 445.31, N = 3 44348 44556 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 0.0169 0.0338 0.0507 0.0676 0.0845 SE +/- 0.000, N = 3 SE +/- 0.001, N = 3 0.075 0.075 1. (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 OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 3K 6K 9K 12K 15K SE +/- 21.33, N = 3 SE +/- 123.94, N = 3 13256 13346 1. (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.org ms, Fewer Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 0.1744 0.3488 0.5232 0.6976 0.872 SE +/- 0.001, N = 3 SE +/- 0.001, N = 3 0.775 0.773 1. (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.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 300 600 900 1200 1500 SE +/- 1.23, N = 3 SE +/- 2.77, N = 3 1291 1294 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
Phoronix Test Suite v10.8.5