jail-pgbench Intel Xeon E5-2630 v3 testing on FreeBSD 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 2410290-SCHA-JAILPGB71 Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 Processor: Intel Xeon E5-2630 v3 @ 2.40GHz (32 Cores), Motherboard: Supermicro X10DRi 123456789, Memory: 64GB, Disk: 13242GB, Audio: NVIDIA (0x0fb9) HDA
OS: FreeBSD, Kernel: 13.4-RELEASE (x86_64), Compiler: Clang 18.1.6, File-System: zfs
Security Notes: KPTI
PostgreSQL OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 20 40 60 80 100 SE +/- 2.29, N = 9 89.64 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 2K 4K 6K 8K 10K SE +/- 276.37, N = 9 11212 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 13 26 39 52 65 SE +/- 1.15, N = 9 59.19 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 900 1800 2700 3600 4500 SE +/- 79.32, N = 9 4236 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 15 30 45 60 75 SE +/- 1.52, N = 8 65.61 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 800 - Mode: Read Write Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 3K 6K 9K 12K 15K SE +/- 293.93, N = 8 12241 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 14 28 42 56 70 SE +/- 2.73, N = 8 63.30 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 2K 4K 6K 8K 10K SE +/- 364.50, N = 8 8008 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 300 600 900 1200 1500 SE +/- 32.91, N = 12 1575.95 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 140 280 420 560 700 SE +/- 13.26, N = 12 638 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 110 220 330 440 550 SE +/- 4.63, N = 12 506.06 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 500 - Mode: Read Write Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 200 400 600 800 1000 SE +/- 9.07, N = 12 989 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 0.7038 1.4076 2.1114 2.8152 3.519 SE +/- 0.031, N = 5 3.128 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 30K 60K 90K 120K 150K SE +/- 1620.16, N = 5 159883 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 200 400 600 800 1000 SE +/- 14.79, N = 9 1123.34 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 800 - Mode: Read Write Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 150 300 450 600 750 SE +/- 9.41, N = 9 713 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 2 4 6 8 10 SE +/- 0.039, N = 3 7.086 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 30K 60K 90K 120K 150K SE +/- 781.62, N = 3 141135 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 1.2384 2.4768 3.7152 4.9536 6.192 SE +/- 0.016, N = 3 5.504 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 30K 60K 90K 120K 150K SE +/- 412.87, N = 3 145351 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 0.3501 0.7002 1.0503 1.4004 1.7505 SE +/- 0.010, N = 3 1.556 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 30K 60K 90K 120K 150K SE +/- 1058.40, N = 3 160717 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 0.4772 0.9544 1.4316 1.9088 2.386 SE +/- 0.014, N = 3 2.121 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 800 - Mode: Read Only Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 80K 160K 240K 320K 400K SE +/- 2534.42, N = 3 377249 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 0.6521 1.3042 1.9563 2.6084 3.2605 SE +/- 0.012, N = 3 2.898 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 70K 140K 210K 280K 350K SE +/- 1402.86, N = 3 345064 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 0.2682 0.5364 0.8046 1.0728 1.341 SE +/- 0.008, N = 3 1.192 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 500 - Mode: Read Only Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 90K 180K 270K 360K 450K SE +/- 2836.73, N = 3 419427 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 20 40 60 80 100 SE +/- 0.48, N = 3 96.38 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 2K 4K 6K 8K 10K SE +/- 51.92, N = 3 10376 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 16 32 48 64 80 SE +/- 0.98, N = 3 72.25 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 800 - Mode: Read Write Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 2K 4K 6K 8K 10K SE +/- 147.98, N = 3 11077 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 0.1265 0.253 0.3795 0.506 0.6325 SE +/- 0.002, N = 3 0.562 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 250 - Mode: Read Only Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 100K 200K 300K 400K 500K SE +/- 1539.30, N = 3 444693 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 5 10 15 20 25 SE +/- 0.25, N = 3 22.09 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 250 - Mode: Read Write Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 2K 4K 6K 8K 10K SE +/- 125.45, N = 3 11322 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 10 20 30 40 50 SE +/- 0.56, N = 3 42.41 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 100 - Clients: 500 - Mode: Read Write Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 3K 6K 9K 12K 15K SE +/- 156.97, N = 3 11793 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 0.529 1.058 1.587 2.116 2.645 SE +/- 0.013, N = 3 2.351 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 90K 180K 270K 360K 450K SE +/- 2332.27, N = 3 425390 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 0.3958 0.7916 1.1874 1.5832 1.979 SE +/- 0.001, N = 3 1.759 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 800 - Mode: Read Only Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 100K 200K 300K 400K 500K SE +/- 122.86, N = 3 454754 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 0.2342 0.4684 0.7026 0.9368 1.171 SE +/- 0.002, N = 3 1.041 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 500 - Mode: Read Only Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 100K 200K 300K 400K 500K SE +/- 1033.61, N = 3 480296 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 40 80 120 160 200 SE +/- 2.73, N = 3 189.19 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 250 - Mode: Read Write Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 300 600 900 1200 1500 SE +/- 18.82, N = 3 1322 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 0.1136 0.2272 0.3408 0.4544 0.568 SE +/- 0.001, N = 3 0.505 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 17 Scaling Factor: 1 - Clients: 250 - Mode: Read Only Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 110K 220K 330K 440K 550K SE +/- 961.24, N = 3 494668 1. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm
Scaling Factor: 1 - Clients: 1 - Mode: Read Only
Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: ./pgbench: pg_/bin/pgbench: not found
Scaling Factor: 1 - Clients: 100 - Mode: Read Only
Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: ./pgbench: pg_/bin/pgbench: not found
Scaling Factor: 1 - Clients: 50 - Mode: Read Only
Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: ./pgbench: pg_/bin/pgbench: not found
Scaling Factor: 1 - Clients: 1 - Mode: Read Write
Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: ./pgbench: pg_/bin/pgbench: not found
Intel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789 Processor: Intel Xeon E5-2630 v3 @ 2.40GHz (32 Cores), Motherboard: Supermicro X10DRi 123456789, Memory: 64GB, Disk: 13242GB, Audio: NVIDIA (0x0fb9) HDA
OS: FreeBSD, Kernel: 13.4-RELEASE (x86_64), Compiler: Clang 18.1.6, File-System: zfs
Security Notes: KPTI
Testing initiated at 29 October 2024 06:17 by user schaichalonso.