pgbench_more

E3-1245V5-1

HTML result view exported from: https://openbenchmarking.org/result/2311200-NE-2311196NE94&grt&rdt.

pgbench_moreProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDisplay ServerOpenGLVulkanCompilerFile-SystemScreen ResolutionDesktopIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-1Intel Xeon E3-1225 V2 @ 2.50GHz (4 Cores)Gigabyte H61M-DS2 (F7 BIOS)Intel Xeon E3-1200 v2/Ivy16GB256GB HYS256Gigabyte Intel Xeon E3-1200 v2/3rd Gen Core (1250MHz)Realtek ALC887-VDRealtek RTL8111/8168/8411Kylin v105.10.0-8-generic (x86_64)X Server 1.20.94.2 Mesa 20.2.61.2.145GCC 9.3.0ext41920x1080Loongson-3A6000-HV @ 2.50GHz (4 Cores / 8 Threads)O.E.M (Loongson-UDK2018-V4.0.05569-stable202308 BIOS)Loongson LLC Hyper Transport BridgeSSD 512GBllvmpipeLoongson LLC Device 7a37Loongnix 204.19.0-19-loongson-3 (loongarch64)X Server 1.20.43.3 Mesa 18.3.6 (LLVM 8.0 256 bits)GCC 8.3.0xfs1536x864Intel Xeon E3-1245 v5 @ 3.50GHz (4 Cores / 8 Threads)Colorful And Development C.B250M-D (5.12 BIOS)Intel Xeon E3-1200 v5/E3-1500 + B250ZGJOLONG 990 PLUS 512GBllvmpipe (1150MHz)Realtek ALC662 rev3Ubuntu 22.046.2.0-36-generic (x86_64)GNOME Shell 42.5X Server 1.21.1.34.5 Mesa 22.2.5 (LLVM 15.0.6 256 bits)1.3.224GCC 11.4.0ext41280x720Intel Xeon E3-1245 v5 @ 3.90GHz (4 Cores / 8 Threads)OpenBenchmarking.orgKernel Details- Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200: Transparent Huge Pages: madvise- 3A6000: Transparent Huge Pages: always- E3-1345V5: Transparent Huge Pages: madvise- E3-1245V5-1: Transparent Huge Pages: madviseEnvironment Details- Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200: ZLOG_PROFILE_DEBUG=/var/log/xtx/zlog_debug.logCompiler Details- Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200: --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,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 - 3A6000: --build=loongarch64-linux-gnu --disable-emultls --disable-host-shared --disable-libitm --disable-libquadmath --disable-libquadmath-support --disable-libsanitizer --disable-werror --enable-checking=release --enable-clocale=gnu --enable-gnu-unique-object --enable-languages=c,c++,fortran --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-plugin --enable-shared --enable-threads=posix --enable-tls --host=loongarch64-linux-gnu --program-prefix=loongarch64-linux-gnu- --target=loongarch64-linux-gnu --with-abi=lp64 --with-arch=loongarch64 --with-default-libstdcxx-abi=new --with-gcc-major-version-only -v - E3-1345V5: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-cet --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++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-serialization=2 --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-11-XeT9lY/gcc-11-11.4.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-XeT9lY/gcc-11-11.4.0/debian/tmp-gcn/usr --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-build-config=bootstrap-lto-lean --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 - E3-1245V5-1: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-cet --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++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-serialization=2 --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-11-XeT9lY/gcc-11-11.4.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-XeT9lY/gcc-11-11.4.0/debian/tmp-gcn/usr --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-build-config=bootstrap-lto-lean --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- Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200: Scaling Governor: intel_cpufreq schedutil - CPU Microcode: 0x21- 3A6000: Scaling Governor: acpi-cpufreq performance- E3-1345V5: Scaling Governor: intel_pstate performance (EPP: performance) - CPU Microcode: 0xf0 - Thermald 2.4.9- E3-1245V5-1: Scaling Governor: intel_pstate performance (EPP: performance) - CPU Microcode: 0xf0 - Thermald 2.4.9Security Details- Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200: itlb_multihit: KVM: Mitigation of VMX unsupported + l1tf: Mitigation of PTE Inversion + mds: Mitigation of Clear buffers; SMT disabled + meltdown: Mitigation of PTI + 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 generic retpoline IBPB: conditional IBRS_FW STIBP: disabled RSB filling + srbds: Vulnerable: No microcode + tsx_async_abort: Not affected - E3-1345V5: gather_data_sampling: Not affected + itlb_multihit: KVM: Mitigation of VMX disabled + 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: Mitigation of Clear buffers; SMT vulnerable + retbleed: Mitigation of IBRS + spec_rstack_overflow: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of IBRS IBPB: conditional STIBP: conditional RSB filling PBRSB-eIBRS: Not affected + srbds: Mitigation of Microcode + tsx_async_abort: Mitigation of TSX disabled - E3-1245V5-1: gather_data_sampling: Not affected + itlb_multihit: KVM: Mitigation of VMX disabled + 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: Mitigation of Clear buffers; SMT vulnerable + retbleed: Mitigation of IBRS + spec_rstack_overflow: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of IBRS IBPB: conditional STIBP: conditional RSB filling PBRSB-eIBRS: Not affected + srbds: Mitigation of Microcode + tsx_async_abort: Mitigation of TSX disabled

