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&sro&export=txt&gru .
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 Write pgbench: 1 - 50 - Read Only pgbench: 1 - 100 - Read Only pgbench: 1 - 250 - Read Only pgbench: 1 - 50 - Read Write pgbench: 1 - 500 - Read Only pgbench: 100 - 1 - Read Only pgbench: 1 - 100 - Read Write pgbench: 1 - 250 - Read Write pgbench: 1 - 500 - Read Write pgbench: 100 - 1 - Read Write pgbench: 100 - 50 - Read Only pgbench: 1000 - 1 - Read Only pgbench: 100 - 100 - Read Only pgbench: 100 - 250 - Read Only pgbench: 100 - 50 - Read Write pgbench: 100 - 500 - Read Only pgbench: 1000 - 1 - Read Write pgbench: 1000 - 50 - Read Only pgbench: 10000 - 1 - Read Only pgbench: 100 - 100 - Read Write pgbench: 100 - 250 - Read Write pgbench: 100 - 500 - Read Write pgbench: 1000 - 100 - Read Only pgbench: 1000 - 250 - Read Only pgbench: 1000 - 50 - Read Write pgbench: 1000 - 500 - Read Only pgbench: 10000 - 1 - Read Write pgbench: 10000 - 50 - Read Only pgbench: 1000 - 100 - Read Write pgbench: 1000 - 250 - Read Write pgbench: 1000 - 500 - Read Write pgbench: 10000 - 100 - Read Only pgbench: 10000 - 250 - Read Only pgbench: 10000 - 50 - Read Write pgbench: 10000 - 500 - Read Only pgbench: 10000 - 100 - Read Write pgbench: 10000 - 250 - Read Write pgbench: 10000 - 500 - Read Write pgbench: 1 - 1 - Read Only - Average Latency pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 50 - Read Only - Average Latency pgbench: 1 - 100 - Read Only - Average Latency pgbench: 1 - 250 - Read Only - Average Latency pgbench: 1 - 50 - Read Write - Average Latency pgbench: 1 - 500 - Read Only - Average Latency pgbench: 100 - 1 - Read Only - Average Latency pgbench: 1 - 100 - Read Write - Average Latency pgbench: 1 - 250 - Read Write - Average Latency pgbench: 1 - 500 - Read Write - Average Latency pgbench: 100 - 1 - Read Write - Average Latency pgbench: 100 - 50 - Read Only - Average Latency pgbench: 1000 - 1 - Read Only - Average Latency pgbench: 100 - 100 - Read Only - Average Latency pgbench: 100 - 250 - Read Only - Average Latency pgbench: 100 - 50 - Read Write - Average Latency pgbench: 100 - 500 - Read Only - Average Latency pgbench: 1000 - 1 - Read Write - Average Latency pgbench: 1000 - 50 - Read Only - Average Latency pgbench: 10000 - 1 - Read Only - Average Latency pgbench: 100 - 100 - Read Write - Average Latency pgbench: 100 - 250 - Read Write - Average Latency pgbench: 100 - 500 - Read Write - Average Latency pgbench: 1000 - 100 - Read Only - Average Latency pgbench: 1000 - 250 - Read Only - Average Latency pgbench: 1000 - 50 - Read Write - Average Latency pgbench: 1000 - 500 - Read Only - Average Latency pgbench: 10000 - 1 - Read Write - Average Latency pgbench: 10000 - 50 - Read Only - Average Latency pgbench: 1000 - 100 - Read Write - Average Latency pgbench: 1000 - 250 - Read Write - Average Latency pgbench: 1000 - 500 - Read Write - Average Latency pgbench: 10000 - 100 - Read Only - Average Latency pgbench: 10000 - 250 - Read Only - Average Latency pgbench: 10000 - 50 - Read Write - Average Latency pgbench: 10000 - 500 - Read Only - Average Latency pgbench: 10000 - 100 - Read Write - Average Latency pgbench: 10000 - 250 - Read Write - Average Latency 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 1294 44556 42868 39640 1792 38081 12688 1519 1008 555 1200 41868 10606 39871 36108 6038 34056 1163 36150 2528 5477 5042 4437 35201 31930 5334 24020 0.075 0.773 1.122 2.333 6.308 27.895 13.130 0.079 65.834 248.083 901.724 0.833 1.194 0.095 2.508 6.924 8.281 14.683 0.860 1.383 0.396 18.290 49.586 112.699 2.841 7.830 9.377 20.818 13256 1291 44348 42873 39645 1797 38404 12689 1506 991 546 1199 42171 10847 39499 36441 6009 34268 1169 36244 2497 5606 5074 4465 35012 32615 5085 25591 772 22228 5239 5065 4921 22376 20264 3558 16268 3626 3436 3487 0.075 0.775 1.128 2.332 6.306 27.819 13.020 0.079 66.409 252.220 916.220 0.834 1.186 0.092 2.532 6.861 8.322 14.592 0.856 1.380 0.401 17.844 49.272 112.011 2.856 7.666 9.832 19.541 1.297 2.250 19.090 49.360 101.607 4.469 12.342 15.502 30.737 28.697 74.868 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 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: 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: 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: 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: 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: 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: 100 - Clients: 1 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 3K 6K 9K 12K 15K SE +/- 48.94, N = 3 SE +/- 50.49, N = 3 12688 12689 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 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: 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: 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: 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: 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: 1000 - Clients: 1 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 2K 4K 6K 8K 10K SE +/- 171.82, N = 9 SE +/- 23.64, N = 3 10606 10847 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 100 - Mode: Read 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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 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: 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: 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: 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: 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: 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: 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: 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 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 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 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: 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 - 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 - 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 - 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: 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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