Postgre
Intel Core i5-8400 testing with a ASUS PRIME H310-PLUS (2601 BIOS) and ASUS Intel UHD 630 CFL GT2 16GB on Debian 12 via the Phoronix Test Suite.
default
Processor: Intel Core i5-8400 @ 4.00GHz (6 Cores), Motherboard: ASUS PRIME H310-PLUS (2601 BIOS), Chipset: Intel Cannon Lake PCH, Memory: 2 x 8GB DDR4-2133MT/s Corsair CMK16GX4M2A2666C16, Disk: 256GB ADATA SX8200PNP + 120GB KINGSTON SA400S3 + 1000GB Seagate ST1000NM0008-2F2 + 500GB Western Digital WD5000AACS-0 + 62GB DataTraveler 3.0, Graphics: ASUS Intel UHD 630 CFL GT2 16GB (1050MHz), Audio: Intel Cannon Lake PCH cAVS, Monitor: SyncMaster + LG FULL HD, Network: Realtek RTL8111/8168/8411
OS: Debian 12, Kernel: 6.7.5 (x86_64), Desktop: Cinnamon 5.6.8, Display Server: X Server 1.21.1.7, OpenGL: 4.6 Mesa 22.3.6, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 3200x1080
Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-cet --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-defaulted --enable-offload-targets=nvptx-none=/build/gcc-12-bTRWOB/gcc-12-12.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-12-bTRWOB/gcc-12-12.2.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-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 Notes: Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0xf4
Security Notes: gather_data_sampling: Mitigation of Microcode + itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT disabled + mds: Mitigation of Clear buffers; SMT disabled + meltdown: Mitigation of PTI + mmio_stale_data: Mitigation of Clear buffers; SMT disabled + 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: disabled RSB filling PBRSB-eIBRS: Not affected + srbds: Mitigation of Microcode + tsx_async_abort: Not affected
PostgreSQL
This is a benchmark of PostgreSQL using the integrated pgbench for facilitating the database benchmarks. Learn more via the OpenBenchmarking.org test page.
default
Processor: Intel Core i5-8400 @ 4.00GHz (6 Cores), Motherboard: ASUS PRIME H310-PLUS (2601 BIOS), Chipset: Intel Cannon Lake PCH, Memory: 2 x 8GB DDR4-2133MT/s Corsair CMK16GX4M2A2666C16, Disk: 256GB ADATA SX8200PNP + 120GB KINGSTON SA400S3 + 1000GB Seagate ST1000NM0008-2F2 + 500GB Western Digital WD5000AACS-0 + 62GB DataTraveler 3.0, Graphics: ASUS Intel UHD 630 CFL GT2 16GB (1050MHz), Audio: Intel Cannon Lake PCH cAVS, Monitor: SyncMaster + LG FULL HD, Network: Realtek RTL8111/8168/8411
OS: Debian 12, Kernel: 6.7.5 (x86_64), Desktop: Cinnamon 5.6.8, Display Server: X Server 1.21.1.7, OpenGL: 4.6 Mesa 22.3.6, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 3200x1080
Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-cet --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-defaulted --enable-offload-targets=nvptx-none=/build/gcc-12-bTRWOB/gcc-12-12.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-12-bTRWOB/gcc-12-12.2.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-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 Notes: Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0xf4
Security Notes: gather_data_sampling: Mitigation of Microcode + itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT disabled + mds: Mitigation of Clear buffers; SMT disabled + meltdown: Mitigation of PTI + mmio_stale_data: Mitigation of Clear buffers; SMT disabled + 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: disabled RSB filling PBRSB-eIBRS: Not affected + srbds: Mitigation of Microcode + tsx_async_abort: Not affected
Testing initiated at 22 April 2024 12:39 by user dmitriy5335.