pgbench_morepgbench: 1 - 50 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 500 - Read Writepgbench: 1 - 500 - Read Write - Average Latencypgbench: 1 - 1000 - Read Writepgbench: 1 - 1000 - Read Write - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 100 - Read Writepgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 500 - Read Writepgbench: 100 - 500 - Read Write - Average Latencypgbench: 1000 - 50 - Read Writepgbench: 1000 - 50 - Read Write - Average Latencypgbench: 100 - 1000 - Read Writepgbench: 100 - 1000 - Read Write - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 100 - Read Write - Average Latencypgbench: 1000 - 500 - Read Writepgbench: 1000 - 500 - Read Write - Average Latencypgbench: 1000 - 1000 - Read Writepgbench: 1000 - 1000 - Read Write - Average LatencyIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-1112644.514973102.8663171582.7951436996.742214923.964211148.4591614311.842183527.2621809559.874168559.7111699298.4361774564.030256319.513220745.304740676.1182913463.691126743.973123738.100834959.975450211.2515589178.980431923.2814543110.0775028198.90289356.006868115.1714681078.4552354281.716469111.368551818.200611681.785235221.3983736269.220162762.8771370375.80585058.818835119.7514751052.5042364252.832435911.765519319.256558889.581136737.8491866550.056122183.6151159440.2311462697.038OpenBenchmarking.org

PostgreSQL

