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 .
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: 1 - 1 - Read Only pgbench: 1 - 1 - Read Only - Average Latency pgbench: 1 - 1 - Read Write pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 50 - Read Only pgbench: 1 - 50 - Read Only - Average Latency pgbench: 1 - 100 - Read Only pgbench: 1 - 100 - Read Only - Average Latency pgbench: 1 - 250 - Read Only pgbench: 1 - 250 - Read Only - Average Latency pgbench: 1 - 50 - Read Write pgbench: 1 - 50 - Read Write - Average Latency pgbench: 1 - 500 - Read Only pgbench: 1 - 500 - Read Only - Average Latency pgbench: 100 - 1 - Read Only pgbench: 100 - 1 - Read Only - Average Latency pgbench: 1 - 100 - Read Write pgbench: 1 - 100 - Read Write - Average Latency pgbench: 1 - 250 - Read Write pgbench: 1 - 250 - Read Write - Average Latency pgbench: 1 - 500 - Read Write pgbench: 1 - 500 - Read Write - Average Latency pgbench: 100 - 1 - Read Write pgbench: 100 - 1 - Read Write - Average Latency pgbench: 100 - 50 - Read Only pgbench: 100 - 50 - Read Only - Average Latency pgbench: 1000 - 1 - Read Only pgbench: 1000 - 1 - Read Only - Average Latency pgbench: 100 - 100 - Read Only pgbench: 100 - 100 - Read Only - Average Latency pgbench: 100 - 250 - Read Only pgbench: 100 - 250 - Read Only - Average Latency pgbench: 100 - 50 - Read Write pgbench: 100 - 50 - Read Write - Average Latency pgbench: 100 - 500 - Read Only pgbench: 100 - 500 - Read Only - Average Latency pgbench: 1000 - 1 - Read Write pgbench: 1000 - 1 - Read Write - Average Latency pgbench: 1000 - 50 - Read Only pgbench: 1000 - 50 - Read Only - Average Latency pgbench: 10000 - 1 - Read Only pgbench: 10000 - 1 - Read Only - Average Latency pgbench: 100 - 100 - Read Write pgbench: 100 - 100 - Read Write - Average Latency pgbench: 100 - 250 - Read Write pgbench: 100 - 250 - Read Write - Average Latency pgbench: 100 - 500 - Read Write pgbench: 100 - 500 - Read Write - Average Latency pgbench: 1000 - 100 - Read Only pgbench: 1000 - 100 - Read Only - Average Latency pgbench: 1000 - 250 - Read Only pgbench: 1000 - 250 - Read Only - Average Latency pgbench: 1000 - 50 - Read Write pgbench: 1000 - 50 - Read Write - Average Latency pgbench: 1000 - 500 - Read Only pgbench: 1000 - 500 - Read Only - Average Latency pgbench: 10000 - 1 - Read Write pgbench: 10000 - 1 - Read Write - Average Latency pgbench: 10000 - 50 - Read Only pgbench: 10000 - 50 - Read Only - Average Latency pgbench: 1000 - 100 - Read Write pgbench: 1000 - 100 - Read Write - Average Latency pgbench: 1000 - 250 - Read Write pgbench: 1000 - 250 - Read Write - Average Latency pgbench: 1000 - 500 - Read Write pgbench: 1000 - 500 - Read Write - Average Latency pgbench: 10000 - 100 - Read Only pgbench: 10000 - 100 - Read Only - Average Latency pgbench: 10000 - 250 - Read Only pgbench: 10000 - 250 - Read Only - Average Latency pgbench: 10000 - 50 - Read Write pgbench: 10000 - 50 - Read Write - Average Latency pgbench: 10000 - 500 - Read Only pgbench: 10000 - 500 - Read Only - Average Latency pgbench: 10000 - 100 - Read Write pgbench: 10000 - 100 - Read Write - Average Latency pgbench: 10000 - 250 - Read Write pgbench: 10000 - 250 - Read Write - Average Latency pgbench: 10000 - 500 - Read Write pgbench: 10000 - 500 - Read Write - Average Latency Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 13346 0.075 1294 0.773 44556 1.122 42868 2.333 39640 6.308 1792 27.895 38081 13.130 12688 0.079 1519 65.834 1008 248.083 555 901.724 1200 0.833 41868 1.194 10606 0.095 39871 2.508 36108 6.924 6038 8.281 34056 14.683 1163 0.860 36150 1.383 2528 0.396 5477 18.290 5042 49.586 4437 112.699 35201 2.841 31930 7.830 5334 9.377 24020 20.818 13256 0.075 1291 0.775 44348 1.128 42873 2.332 39645 6.306 1797 27.819 38404 13.020 12689 0.079 1506 66.409 991 252.220 546 916.220 1199 0.834 42171 1.186 10847 0.092 39499 2.532 36441 6.861 6009 8.322 34268 14.592 1169 0.856 36244 1.380 2497 0.401 5606 17.844 5074 49.272 4465 112.011 35012 2.856 32615 7.666 5085 9.832 25591 19.541 772 1.297 22228 2.250 5239 19.090 5065 49.360 4921 101.607 22376 4.469 20264 12.342 3558 15.502 16268 30.737 3626 28.697 3436 74.868 3487 144.502 OpenBenchmarking.org
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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 3K 6K 9K 12K 15K SE +/- 123.94, N = 3 SE +/- 21.33, N = 3 13346 13256 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 0.0169 0.0338 0.0507 0.0676 0.0845 SE +/- 0.001, N = 3 SE +/- 0.000, 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 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 300 600 900 1200 1500 SE +/- 2.77, N = 3 SE +/- 1.23, N = 3 1294 1291 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 0.1744 0.3488 0.5232 0.6976 0.872 SE +/- 0.001, N = 3 SE +/- 0.001, N = 3 0.773 0.775 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 10K 20K 30K 40K 50K SE +/- 445.31, N = 3 SE +/- 278.40, N = 3 44556 44348 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 0.2538 0.5076 0.7614 1.0152 1.269 SE +/- 0.011, N = 3 SE +/- 0.007, N = 3 1.122 1.128 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: 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: 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: 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: 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 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: 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: 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: 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: 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 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: 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 300 600 900 1200 1500 SE +/- 4.43, N = 3 SE +/- 9.11, N = 3 1519 1506 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 15 30 45 60 75 SE +/- 0.19, N = 3 SE +/- 0.40, N = 3 65.83 66.41 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 200 400 600 800 1000 SE +/- 4.70, N = 3 SE +/- 9.44, N = 3 1008 991 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 60 120 180 240 300 SE +/- 1.16, N = 3 SE +/- 2.40, N = 3 248.08 252.22 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 120 240 360 480 600 SE +/- 5.91, N = 12 SE +/- 4.61, N = 12 555 546 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 200 400 600 800 1000 SE +/- 9.47, N = 12 SE +/- 7.70, N = 12 901.72 916.22 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 300 600 900 1200 1500 SE +/- 2.77, N = 3 SE +/- 2.30, N = 3 1200 1199 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 0.1877 0.3754 0.5631 0.7508 0.9385 SE +/- 0.002, N = 3 SE +/- 0.002, N = 3 0.833 0.834 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 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: 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: 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: 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 9K 18K 27K 36K 45K SE +/- 108.95, N = 3 SE +/- 300.83, N = 3 39871 39499 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 0.5697 1.1394 1.7091 2.2788 2.8485 SE +/- 0.007, N = 3 SE +/- 0.019, N = 3 2.508 2.532 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: 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: 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 1300 2600 3900 5200 6500 SE +/- 8.94, N = 3 SE +/- 6.22, N = 3 6038 6009 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 2 4 6 8 10 SE +/- 0.012, N = 3 SE +/- 0.009, N = 3 8.281 8.322 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: 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: 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: 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: 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: 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: 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 500 1000 1500 2000 2500 SE +/- 8.29, N = 3 SE +/- 32.77, N = 9 2528 2497 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 0.0902 0.1804 0.2706 0.3608 0.451 SE +/- 0.001, N = 3 SE +/- 0.005, N = 9 0.396 0.401 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: 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: 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: 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: 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: 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: 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 8K 16K 24K 32K 40K SE +/- 245.81, N = 3 SE +/- 76.72, N = 3 35201 35012 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 0.6426 1.2852 1.9278 2.5704 3.213 SE +/- 0.020, N = 3 SE +/- 0.006, N = 3 2.841 2.856 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: 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: 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 1100 2200 3300 4400 5500 SE +/- 68.80, N = 3 SE +/- 17.20, N = 3 5334 5085 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-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 3 6 9 12 15 SE +/- 0.120, N = 3 SE +/- 0.033, N = 3 9.377 9.832 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: 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: 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: 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: 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: 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: 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: 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: 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 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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
Phoronix Test Suite v10.8.4