summaryrefslogtreecommitdiffstats
path: root/docker-compose/docker-compose.yml
diff options
context:
space:
mode:
authordanielhanrahan <daniel.hanrahan@est.tech>2024-03-14 18:02:09 +0000
committerdanielhanrahan <daniel.hanrahan@est.tech>2024-03-19 11:40:09 +0000
commit4e2c927201143795748e599d205ebe46679c7e05 (patch)
treee05664a6f7b1cb763d3b26b7d0cc070f75f9bd41 /docker-compose/docker-compose.yml
parente1277ab49cfbd8fd980336b1f2b84bca3166a449 (diff)
Set Postgres shared_buffers in docker-compose
By default, Postgres uses value of 128MB for shared_buffers, regardless of available memory. It is recommended to use between 25% and 40% of memory for shared_buffers in Postgres. Current value can be checked in SQL using 'SHOW shared_buffers'. Issue-ID: CPS-2156 Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech> Change-Id: Ib20502f159f005ba941f39758555551f447d2b67
Diffstat (limited to 'docker-compose/docker-compose.yml')
-rw-r--r--docker-compose/docker-compose.yml2
1 files changed, 2 insertions, 0 deletions
diff --git a/docker-compose/docker-compose.yml b/docker-compose/docker-compose.yml
index de427af13f..a604b06527 100644
--- a/docker-compose/docker-compose.yml
+++ b/docker-compose/docker-compose.yml
@@ -31,6 +31,8 @@ services:
POSTGRES_DB: cpsdb
POSTGRES_USER: ${DB_USERNAME:-cps}
POSTGRES_PASSWORD: ${DB_PASSWORD:-cps}
+ volumes:
+ - ./postgres-init.sql:/docker-entrypoint-initdb.d/postgres-init.sql
deploy:
resources:
reservations: