PostgreSQL 10.3 on Ubuntu Linux

Intel Core i7-8700K testing with a ASUS PRIME Z370-A (0607 BIOS) and Intel UHD 630 3072MB on Ubuntu 16.04 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/1803016-PTS-POSTGRES24.

PostgreSQL 10.3 on Ubuntu LinuxProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay DriverOpenGLVulkanCompilerFile-SystemScreen ResolutionIntel Core i7-8700K - Intel UHD 630 3072MB - ASUSIntel Core i7-8700K @ 4.70GHz (6 Cores / 12 Threads)ASUS PRIME Z370-A (0607 BIOS)Intel Device 3ec215360MBSamsung SSD 950 PRO 256GBIntel UHD 630 3072MB (1200MHz)Realtek ALC1220DELL P2415QIntel ConnectionUbuntu 16.044.15.7-041507-generic (x86_64)Unity 7.4.5modesetting 1.19.54.5 Mesa 18.1.0-devel- padoka PPA1.0.61GCC 5.4.0 20160609ext43840x2160OpenBenchmarking.org- --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --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,ada,c++,java,go,d,fortran,objc,obj-c++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --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-default-libstdcxx-abi=new --with-multilib-list=m32,m64,mx32 --with-tune=generic -v - Scaling Governor: intel_pstate powersave- KPTI + __user pointer sanitization + Full generic retpoline Protection

PostgreSQL 10.3 on Ubuntu Linuxpgbench: Mostly RAM - Normal Load - Read Onlypgbench: Buffer Test - Normal Load - Read Onlypgbench: Mostly RAM - Normal Load - Read Writepgbench: Buffer Test - Normal Load - Read WriteIntel Core i7-8700K - Intel UHD 630 3072MB - ASUS125665.47179632.261343.031726.08OpenBenchmarking.org

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read OnlyIntel Core i7-8700K - Intel UHD 630 3072MB - ASUS30K60K90K120K150KSE +/- 283.12, N = 3125665.471. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Normal Load - Mode: Read OnlyIntel Core i7-8700K - Intel UHD 630 3072MB - ASUS40K80K120K160K200KSE +/- 372.52, N = 3179632.261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read WriteIntel Core i7-8700K - Intel UHD 630 3072MB - ASUS30060090012001500SE +/- 25.17, N = 31343.031. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Normal Load - Mode: Read WriteIntel Core i7-8700K - Intel UHD 630 3072MB - ASUS400800120016002000SE +/- 43.43, N = 61726.081. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

Phoronix Test Suite v10.8.5