postGreSQL-Mine

VMware testing on Debian 9.5 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 1809184-RA-POSTGRESQ95
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
4 x Intel Core i5-8250U - VMware SVGA II 3968MB -
September 18 2018
  2 Hours, 1 Minute
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):

4 x Intel Core i5-8250U - VMware SVGA II 3968MB -

Processor: 4 x Intel Core i5-8250U @ 1.80GHz (7 Cores), Motherboard: Intel 440BX (6.00 BIOS), Chipset: Intel 440BX/ZX/DX, Memory: 4096MB, Disk: 59GB VMware Virtual S, Graphics: LLVMpipe, Audio: Ensoniq ES1371/ES1373, Network: Intel 82545EM Gigabit

OS: Debian 9.5, Kernel: 4.9.0-8-amd64 (x86_64), Desktop: GNOME Shell 3.22.3, Display Server: X Server 1.19.2, Display Driver: vmware 13.2.1, OpenGL: 3.3 Mesa 13.0.6 Gallium 0.4 (LLVM 3.9 256 bits), Compiler: GCC 6.3.0 20170516, File-System: ext4, Screen Resolution: 1920x1103, System Layer: VMware

Compiler Notes: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --enable-checking=release --enable-clocale=gnu --enable-default-pie --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=auto --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-arch-directory=amd64 --with-default-libstdcxx-abi=new --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic -v
Security Notes: KPTI + __user pointer sanitization + Full generic retpoline IBPB IBRS_FW + PTE Inversion

postGreSQL-MineOpenBenchmarking.orgPhoronix Test Suite4 x Intel Core i5-8250U @ 1.80GHz (7 Cores)Intel 440BX (6.00 BIOS)Intel 440BX/ZX/DX4096MB59GB VMware Virtual SLLVMpipeEnsoniq ES1371/ES1373Intel 82545EM GigabitDebian 9.54.9.0-8-amd64 (x86_64)GNOME Shell 3.22.3X Server 1.19.2vmware 13.2.13.3 Mesa 13.0.6 Gallium 0.4 (LLVM 3.9 256 bits)GCC 6.3.0 20170516ext41920x1103VMwareProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLCompilerFile-SystemScreen ResolutionSystem LayerPostGreSQL-Mine BenchmarksSystem Logs- --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --enable-checking=release --enable-clocale=gnu --enable-default-pie --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=auto --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-arch-directory=amd64 --with-default-libstdcxx-abi=new --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic -v - KPTI + __user pointer sanitization + Full generic retpoline IBPB IBRS_FW + PTE Inversion

postGreSQL-Minepgbench: On-Disk - Normal Load - Read Onlypgbench: On-Disk - Normal Load - Read Writepgbench: Mostly RAM - Normal Load - Read Onlypgbench: Buffer Test - Normal Load - Read Onlypgbench: Mostly RAM - Normal Load - Read Writepgbench: Buffer Test - Normal Load - Read Write4 x Intel Core i5-8250U - VMware SVGA II 3968MB -30636.43955.1333683.60254011673.242347OpenBenchmarking.org

PostgreSQL pgbench

This is a simple benchmark of PostgreSQL using pgbench. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Normal Load - Mode: Read Only4 x Intel Core i5-8250U - VMware SVGA II 3968MB -7K14K21K28K35KSE +/- 1181.69, N = 930636.43

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Normal Load - Mode: Read Write4 x Intel Core i5-8250U - VMware SVGA II 3968MB -2004006008001000SE +/- 14.26, N = 9955.13

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only4 x Intel Core i5-8250U - VMware SVGA II 3968MB -7K14K21K28K35KSE +/- 177.37, N = 333683.60

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Normal Load - Mode: Read Only4 x Intel Core i5-8250U - VMware SVGA II 3968MB -5K10K15K20K25KSE +/- 386.30, N = 1225401

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write4 x Intel Core i5-8250U - VMware SVGA II 3968MB -400800120016002000SE +/- 25.46, N = 91673.24

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Normal Load - Mode: Read Write4 x Intel Core i5-8250U - VMware SVGA II 3968MB -5001000150020002500SE +/- 76.52, N = 122347

4 x Intel Core i5-8250U - VMware SVGA II 3968MB -

Processor: 4 x Intel Core i5-8250U @ 1.80GHz (7 Cores), Motherboard: Intel 440BX (6.00 BIOS), Chipset: Intel 440BX/ZX/DX, Memory: 4096MB, Disk: 59GB VMware Virtual S, Graphics: LLVMpipe, Audio: Ensoniq ES1371/ES1373, Network: Intel 82545EM Gigabit

OS: Debian 9.5, Kernel: 4.9.0-8-amd64 (x86_64), Desktop: GNOME Shell 3.22.3, Display Server: X Server 1.19.2, Display Driver: vmware 13.2.1, OpenGL: 3.3 Mesa 13.0.6 Gallium 0.4 (LLVM 3.9 256 bits), Compiler: GCC 6.3.0 20170516, File-System: ext4, Screen Resolution: 1920x1103, System Layer: VMware

Compiler Notes: --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --enable-checking=release --enable-clocale=gnu --enable-default-pie --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=auto --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-arch-directory=amd64 --with-default-libstdcxx-abi=new --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic -v
Security Notes: KPTI + __user pointer sanitization + Full generic retpoline IBPB IBRS_FW + PTE Inversion

Testing initiated at 18 September 2018 06:37 by user freddie.