From a495e995bc59f17e307bbf328e315c1e44133611 Mon Sep 17 00:00:00 2001
From: Alexandre Alapetite <alexandre@alapetite.fr>
Date: Fri, 9 Jun 2023 08:26:34 +0200
Subject: Docker example of PostgreSQL tuning (#5446)

Provide example of how to easily tune selected PostgreSQL settings
https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
---
 Docker/freshrss/docker-compose-db.yml | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

diff --git a/Docker/freshrss/docker-compose-db.yml b/Docker/freshrss/docker-compose-db.yml
index b845947b6..14e105400 100644
--- a/Docker/freshrss/docker-compose-db.yml
+++ b/Docker/freshrss/docker-compose-db.yml
@@ -6,7 +6,7 @@ volumes:
 services:
 
   freshrss-db:
-    image: postgres:14
+    image: postgres:15
     container_name: freshrss-db
     hostname: freshrss-db
     restart: unless-stopped
@@ -19,3 +19,11 @@ services:
       POSTGRES_DB: ${DB_BASE:-freshrss}
       POSTGRES_USER: ${DB_USER:-freshrss}
       POSTGRES_PASSWORD: ${DB_PASSWORD:-freshrss}
+    command:
+      # Examples of PostgreSQL tuning.
+      # https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
+      # When in doubt, skip and stick to default PostgreSQL settings.
+      - -c
+      - shared_buffers=1GB
+      - -c
+      - work_mem=32MB
-- 
cgit v1.2.3