From b090fbe61cd8449595ccd0822ca87e33d666426d Mon Sep 17 00:00:00 2001
From: Guilhem Moulin <guilhem@fripost.org>
Date: Tue, 29 Oct 2024 03:38:05 +0100
Subject: Tune PostgreSQL.

Cf. https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
---
 files/etc/postgresql/postgresql.conf | 4 ++++
 tasks/webmap.yml                     | 7 +++++++
 2 files changed, 11 insertions(+)
 create mode 100644 files/etc/postgresql/postgresql.conf

diff --git a/files/etc/postgresql/postgresql.conf b/files/etc/postgresql/postgresql.conf
new file mode 100644
index 0000000..038438a
--- /dev/null
+++ b/files/etc/postgresql/postgresql.conf
@@ -0,0 +1,4 @@
+shared_buffers = 768MB
+temp_buffers = 128MB
+work_mem = 16MB
+effective_cache_size = 1536MB
diff --git a/tasks/webmap.yml b/tasks/webmap.yml
index 5f82d7f..a417dbd 100644
--- a/tasks/webmap.yml
+++ b/tasks/webmap.yml
@@ -165,6 +165,13 @@
   # PostgreSQL needs to be restarted to see the new locale
   notify: Restart PostgreSQL
 
+- name: Configure PostgreSQL
+  copy: src=etc/postgresql/postgresql.conf
+        dest=/etc/postgresql/{{ postgresql.version }}/{{ postgresql.cluster }}/conf.d/local.conf
+        owner=postgres group=postgres
+        mode=0644
+  notify: Restart PostgreSQL
+
 - name: Start PostgreSQL
   service: name=postgresql@{{ postgresql.version }}-{{ postgresql.cluster }}.service state=started
 
-- 
cgit v1.2.3