[taler-grid5k] 22/73: add pgbouncer, tune pg config

[gnunet]

This is an automated email from the git hooks/post-receive script.

marco-boss pushed a commit to branch master
in repository grid5k.

commit e4e134208e0ab84865da7fd4a7609617a503d719
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Mon Nov 29 19:55:20 2021 +0100

    add pgbouncer, tune pg config
---
 experiment/scripts/database.sh | 6 ++++--
 image/taler-debian11.yaml      | 6 +++---
 2 files changed, 7 insertions(+), 5 deletions(-)

diff --git a/experiment/scripts/database.sh b/experiment/scripts/database.sh
index 1dc7119..69503c0 100755
--- a/experiment/scripts/database.sh
+++ b/experiment/scripts/database.sh
@@ -24,10 +24,12 @@ then
   effective_cache_size=$(($(awk '/MemTotal/ {print $2}' /proc/meminfo) * 
3/4))kB
   # 
(https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-MAX-WAL-SIZE)
   max_wal_size=2GB 
-  max_worker_processes=16
+  wal_buffers=16MB
+  max_worker_processes=$(lscpu | grep "CPU(s)" | head -n 1 | awk '{print $2}')
   max_connections=200
   # out of shared memory
-  max_locks_per_transaction=80
+  max_locks_per_transaction=85
+  # idle_in_transaction_session_timeout=5000
   " >> /etc/postgresql/13/main/postgresql.conf
   
   # Enable password for taler since this is commonly the case
diff --git a/image/taler-debian11.yaml b/image/taler-debian11.yaml
index 3ea9ed8..d950b75 100644
--- a/image/taler-debian11.yaml
+++ b/image/taler-debian11.yaml
@@ -40,9 +40,9 @@ global:
   ## Environment visibility
   # g5k_visibility: "shared"
   taler_build_packages: "recutils autoconf uncrustify autopoint libtool 
python3-pip libgcrypt20-dev libjansson-dev libcurl4-gnutls-dev libsodium-dev 
libidn2-dev libunistring-dev libmicrohttpd-dev libsqlite3-dev libqrencode-dev 
valgrind libpq-dev texinfo gdb make npm zip python3-distutils pkg-config"
-  taler_packages: "nginx postgresql-13 postgresql-contrib curl jq bc sudo git 
zile dnsutils prometheus-postgres-exporter prometheus-nginx-exporter net-tools 
netcat parallel nodejs tshark dnsmasq bind9 systemd-coredump bash-completion"
-  taler_packages_no_recommends: "prometheus prometheus-node-exporter"
-  taler_disable_services: "nginx postgresql prometheus 
prometheus-postgres-exporter prometheus-nginx-exporter prometheus-node-exporter 
named gettext-base dnsmasq"
+  taler_packages: "nginx postgresql-13 postgresql-contrib curl jq bc sudo git 
zile dnsutils prometheus-postgres-exporter prometheus-nginx-exporter net-tools 
netcat parallel nodejs tshark dnsmasq bind9 systemd-coredump bash-completion 
pgbouncer pgstat"
+  taler_packages_no_recommends: "prometheus prometheus-node-exporter 
prometheus-pgbouncer-exporter"
+  taler_disable_services: "nginx postgresql prometheus 
prometheus-postgres-exporter prometheus-nginx-exporter prometheus-node-exporter 
named gettext-base dnsmasq prometheus-pgbouncer-exporter"
   taler_loki_version: "v2.4.0"
   gnunet_tar: gnunet.tar.gz
   exchange_tar: exchange.tar.gz

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.