pgbench-test

2 x Intel Xeon E5-2665 0 testing with a Dell 0C4Y3R (1.6.0 BIOS) and Matrox G200eR2 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 2402129-KORC-PGBENCH33
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs
Condense Test Profiles With Multiple Version Results Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell
February 12
  2 Hours, 16 Minutes
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):


{ "title": "pgbench-test", "last_modified": "2024-02-13 02:47:13", "description": "2 x Intel Xeon E5-2665 0 testing with a Dell 0C4Y3R (1.6.0 BIOS) and Matrox G200eR2 on Ubuntu 20.04 via the Phoronix Test Suite.", "systems": { "2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell": { "identifier": "2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell", "hardware": { "Processor": "2 x Intel Xeon E5-2665 0 @ 3.10GHz (16 Cores \/ 32 Threads)", "Motherboard": "Dell 0C4Y3R (1.6.0 BIOS)", "Chipset": "Intel Xeon E5\/Core", "Memory": "64GB", "Disk": "1999GB PERC H710P + 2GB Internal Dual SD", "Graphics": "Matrox G200eR2", "Audio": "NVIDIA Device 228b", "Monitor": "DELL P2414H", "Network": "4 x Broadcom NetXtreme BCM5720 2-port PCIe" }, "software": { "OS": "Ubuntu 20.04", "Kernel": "5.4.0-171-generic (x86_64)", "Vulkan": "1.1.182", "Compiler": "GCC 9.4.0", "File-System": "ext4", "Screen Resolution": "1600x900" }, "user": "korciuch", "timestamp": "2024-02-12 23:31:10", "client_version": "10.8.4", "data": { "compiler-configuration": "--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-9QDOt0\/gcc-9-9.4.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", "cpu-scaling-governor": "intel_pstate powersave", "cpu-microcode": "0x71a", "kernel-extra-details": "Transparent Huge Pages: madvise", "security": "gather_data_sampling: Not affected + itlb_multihit: KVM: Mitigation of Split huge pages + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + mmio_stale_data: Unknown: No mitigations + retbleed: 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 Retpolines IBPB: conditional IBRS_FW STIBP: conditional RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected" } } }, "results": { "c9e9d6cc0f11bd6b0ee4f75c6d0c648f4b2f562c": { "identifier": "pts\/pgbench-1.13.0", "title": "PostgreSQL", "app_version": "15", "arguments": "-s 1000 -c 100 -S", "description": "Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency", "scale": "ms", "proportion": "LIB", "display_format": "BAR_GRAPH", "results": { "2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell": { "value": 0.334000000000000019095836023552692495286464691162109375, "raw_values": [ 0.334000000000000019095836023552692495286464691162109375, 0.335000000000000019984014443252817727625370025634765625, 0.334000000000000019095836023552692495286464691162109375 ], "test_run_times": [ 334.44999999999998863131622783839702606201171875, 338.259999999999990905052982270717620849609375, 335.69999999999998863131622783839702606201171875 ], "details": { "compiler-options": { "compiler-type": "CC", "compiler": "gcc", "compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm" } } } } }, "974e8a384b4b19717c31399d3e7172baf150b3ff": { "identifier": "pts\/pgbench-1.13.0", "title": "PostgreSQL", "app_version": "15", "arguments": "-s 1000 -c 100 -S", "description": "Scaling Factor: 1000 - Clients: 100 - Mode: Read Only", "scale": "TPS", "proportion": "HIB", "display_format": "BAR_GRAPH", "results": { "2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell": { "value": 299150, "raw_values": [ 299113.85178999998606741428375244140625, 298948.95321800000965595245361328125, 299386.439714999985881149768829345703125 ], "test_run_times": [ 334.44999999999998863131622783839702606201171875, 338.259999999999990905052982270717620849609375, 335.69999999999998863131622783839702606201171875 ], "details": { "compiler-options": { "compiler-type": "CC", "compiler": "gcc", "compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm" } } } } }, "244033b479c17d1edf3b767232146a497d06c252": { "identifier": "pts\/pgbench-1.13.0", "title": "PostgreSQL", "app_version": "15", "arguments": "-s 1000 -c 100", "description": "Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency", "scale": "ms", "proportion": "LIB", "display_format": "BAR_GRAPH", "results": { "2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell": { "value": 120.6689999999999969304553815163671970367431640625, "raw_values": [ 133.4279999999999972715158946812152862548828125, 102.3190000000000026147972675971686840057373046875, 102.090000000000003410605131648480892181396484375, 138.835000000000007958078640513122081756591796875, 104.058999999999997498889570124447345733642578125, 133.40199999999998681232682429254055023193359375, 103.796999999999997044142219237983226776123046875, 134.4470000000000027284841053187847137451171875, 133.64199999999999590727384202182292938232421875 ], "test_run_times": [ 333.3500000000000227373675443232059478759765625, 333.56999999999999317878973670303821563720703125, 332.6200000000000045474735088646411895751953125, 338.19999999999998863131622783839702606201171875, 334.69999999999998863131622783839702606201171875, 339.8500000000000227373675443232059478759765625, 337.029999999999972715158946812152862548828125, 334.73000000000001818989403545856475830078125, 336.93999999999999772626324556767940521240234375 ], "details": { "compiler-options": { "compiler-type": "CC", "compiler": "gcc", "compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm" } } } } }, "9d1256c5ccd0a37ccfad0d8806f9746b6ee882d5": { "identifier": "pts\/pgbench-1.13.0", "title": "PostgreSQL", "app_version": "15", "arguments": "-s 1000 -c 100", "description": "Scaling Factor: 1000 - Clients: 100 - Mode: Read Write", "scale": "TPS", "proportion": "HIB", "display_format": "BAR_GRAPH", "results": { "2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell": { "value": 844, "raw_values": [ 749.467008999999961815774440765380859375, 977.3317789999999831707100383937358856201171875, 979.526736000000028070644475519657135009765625, 720.27719200000001364969648420810699462890625, 960.98910999999998239218257367610931396484375, 749.6149209999999811770976521074771881103515625, 963.421771000000035201082937419414520263671875, 743.78598899999997229315340518951416015625, 748.26843899999994391691870987415313720703125 ], "test_run_times": [ 333.3500000000000227373675443232059478759765625, 333.56999999999999317878973670303821563720703125, 332.6200000000000045474735088646411895751953125, 338.19999999999998863131622783839702606201171875, 334.69999999999998863131622783839702606201171875, 339.8500000000000227373675443232059478759765625, 337.029999999999972715158946812152862548828125, 334.73000000000001818989403545856475830078125, 336.93999999999999772626324556767940521240234375 ], "details": { "compiler-options": { "compiler-type": "CC", "compiler": "gcc", "compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm" } } } } }, "4eca471d9884b2a5199437c606087712cee4bad1": { "identifier": "pts\/pgbench-1.14.0", "title": "PostgreSQL", "app_version": "16", "arguments": "-s 1000 -c 100", "description": "Scaling Factor: 1000 - Clients: 100 - Mode: Read Write", "scale": "TPS", "proportion": "HIB", "display_format": "BAR_GRAPH", "results": { "2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell": { "test_run_times": [ 10.0099999999999997868371792719699442386627197265625, 10.0099999999999997868371792719699442386627197265625, 10.0099999999999997868371792719699442386627197265625 ], "details": { "error": "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: 21: pg_\/bin\/pgbench: not found" } } } }, "59585e41878dd78d0b1c8d474bb0bd747fae08c2": { "identifier": "pts\/pgbench-1.14.0", "title": "PostgreSQL", "app_version": "16", "arguments": "-s 1000 -c 100 -S", "description": "Scaling Factor: 1000 - Clients: 100 - Mode: Read Only", "scale": "TPS", "proportion": "HIB", "display_format": "BAR_GRAPH", "results": { "2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell": { "test_run_times": [ 11.0299999999999993605115378159098327159881591796875, 10.0099999999999997868371792719699442386627197265625, 10.0099999999999997868371792719699442386627197265625 ], "details": { "error": "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: 21: pg_\/bin\/pgbench: not found" } } } } } }