gsmolk

FROM gsmol/goslinux:6.4

RUN yum install -y gcc perl glibc-devel bison flex python-devel tcl-devel readline-devel \
                   zlib-devel openssl-devel krb5-devel e2fsprogs-devel gettext libxml2-devel \
                   pam-devel libuuid-devel openldap-devel openjade opensp docbook-dtds docbook-style-dsssl \
                   libxslt libicu-devel rpmdevtools rpm-build libevent-devel perl-ExtUtils-Embed perl-Fuse \ 
                   perl-Test-Simple perl-IPC-Run fuse-libs make libxslt-devel

RUN cd /opt &&\
    curl -O -k http://apt.sw.be/redhat/el6/en/x86_64/rpmforge/RPMS/perl-Fuse-0.09-1.el6.rf.x86_64.rpm &&\

gsmolk

pgbench -h /tmp -U pgpro -s 1000 -j 25 -c 25 -M prepared -S -T 1000 -P 1

before		~300k		4% LWLockAttemptLock
regr		~300k		6% _raw_spin_lock_irqsave
after		~300k		4% _bt_compare

pgbench -h /tmp -U pgpro -s 1000 -j 50 -c 50 -M prepared -S -T 1000 -P 1

before		~500k		4% LWLockAttemptLock

gsmolk

#!/usr/bin/python
from subprocess import Popen, PIPE, check_output
import os
import sys


#check, if docker container pgproxy is already running, if true then exit
#if container is not running, check if it is present, if true then start it and exit
#if container is not present, check if image is present, if true then run container and exit
#if image is not present, then build it, run container and exit

gsmolk

progress: 17.0 s, 16598.0 tps, lat 15.256 ms stddev 14.942 
progress: 18.0 s, 16936.1 tps, lat 14.657 ms stddev 14.728 
progress: 19.0 s, 11590.6 tps, lat 14.444 ms stddev 14.697 
progress: 20.0 s, 0.0 tps, lat -nan ms stddev -nan         
progress: 21.0 s, 0.0 tps, lat -nan ms stddev -nan         
progress: 22.0 s, 242.0 tps, lat 310.283 ms stddev 869.802 
progress: 23.0 s, 13849.6 tps, lat 73.171 ms stddev 459.375
progress: 24.0 s, 19003.0 tps, lat 13.218 ms stddev 13.575 
progress: 25.0 s, 18264.6 tps, lat 13.364 ms stddev 13.599 
progress: 26.0 s, 19346.1 tps, lat 13.249 ms stddev 13.604 

gsmolk

progress: 23.0 s, 18060.9 tps, lat 13.323 ms stddev 14.163
progress: 24.0 s, 19750.1 tps, lat 12.841 ms stddev 13.987
progress: 25.0 s, 6336.8 tps, lat 39.740 ms stddev 141.977
progress: 26.0 s, 20763.0 tps, lat 12.089 ms stddev 12.828
progress: 27.0 s, 22038.7 tps, lat 11.466 ms stddev 11.936
progress: 28.0 s, 21870.0 tps, lat 11.452 ms stddev 12.055
progress: 29.0 s, 19135.7 tps, lat 12.684 ms stddev 13.072
progress: 30.0 s, 21074.4 tps, lat 12.204 ms stddev 12.959
progress: 31.0 s, 20629.9 tps, lat 11.816 ms stddev 12.578
progress: 32.0 s, 20405.4 tps, lat 12.330 ms stddev 12.915

gsmolk

Architecture:          x86_64
CPU op-mode(s):        32-bit, 64-bit
Byte Order:            Little Endian
CPU(s):                144
On-line CPU(s) list:   0-143
Thread(s) per core:    2
Core(s) per socket:    18
Socket(s):             4
NUMA node(s):          4
Vendor ID:             GenuineIntel

gsmolk

Memory Device
        Array Handle: 0x0015
        Error Information Handle: Not Provided
        Total Width: 72 bits
        Data Width: 64 bits
        Size: 32 GB
        Form Factor: DIMM
        Set: 95
        Locator: BOARD 8 DIMM 12
        Bank Locator: Not Specified

gsmolk

 3.10.0-229-a05dc4d      |       1 |    5268
 3.10.0-229-a05dc4d      |       5 |   63799
 3.10.0-229-a05dc4d      |      10 |  132153
 3.10.0-229-a05dc4d      |      15 |  194065
 3.10.0-229-a05dc4d      |      20 |  238419
 3.10.0-229-a05dc4d      |      25 |  285468
 3.10.0-229-a05dc4d      |      30 |  329525
 3.10.0-229-a05dc4d      |      35 |  394734
 3.10.0-229-a05dc4d      |      40 |  429037
 3.10.0-229-a05dc4d      |      45 |  482332

gsmolk

SELECT
T1._Q_000_F_000,
T3._Fld10125RRef,
T1._Q_000_F_002RRef,
T1._Q_000_F_003RRef,
T1._Q_000_F_004RRef,
CASE WHEN T2._Fld2270RRef = '\\204\\246\\023\\033m\\305UZF''\\350WWPv\\207'::bytea THEN CASE WHEN T1._Q_000_F_005RRef IS NOT NULL THEN '\\000\\000\\000\\243'::bytea END WHEN T2._Fld2270RRef = '\\201F\\\\nu\\257Q\\301Fp\\027O\\211\\214\\001{'::bytea THEN CASE WHEN T1._Q_000_F_006RRef IS NOT NULL THEN '\\000\\000\\000\\243'::bytea END WHEN T2._Fld2270RRef = '\\265\\256T\\022\\026\\311\\033\\007L\\370\\272\\253\\322W\\276\\225'::bytea THEN CASE WHEN T1._Q_000_F_007RRef IS NOT NULL THEN '\\000\\000\\000\\243'::bytea END WHEN T2._Fld2270RRef = '\\261\\006hU\\025\\215\\313\\224N\\251\\312\\337\\346T\\353\\217'::bytea THEN CASE WHEN T1._Q_000_F_008RRef IS NOT NULL THEN '\\000\\000\\000\\257'::bytea END END,
CASE WHEN T2._Fld2270RRef = '\\204\\246\\023\\033m\\305UZF''\\350WWPv\\207'::bytea THEN T1._Q_000_F_005RRef WHEN T2._Fld2270RRef = '\\201F\\\\nu\\257Q\\301Fp\\027O\\211\\214\\001{'::bytea THEN T1._Q_000_F_006R

gsmolk

   count  pid
  11022 [46697]
  10066 [45263]
   9658 [44609]
   9329 [44571]
   9173 [45255]
   9146 [45203]
   9080 [45204]
   8980 [45211]
   8917 [44607]