diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2023-06-09 08:26:34 +0200 |
|---|---|---|
| committer |  GitHub <noreply@github.com>
| 2023-06-09 08:26:34 +0200 |
| commit | a495e995bc59f17e307bbf328e315c1e44133611 (patch) | |
| tree | ea1e026f7b1d8ace96f4db8bb33c6dfbf7102542 | |
| parent | bab353ce6156c4d9344c641611aa712a99f20a94 (diff) | |
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
| -rw-r--r-- | Docker/freshrss/docker-compose-db.yml | 10 |
1 files changed, 9 insertions, 1 deletions
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 |