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&export=txt&grs&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: 1000 - 500 - Read Only pgbench: 1000 - 500 - Read Only - Average Latency pgbench: 1000 - 50 - Read Write pgbench: 1000 - 50 - Read Write - Average Latency pgbench: 1000 - 1 - Read Only - Average Latency pgbench: 100 - 100 - Read Write - Average Latency pgbench: 100 - 100 - Read Write pgbench: 1000 - 1 - Read Only pgbench: 1000 - 250 - Read Only pgbench: 1000 - 250 - Read Only - 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: 10000 - 1 - Read Only - Average Latency pgbench: 10000 - 1 - Read Only pgbench: 100 - 100 - Read Only - Average Latency pgbench: 100 - 100 - Read Only pgbench: 100 - 250 - Read Only pgbench: 100 - 250 - Read Only - Average Latency pgbench: 1 - 100 - Read Write - Average Latency pgbench: 1 - 100 - Read Write pgbench: 1 - 500 - Read Only pgbench: 1 - 500 - Read Only - Average Latency pgbench: 100 - 50 - Read Only pgbench: 1 - 1 - Read Only pgbench: 100 - 50 - Read Only - Average Latency pgbench: 100 - 250 - Read Write - Average Latency pgbench: 100 - 250 - Read Write pgbench: 100 - 500 - Read Write pgbench: 100 - 500 - Read Only - Average Latency pgbench: 100 - 500 - Read Only pgbench: 100 - 500 - Read Write - Average Latency pgbench: 1000 - 100 - Read Only pgbench: 1 - 50 - Read Only - Average Latency pgbench: 1000 - 100 - Read Only - Average Latency pgbench: 1000 - 1 - Read Write pgbench: 100 - 50 - Read Write - Average Latency pgbench: 100 - 50 - Read Write pgbench: 1 - 50 - Read Only pgbench: 1000 - 1 - Read Write - Average Latency pgbench: 1 - 50 - Read Write pgbench: 1 - 50 - Read Write - Average Latency pgbench: 1000 - 50 - Read Only pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 1 - Read Write pgbench: 1000 - 50 - Read Only - Average Latency pgbench: 100 - 1 - Read Write - Average Latency pgbench: 100 - 1 - Read Write pgbench: 1 - 100 - Read Only - Average Latency pgbench: 1 - 250 - Read Only - Average Latency pgbench: 1 - 250 - Read Only pgbench: 1 - 100 - Read Only pgbench: 100 - 1 - Read Only pgbench: 10000 - 500 - Read Only - Average Latency pgbench: 10000 - 500 - Read Only pgbench: 10000 - 250 - Read Only - Average Latency pgbench: 10000 - 250 - Read Only pgbench: 10000 - 100 - Read Only - Average Latency pgbench: 10000 - 100 - Read Only 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 - 100 - Read Write - Average Latency pgbench: 1000 - 100 - Read Write pgbench: 10000 - 50 - Read Only - Average Latency pgbench: 10000 - 50 - Read Only pgbench: 10000 - 1 - Read Write - Average Latency pgbench: 10000 - 1 - Read Write pgbench: 100 - 1 - Read Only - Average Latency pgbench: 1 - 1 - Read Only - Average Latency pgbench: 10000 - 500 - Read Write - Average Latency pgbench: 10000 - 500 - Read Write pgbench: 10000 - 250 - Read Write - Average Latency pgbench: 10000 - 250 - Read Write pgbench: 10000 - 100 - Read Write - Average Latency pgbench: 10000 - 100 - Read Write pgbench: 10000 - 50 - Read Write - Average Latency pgbench: 10000 - 50 - Read Write Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 24020 20.818 5334 9.377 0.095 18.290 5477 10606 31930 7.830 1008 248.083 555 901.724 0.396 2528 2.508 39871 36108 6.924 65.834 1519 38081 13.130 41868 13346 1.194 49.586 5042 4437 14.683 34056 112.699 35201 1.122 2.841 1163 8.281 6038 44556 0.860 1792 27.895 36150 0.773 1294 1.383 0.833 1200 2.333 6.308 39640 42868 12688 0.079 0.075 25591 19.541 5085 9.832 0.092 17.844 5606 10847 32615 7.666 991 252.220 546 916.220 0.401 2497 2.532 39499 36441 6.861 66.409 1506 38404 13.020 42171 13256 1.186 49.272 5074 4465 14.592 34268 112.011 35012 1.128 2.856 1169 8.322 6009 44348 0.856 1797 27.819 36244 0.775 1291 1.380 0.834 1199 2.332 6.306 39645 42873 12689 30.737 16268 12.342 20264 4.469 22376 101.607 4921 49.360 5065 19.090 5239 2.250 22228 1.297 772 0.079 0.075 144.502 3487 74.868 3436 28.697 3626 15.502 3558 OpenBenchmarking.org
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: 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 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: 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 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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 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: 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: 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: 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: 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: 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 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: 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-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: 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: 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: 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: 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: 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: 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: 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: 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: 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
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: 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: 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 - 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 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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
Phoronix Test Suite v10.8.5