Running pts/pgbench-1.5.2 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 1511249-KH-HARRISONJ67 Harrison John - Phoronix Test Suite Harrison John Running pts/pgbench-1.5.2 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/1511249-KH-HARRISONJ67&grr&export=txt&rdt&rro .
Harrison John Processor Motherboard Chipset Memory Disk Graphics Audio Network OS Kernel Desktop Display Server Display Driver OpenGL Compiler File-System Screen Resolution Benchmarking-Databases SQLITE Benchmarked Postgre Database Benchmarked Intel Pentium Dual T2370 @ 1.73GHz (2 Cores) Sony VAIO Intel Mobile PM965/GM965/GL960 + ICH8M 2560MB 160GB Seagate ST9160821AS Intel Mobile GM965/GL960 IGP (primary) Intel 82801H Marvell 88E8039 PCI-E Fast Ubuntu 14.04 3.19.0-33-generic (x86_64) Unity 7.2.5 X Server 1.17.1 intel 2.99.917 2.1 Mesa 10.5.9 GCC 4.8.4 ext4 1280x800 OpenBenchmarking.org Compiler Details - --build=x86_64-linux-gnu --disable-browser-plugin --disable-libmudflap --disable-werror --enable-checking=release --enable-clocale=gnu --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,c++,java,go,d,fortran,objc,obj-c++ --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-objc-gc --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-arch-directory=amd64 --with-multilib-list=m32,m64,mx32 --with-tune=generic -v Disk Details - Benchmarking-Databases, SQLITE Benchmarked: DEADLINE / data=ordered,errors=remount-ro,relatime,rw Processor Details - Scaling Governor: acpi-cpufreq ondemand System Details - Benchmarking-Databases, SQLITE Benchmarked: Disk Scheduler: DEADLINE.
Harrison John pgbench: Buffer Test - Heavy Contention - Read Write pgbench: Mostly RAM - Heavy Contention - Read Write pgbench: Buffer Test - Heavy Contention - Read Only pgbench: Mostly RAM - Heavy Contention - Read Only pgbench: Buffer Test - Single Thread - Read Write pgbench: On-Disk - Heavy Contention - Read Write pgbench: Mostly RAM - Single Thread - Read Write pgbench: Buffer Test - Single Thread - Read Only pgbench: On-Disk - Heavy Contention - Read Only pgbench: Mostly RAM - Single Thread - Read Only pgbench: Buffer Test - Normal Load - Read Write pgbench: Mostly RAM - Normal Load - Read Write pgbench: Buffer Test - Normal Load - Read Only pgbench: On-Disk - Single Thread - Read Write pgbench: Mostly RAM - Normal Load - Read Only pgbench: On-Disk - Single Thread - Read Only pgbench: On-Disk - Normal Load - Read Write pgbench: On-Disk - Normal Load - Read Only sqlite: Default Test Directory sqlite: Timed SQLite Insertions Benchmarking-Databases SQLITE Benchmarked Postgre Database Benchmarked 499.82 514.00 258.84 195.56 6579.76 5475.59 69.40 512.12 75.71 4275.87 8888.71 3723.95 190.85 181.52 6969.66 33.44 5736.98 5064.15 335.19 9682.65 OpenBenchmarking.org
PostgreSQL pgbench Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write Postgre Database Benchmarked 60 120 180 240 300 SE +/- 2.55, N = 3 258.84 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write Postgre Database Benchmarked 40 80 120 160 200 SE +/- 2.77, N = 3 195.56 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only Postgre Database Benchmarked 1400 2800 4200 5600 7000 SE +/- 30.53, N = 3 6579.76 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only Postgre Database Benchmarked 1200 2400 3600 4800 6000 SE +/- 14.69, N = 3 5475.59 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Single Thread - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: Buffer Test - Test: Single Thread - Mode: Read Write Postgre Database Benchmarked 15 30 45 60 75 SE +/- 0.63, N = 3 69.40 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write Postgre Database Benchmarked 110 220 330 440 550 SE +/- 1.87, N = 3 512.12 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write Postgre Database Benchmarked 20 40 60 80 100 SE +/- 2.98, N = 6 75.71 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Single Thread - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: Buffer Test - Test: Single Thread - Mode: Read Only Postgre Database Benchmarked 900 1800 2700 3600 4500 SE +/- 33.61, N = 3 4275.87 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only Postgre Database Benchmarked 2K 4K 6K 8K 10K SE +/- 51.37, N = 3 8888.71 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only Postgre Database Benchmarked 800 1600 2400 3200 4000 SE +/- 9.04, N = 3 3723.95 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Normal Load - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Write Postgre Database Benchmarked 40 80 120 160 200 SE +/- 2.56, N = 6 190.85 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write Postgre Database Benchmarked 40 80 120 160 200 SE +/- 3.00, N = 3 181.52 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Buffer Test - Test: Normal Load - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Only Postgre Database Benchmarked 1500 3000 4500 6000 7500 SE +/- 10.67, N = 3 6969.66 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: On-Disk - Test: Single Thread - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Write Postgre Database Benchmarked 8 16 24 32 40 SE +/- 3.47, N = 6 33.44 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only Postgre Database Benchmarked 1200 2400 3600 4800 6000 SE +/- 67.94, N = 3 5736.98 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: On-Disk - Test: Single Thread - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Only Postgre Database Benchmarked 1100 2200 3300 4400 5500 SE +/- 87.49, N = 3 5064.15 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: On-Disk - Test: Normal Load - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: On-Disk - Test: Normal Load - Mode: Read Write Postgre Database Benchmarked 70 140 210 280 350 SE +/- 2.26, N = 3 335.19 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
PostgreSQL pgbench Scaling: On-Disk - Test: Normal Load - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 9.4.3 Scaling: On-Disk - Test: Normal Load - Mode: Read Only Postgre Database Benchmarked 2K 4K 6K 8K 10K SE +/- 59.05, N = 3 9682.65 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
SQLite Test Target: Default Test Directory OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.8.10.2 Test Target: Default Test Directory SQLITE Benchmarked 110 220 330 440 550 SE +/- 3.03, N = 3 514.00 1. (CC) gcc options: -O2 -ldl -lpthread
SQLite Timed SQLite Insertions OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.8.10.2 Timed SQLite Insertions Benchmarking-Databases 110 220 330 440 550 SE +/- 2.71, N = 3 499.82 1. (CC) gcc options: -O2 -ldl -lpthread
Phoronix Test Suite v10.8.4