Scaling Factor: 1 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read WriteIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-15001000150020002500SE +/- 16.09, N = 12SE +/- 13.05, N = 3SE +/- 1.66, N = 3SE +/- 0.59, N = 311262563893850-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average LatencyIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-11326395265SE +/- 0.63, N = 12SE +/- 0.10, N = 3SE +/- 0.10, N = 3SE +/- 0.04, N = 344.5119.5156.0158.82-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1 - Clients: 100 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read WriteIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-15001000150020002500SE +/- 10.43, N = 12SE +/- 7.56, N = 3SE +/- 7.76, N = 3SE +/- 0.92, N = 39732207868835-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average LatencyIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-1306090120150SE +/- 1.14, N = 12SE +/- 0.16, N = 3SE +/- 1.03, N = 3SE +/- 0.13, N = 3102.8745.30115.17119.75-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1 - Clients: 500 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read WriteIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-1160320480640800SE +/- 5.27, N = 12SE +/- 4.25, N = 3SE +/- 15.62, N = 9SE +/- 5.09, N = 3317740468475-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average LatencyIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-130060090012001500SE +/- 26.38, N = 12SE +/- 3.88, N = 3SE +/- 39.09, N = 9SE +/- 11.16, N = 31582.80676.121078.461052.50-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1 - Clients: 1000 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1000 - Mode: Read WriteIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-160120180240300SE +/- 2.38, N = 12SE +/- 7.49, N = 12SE +/- 5.90, N = 12SE +/- 3.86, N = 12143291235236-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average LatencyIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-115003000450060007500SE +/- 120.27, N = 12SE +/- 92.20, N = 12SE +/- 101.90, N = 12SE +/- 68.31, N = 126996.743463.694281.724252.83-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read WriteIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-13K6K9K12K15KSE +/- 111.17, N = 12SE +/- 320.58, N = 12SE +/- 484.56, N = 12SE +/- 244.73, N = 1221491267446914359-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average LatencyIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-1612182430SE +/- 1.248, N = 12SE +/- 0.103, N = 12SE +/- 0.640, N = 12SE +/- 0.483, N = 1223.9643.97311.36811.765-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 100 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read WriteIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-13K6K9K12K15KSE +/- 99.04, N = 12SE +/- 174.64, N = 12SE +/- 118.22, N = 12SE +/- 15.78, N = 321111237355185193-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average LatencyIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-11122334455SE +/- 2.157, N = 12SE +/- 0.117, N = 12SE +/- 0.332, N = 12SE +/- 0.059, N = 348.4598.10018.20019.256-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 500 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read WriteIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-12K4K6K8K10KSE +/- 47.42, N = 9SE +/- 100.75, N = 12SE +/- 87.80, N = 3SE +/- 59.18, N = 121614834961165588-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average LatencyIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-170140210280350SE +/- 8.85, N = 9SE +/- 0.66, N = 12SE +/- 1.16, N = 3SE +/- 0.94, N = 12311.8459.9881.7989.58-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read WriteIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-110002000300040005000SE +/- 21.53, N = 3SE +/- 186.51, N = 9SE +/- 66.00, N = 9SE +/- 88.68, N = 91835450223521367-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average LatencyIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-1918273645SE +/- 0.32, N = 3SE +/- 0.44, N = 9SE +/- 0.64, N = 9SE +/- 2.52, N = 927.2611.2521.4037.85-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 1000 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1000 - Mode: Read WriteIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-112002400360048006000SE +/- 67.85, N = 9SE +/- 68.62, N = 3SE +/- 85.84, N = 12SE +/- 104.35, N = 91809558937361866-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average LatencyIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-1120240360480600SE +/- 23.56, N = 9SE +/- 2.22, N = 3SE +/- 6.12, N = 12SE +/- 31.61, N = 9559.87178.98269.22550.06-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 100 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read WriteIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-19001800270036004500SE +/- 57.02, N = 6SE +/- 122.45, N = 9SE +/- 83.95, N = 9SE +/- 58.95, N = 91685431916271221-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average LatencyIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-120406080100SE +/- 2.06, N = 6SE +/- 0.57, N = 9SE +/- 3.51, N = 9SE +/- 4.60, N = 959.7123.2862.8883.62-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 500 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 500 - Mode: Read WriteIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-110002000300040005000SE +/- 69.49, N = 9SE +/- 38.26, N = 3SE +/- 86.51, N = 9SE +/- 59.06, N = 91699454313701159-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average LatencyIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1345V5E3-1245V5-1100200300400500SE +/- 12.89, N = 9SE +/- 0.92, N = 3SE +/- 21.80, N = 9SE +/- 22.32, N = 9298.44110.08375.81440.23-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1000 - Mode: Read WriteIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1245V5-111002200330044005500SE +/- 25.52, N = 3SE +/- 31.03, N = 3SE +/- 84.27, N = 6177450281462-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average LatencyIntel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-12003A6000E3-1245V5-1150300450600750SE +/- 8.16, N = 3SE +/- 1.23, N = 3SE +/- 44.95, N = 6564.03198.90697.04-lpthread -lrt -ldl-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Phoronix Test Suite v10.8.5