check and configure postgres

current-stats.sh

# connect to docker
docker exec -i --user=root -t db-9.5 /bin/bash 

# inside docker
psql -U odoo

# inside psql
select datname, count(*) from pg_stat_activity group by datname;

update-config.sh

# get config from http://pgtune.leopard.in.ua/

# copy current config
docker cp db-9.5:/var/lib/postgresql/data/postgresql.conf .
# backup
cp postgresql.conf postgresql.conf.origin
# edit
emacs postgresql.conf
# update
docker cp postgresql.conf db-9.5:/var/lib/postgresql/data/postgresql.conf

# restart