postgresql pgbench

postgresql pgbench

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 1810247-RA-POSTGRESQ16
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
postgresql pgbench
October 24 2018
  16 Minutes

postgresql pgbench

Processor: Intel Pentium Dual E2180 @ 2.00GHz (2 Cores), Motherboard: Intel S3210SH (S3200X38.86B.00.00.0042.042820081723 BIOS), Chipset: Intel 3200/3210 + ICH9R, Memory: 1 x 1024 MB DDR2-667MHz, Disk: 500GB Seagate ST3500413AS, Graphics: Matrox MGA G200e [Pilot], Network: Intel 82566DM-2 Gigabit Connection

OS: Debian 9.4, Kernel: 4.9.0-6-amd64 (x86_64), Compiler: GCC 6.3.0 20170516, File-System: ext4, Screen Resolution: 1024x768

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
Processor Notes: Scaling Governor: acpi-cpufreq ondemand
Security Notes: KPTI + __user pointer sanitization + Full generic retpoline

postgresql pgbenchOpenBenchmarking.orgPhoronix Test SuiteIntel Pentium Dual E2180 @ 2.00GHz (2 Cores)Intel S3210SH (S3200X38.86B.00.00.0042.042820081723 BIOS)Intel 3200/3210 + ICH9R1 x 1024 MB DDR2-667MHz500GB Seagate ST3500413ASMatrox MGA G200e [Pilot]Intel 82566DM-2 Gigabit ConnectionDebian 9.44.9.0-6-amd64 (x86_64)GCC 6.3.0 20170516ext41024x768ProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen ResolutionPostgresql Pgbench 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 - Scaling Governor: acpi-cpufreq ondemand- KPTI + __user pointer sanitization + Full generic retpoline

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: Buffer Test - Test: Single Thread - Mode: Read Writepostgresql pgbench20406080100SE +/- 4.85, N = 1285.44

postgresql pgbench

Processor: Intel Pentium Dual E2180 @ 2.00GHz (2 Cores), Motherboard: Intel S3210SH (S3200X38.86B.00.00.0042.042820081723 BIOS), Chipset: Intel 3200/3210 + ICH9R, Memory: 1 x 1024 MB DDR2-667MHz, Disk: 500GB Seagate ST3500413AS, Graphics: Matrox MGA G200e [Pilot], Network: Intel 82566DM-2 Gigabit Connection

OS: Debian 9.4, Kernel: 4.9.0-6-amd64 (x86_64), Compiler: GCC 6.3.0 20170516, File-System: ext4, Screen Resolution: 1024x768

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
Processor Notes: Scaling Governor: acpi-cpufreq ondemand
Security Notes: KPTI + __user pointer sanitization + Full generic retpoline

Testing initiated at 24 October 2018 04:38 by user root.