From 4e2c927201143795748e599d205ebe46679c7e05 Mon Sep 17 00:00:00 2001 From: danielhanrahan Date: Thu, 14 Mar 2024 18:02:09 +0000 Subject: [PATCH] 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 Change-Id: Ib20502f159f005ba941f39758555551f447d2b67 --- docker-compose/docker-compose.yml | 2 ++ docker-compose/postgres-init.sql | 1 + 2 files changed, 3 insertions(+) create mode 100644 docker-compose/postgres-init.sql diff --git a/docker-compose/docker-compose.yml b/docker-compose/docker-compose.yml index de427af13..a604b0652 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: diff --git a/docker-compose/postgres-init.sql b/docker-compose/postgres-init.sql new file mode 100644 index 000000000..0c96de5b5 --- /dev/null +++ b/docker-compose/postgres-init.sql @@ -0,0 +1 @@ +ALTER SYSTEM SET shared_buffers = '512MB'; -- 2.16.6