[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[taler-grid5k] 51/73: add auto explain - not tested yet
From: |
gnunet |
Subject: |
[taler-grid5k] 51/73: add auto explain - not tested yet |
Date: |
Tue, 14 Dec 2021 15:10:33 +0100 |
This is an automated email from the git hooks/post-receive script.
marco-boss pushed a commit to branch master
in repository grid5k.
commit 28618d07a81d3d51e0d76675947fb57e05950974
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Tue Dec 7 11:59:26 2021 +0100
add auto explain - not tested yet
---
experiment/TODO | 1 +
experiment/scripts/database.sh | 4 ++++
2 files changed, 5 insertions(+)
diff --git a/experiment/TODO b/experiment/TODO
index 6a03a84..95c06e3 100644
--- a/experiment/TODO
+++ b/experiment/TODO
@@ -3,3 +3,4 @@
- lsblk -d -o name,rota - dahu ssd
* fix wallet stop
* try huge_pages
https://www.postgresql.org/docs/13/runtime-config-resource.html
+ https://www.postgresql.org/docs/13/kernel-resources.html
diff --git a/experiment/scripts/database.sh b/experiment/scripts/database.sh
index 8f85622..180a406 100755
--- a/experiment/scripts/database.sh
+++ b/experiment/scripts/database.sh
@@ -23,6 +23,10 @@ function setup_config() {
syslog_ident='taler-database'
log_min_duration_statement=500
shared_preload_libraries='pg_stat_statements,auto_explain'
+ auto_explain.log_min_duration='300ms'
+ auto_explain.log_analyze=true
+ auto_explain.log_buffers=true
+ auto_explain.log_wal=true
# use 25% of the available memory
# (https://www.postgresql.org/docs/13/runtime-config-resource.html)
--
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.
- [taler-grid5k] 46/73: remove previous builds, (continued)
- [taler-grid5k] 46/73: remove previous builds, gnunet, 2021/12/14
- [taler-grid5k] 62/73: fix monitor, gnunet, 2021/12/14
- [taler-grid5k] 49/73: monitor dns too, change db settings, gnunet, 2021/12/14
- [taler-grid5k] 59/73: fix taler-perf.sh, improve other scripts, gnunet, 2021/12/14
- [taler-grid5k] 56/73: fix startup, gnunet, 2021/12/14
- [taler-grid5k] 45/73: take postgres config to seperate file, gnunet, 2021/12/14
- [taler-grid5k] 38/73: speedup image build, gnunet, 2021/12/14
- [taler-grid5k] 40/73: document variables, gnunet, 2021/12/14
- [taler-grid5k] 70/73: update plotter README and dashboards, gnunet, 2021/12/14
- [taler-grid5k] 65/73: filter wallet getRecord messages - they spam the logs, gnunet, 2021/12/14
- [taler-grid5k] 51/73: add auto explain - not tested yet,
gnunet <=
- [taler-grid5k] 67/73: update dashboards, gnunet, 2021/12/14
- [taler-grid5k] 53/73: add more description about huge pages, gnunet, 2021/12/14
- [taler-grid5k] 71/73: remove unused rpecs and handled notes, gnunet, 2021/12/14
- [taler-grid5k] 69/73: update plotter script, gnunet, 2021/12/14
- [taler-grid5k] 72/73: add possibility to define grid5k repo branch for experiments, gnunet, 2021/12/14
- [taler-grid5k] 66/73: update dashboard exports, gnunet, 2021/12/14
- [taler-grid5k] 64/73: comment scripts and add help, gnunet, 2021/12/14
- [taler-grid5k] 73/73: scripts documented and commented, gnunet, 2021/12/14
- [taler-grid5k] 68/73: update grafana dashboards, add option for ram mount in db, gnunet, 2021/12/14