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.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 1803016-PTS-POSTGRES24
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

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
Intel Core i7-8700K - Intel UHD 630 3072MB - ASUS
March 01 2018
 
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):

Intel Core i7-8700K - Intel UHD 630 3072MB - ASUS

Processor: Intel Core i7-8700K @ 4.70GHz (6 Cores / 12 Threads), Motherboard: ASUS PRIME Z370-A (0607 BIOS), Chipset: Intel Device 3ec2, Memory: 15360MB, Disk: Samsung SSD 950 PRO 256GB, Graphics: Intel UHD 630 3072MB (1200MHz), Audio: Realtek ALC1220, Monitor: DELL P2415Q, Network: Intel Connection

OS: Ubuntu 16.04, Kernel: 4.15.7-041507-generic (x86_64), Desktop: Unity 7.4.5, Display Driver: modesetting 1.19.5, OpenGL: 4.5 Mesa 18.1.0-devel- padoka PPA, Vulkan: 1.0.61, Compiler: GCC 5.4.0 20160609, File-System: ext4, Screen Resolution: 3840x2160

Compiler Notes: --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
Processor Notes: Scaling Governor: intel_pstate powersave
Security Notes: KPTI + __user pointer sanitization + Full generic retpoline Protection

PostgreSQL 10.3 on Ubuntu LinuxOpenBenchmarking.orgPhoronix Test SuiteIntel 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 20160609ext43840x2160ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay DriverOpenGLVulkanCompilerFile-SystemScreen ResolutionPostgreSQL 10.3 On Ubuntu Linux BenchmarksSystem Logs- --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: Buffer Test - Normal Load - Read Writepgbench: Mostly RAM - Normal Load - Read Writepgbench: Buffer Test - Normal Load - Read Onlypgbench: Mostly RAM - Normal Load - Read OnlyIntel Core i7-8700K - Intel UHD 630 3072MB - ASUS1726.081343.03179632.26125665.47OpenBenchmarking.org

PostgreSQL pgbench

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

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

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

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

Intel Core i7-8700K - Intel UHD 630 3072MB - ASUS

Processor: Intel Core i7-8700K @ 4.70GHz (6 Cores / 12 Threads), Motherboard: ASUS PRIME Z370-A (0607 BIOS), Chipset: Intel Device 3ec2, Memory: 15360MB, Disk: Samsung SSD 950 PRO 256GB, Graphics: Intel UHD 630 3072MB (1200MHz), Audio: Realtek ALC1220, Monitor: DELL P2415Q, Network: Intel Connection

OS: Ubuntu 16.04, Kernel: 4.15.7-041507-generic (x86_64), Desktop: Unity 7.4.5, Display Driver: modesetting 1.19.5, OpenGL: 4.5 Mesa 18.1.0-devel- padoka PPA, Vulkan: 1.0.61, Compiler: GCC 5.4.0 20160609, File-System: ext4, Screen Resolution: 3840x2160

Compiler Notes: --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
Processor Notes: Scaling Governor: intel_pstate powersave
Security Notes: KPTI + __user pointer sanitization + Full generic retpoline Protection

Testing initiated at 1 March 2018 11:57 by user pts.