[taler-grid5k] 117/189: some db 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 b1d534265a3f84c39e359d5ff810b07c4c10d710
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Thu Mar 31 09:00:33 2022 +0200

    some db config
---
 experiment/scripts/database.sh | 9 +++++++--
 1 file changed, 7 insertions(+), 2 deletions(-)

diff --git a/experiment/scripts/database.sh b/experiment/scripts/database.sh
index 114f0f3..70a61b3 100755
--- a/experiment/scripts/database.sh
+++ b/experiment/scripts/database.sh
@@ -78,7 +78,11 @@ function setup_config() {
 
   log_destination=syslog
   syslog_ident='taler-database'
+
   log_error_verbosity=terse
+  # log_min_messages=PANIC
+  # log_min_error_statement=PANIC
+  # client_min_messages=ERROR
 
   # For pgbadger
   # log_checkpoints=on
@@ -120,7 +124,7 @@ function setup_config() {
   autovacuum_vacuum_cost_limit=400
   autovacuum_vacuum_scale_factor=0.1
   autovacuum_vacuum_threshold=1000
-  
+
   # Default 50, 0.1
   autovacuum_analyze_threshold=50
   autovacuum_analyze_scale_factor=0.1
@@ -139,6 +143,7 @@ function setup_config() {
 
   checkpoint_completion_target=0.9
   checkpoint_timeout = 15min
+  checkpoint_flush_after = 2MB
   random_page_cost=1.1
   
   # Default 2kB
@@ -146,7 +151,7 @@ function setup_config() {
 
   # Default 0
   # 
https://www.cybertec-postgresql.com/en/the-mysterious-backend_flush_after-configuration-setting/
-  # backend_flush_after = 0
+  backend_flush_after = 2MB
 
   # Too much results in CPU load
   # 
https://www.postgresql.org/docs/13/runtime-config-resource.html#GUC-EFFECTIVE-IO-CONCURRENCY

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