summaryrefslogtreecommitdiffstats
path: root/files/etc/postgresql/postgresql.conf
diff options
context:
space:
mode:
authorGuilhem Moulin <guilhem@fripost.org>2024-10-29 03:38:05 +0100
committerGuilhem Moulin <guilhem@fripost.org>2024-11-06 11:56:57 +0100
commitb090fbe61cd8449595ccd0822ca87e33d666426d (patch)
tree1bf7695afdb74bc65c55b6796bb8a06654fa9104 /files/etc/postgresql/postgresql.conf
parent0fa3fd8aa6e512fe4a2ba52f090e70386812aaa7 (diff)
Tune PostgreSQL.
Cf. https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
Diffstat (limited to 'files/etc/postgresql/postgresql.conf')
-rw-r--r--files/etc/postgresql/postgresql.conf4
1 files changed, 4 insertions, 0 deletions
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