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.
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2111266-TJ-0XO1PTSPG50 0xO1-pts-pgbench-nightcrawler - Phoronix Test Suite 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 .
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-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: 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: 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-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: 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: 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 0.0214 0.0428 0.0642 0.0856 0.107 SE +/- 0.000, N = 3 SE +/- 0.002, N = 9 0.092 0.095 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 2K 4K 6K 8K 10K SE +/- 23.64, N = 3 SE +/- 171.82, N = 9 10847 10606 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 5 10 15 20 25 SE +/- 0.20, N = 4 SE +/- 0.24, N = 12 17.84 18.29 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 1200 2400 3600 4800 6000 SE +/- 64.85, N = 4 SE +/- 67.57, N = 12 5606 5477 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 2 4 6 8 10 SE +/- 0.040, N = 3 SE +/- 0.028, N = 3 7.666 7.830 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 7K 14K 21K 28K 35K SE +/- 173.43, N = 3 SE +/- 113.49, N = 3 32615 31930 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: 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: 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 5 10 15 20 25 SE +/- 0.17, N = 3 SE +/- 0.15, N = 3 19.54 20.82 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 5K 10K 15K 20K 25K SE +/- 230.54, N = 3 SE +/- 177.13, N = 3 25591 24020 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-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: 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 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 0.3112 0.6224 0.9336 1.2448 1.556 SE +/- 0.006, N = 3 SE +/- 0.010, N = 3 1.380 1.383 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 8K 16K 24K 32K 40K SE +/- 151.24, N = 3 SE +/- 254.98, N = 3 36244 36150 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 0.1935 0.387 0.5805 0.774 0.9675 SE +/- 0.001, N = 3 SE +/- 0.002, N = 3 0.856 0.860 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 300 600 900 1200 1500 SE +/- 1.07, N = 3 SE +/- 2.46, N = 3 1169 1163 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 4 8 12 16 20 SE +/- 0.08, N = 3 SE +/- 0.08, N = 3 14.59 14.68 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 7K 14K 21K 28K 35K SE +/- 195.44, N = 3 SE +/- 197.78, N = 3 34268 34056 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 2 4 6 8 10 SE +/- 0.013, N = 3 SE +/- 0.005, N = 3 6.861 6.924 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 8K 16K 24K 32K 40K SE +/- 70.81, N = 3 SE +/- 26.21, N = 3 36441 36108 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 30 60 90 120 150 SE +/- 1.26, N = 3 SE +/- 0.39, N = 3 112.01 112.70 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 1000 2000 3000 4000 5000 SE +/- 49.91, N = 3 SE +/- 15.14, N = 3 4465 4437 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 11 22 33 44 55 SE +/- 0.14, N = 3 SE +/- 0.30, N = 3 49.27 49.59 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 1100 2200 3300 4400 5500 SE +/- 14.70, N = 3 SE +/- 30.10, N = 3 5074 5042 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: 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: 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 0.2687 0.5374 0.8061 1.0748 1.3435 SE +/- 0.003, N = 3 SE +/- 0.007, N = 3 1.186 1.194 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 9K 18K 27K 36K 45K SE +/- 118.12, N = 3 SE +/- 232.40, N = 3 42171 41868 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: 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: 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: 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 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: 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 3K 6K 9K 12K 15K SE +/- 50.49, N = 3 SE +/- 48.94, N = 3 12689 12688 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: 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: 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: 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: 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 3 6 9 12 15 SE +/- 0.04, N = 3 SE +/- 0.03, N = 3 13.02 13.13 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 8K 16K 24K 32K 40K SE +/- 123.04, N = 3 SE +/- 78.91, N = 3 38404 38081 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 2 4 6 8 10 SE +/- 0.030, N = 3 SE +/- 0.061, N = 3 6.306 6.308 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 8K 16K 24K 32K 40K SE +/- 190.02, N = 3 SE +/- 384.22, N = 3 39645 39640 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 0.5249 1.0498 1.5747 2.0996 2.6245 SE +/- 0.001, N = 3 SE +/- 0.010, N = 3 2.332 2.333 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 9K 18K 27K 36K 45K SE +/- 11.17, N = 3 SE +/- 178.17, N = 3 42873 42868 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 7 14 21 28 35 SE +/- 0.05, N = 3 SE +/- 0.07, N = 3 27.82 27.90 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-1637795686 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 400 800 1200 1600 2000 SE +/- 3.22, N = 3 SE +/- 4.48, N = 3 1797 1792 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: 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: 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 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 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: 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
Phoronix Test Suite v10.8.4