Pgbenching

Intel Core i7-8700K testing with a ASUS PRIME Z370-A and Intel HD 3072MB on Fedora 26 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/1710128-AL-PGBENCHIN27.

PgbenchingProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLCompilerFile-SystemScreen Resolutionstarting out0.3 .09Intel Core i7-8700K @ 4.00GHz (6 Cores / 12 Threads)ASUS PRIME Z370-AIntel Device 3ec216384MB120GB Force MP500Intel HD 3072MB (1200MHz)Realtek ALC1220DELL P2415QIntel ConnectionFedora 264.13.5-200.fc26.x86_64 (x86_64)GNOME Shell 3.24.3Waylandmodesetting 1.19.34.5 Mesa 17.2.2GCC 7.2.1 20170915ext43840x2160OpenBenchmarking.orgKernel Details- i915.alpha_support=1Environment Details- GJS_DEBUG_OUTPUT=stderr GJS_DEBUG_TOPICS=JS ERROR;JS LOGCompiler Details- --build=x86_64-redhat-linux --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-initfini-array --enable-languages=c,c++,objc,obj-c++,fortran,ada,go,lto --enable-libmpx --enable-multilib --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=i686 --with-gcc-major-version-only --with-isl --with-linker-hash-style=gnu --with-tune=generic --without-cuda-driver Processor Details- Scaling Governor: intel_pstate powersaveSystem Details- SELinux: Enabled.

Pgbenchingpgbench: On-Disk - Normal Load - Read Onlypgbench: On-Disk - Normal Load - Read Writepgbench: On-Disk - Single Thread - Read Onlypgbench: Mostly RAM - Normal Load - Read Onlypgbench: On-Disk - Single Thread - Read Writepgbench: Buffer Test - Normal Load - Read Onlypgbench: Mostly RAM - Normal Load - Read Writepgbench: Buffer Test - Normal Load - Read Writepgbench: Mostly RAM - Single Thread - Read Onlypgbench: On-Disk - Heavy Contention - Read Onlypgbench: Buffer Test - Single Thread - Read Onlypgbench: Mostly RAM - Single Thread - Read Writepgbench: On-Disk - Heavy Contention - Read Writepgbench: Buffer Test - Single Thread - Read Writepgbench: Mostly RAM - Heavy Contention - Read Onlypgbench: Buffer Test - Heavy Contention - Read Onlypgbench: Mostly RAM - Heavy Contention - Read Writepgbench: Buffer Test - Heavy Contention - Read Writestarting out0.3 .09291719.002189.3639037.45179680.59285.25191346.487037.6810616.1524817.32253576.1226274.91487.162116.45796.81175669.00191791.318617.5610916.61290770.84787.5138892.87289343.03127.78180176.392118.216576.0039139.82250017.1024966.59293.06782.56509.16OpenBenchmarking.org

PostgreSQL pgbench

Scaling: On-Disk - Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: On-Disk - Test: Normal Load - Mode: Read Onlystarting out0.3 .0960K120K180K240K300KSE +/- 590.44, N = 3SE +/- 741.31, N = 3291719.00290770.841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: On-Disk - Test: Normal Load - Mode: Read Writestarting out0.3 .095001000150020002500SE +/- 1.72, N = 3SE +/- 0.15, N = 32189.36787.511. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Single Thread - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: On-Disk - Test: Single Thread - Mode: Read Onlystarting out0.3 .098K16K24K32K40KSE +/- 102.53, N = 3SE +/- 224.69, N = 339037.4538892.871. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read Onlystarting out0.3 .0960K120K180K240K300KSE +/- 492.32, N = 3SE +/- 1011.79, N = 3179680.59289343.031. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Single Thread - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: On-Disk - Test: Single Thread - Mode: Read Writestarting out0.3 .0960120180240300SE +/- 0.93, N = 3SE +/- 1.87, N = 3285.25127.781. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Buffer Test - Test: Normal Load - Mode: Read Onlystarting out0.3 .0940K80K120K160K200KSE +/- 95.77, N = 3SE +/- 327.57, N = 3191346.48180176.391. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read Writestarting out0.3 .0915003000450060007500SE +/- 151.72, N = 6SE +/- 39.48, N = 37037.682118.211. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Buffer Test - Test: Normal Load - Mode: Read Writestarting out0.3 .092K4K6K8K10KSE +/- 406.20, N = 6SE +/- 271.71, N = 610616.156576.001. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Mostly RAM - Test: Single Thread - Mode: Read Onlystarting out0.3 .098K16K24K32K40KSE +/- 42.59, N = 3SE +/- 126.73, N = 324817.3239139.821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read Onlystarting out0.3 .0950K100K150K200K250KSE +/- 932.47, N = 3SE +/- 1128.58, N = 3253576.12250017.101. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Single Thread - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Buffer Test - Test: Single Thread - Mode: Read Onlystarting out0.3 .096K12K18K24K30KSE +/- 181.35, N = 3SE +/- 200.57, N = 326274.9124966.591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Mostly RAM - Test: Single Thread - Mode: Read Writestarting out0.3 .09110220330440550SE +/- 2.10, N = 3SE +/- 13.04, N = 6487.16293.061. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read Writestarting out0.3 .095001000150020002500SE +/- 7.84, N = 3SE +/- 0.41, N = 32116.45782.561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Single Thread - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Buffer Test - Test: Single Thread - Mode: Read Writestarting out0.3 .092004006008001000SE +/- 95.90, N = 6SE +/- 24.63, N = 6796.81509.161. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Onlystarting out40K80K120K160K200KSE +/- 1653.28, N = 3175669.001. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Onlystarting out40K80K120K160K200KSE +/- 1688.31, N = 3191791.311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Writestarting out2K4K6K8K10KSE +/- 113.78, N = 38617.561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.6.3Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Writestarting out2K4K6K8K10KSE +/- 176.40, N = 610916.611. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

Phoronix Test Suite v10.8.4