summaryrefslogtreecommitdiffstats
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
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
-rw-r--r--docker-compose/docker-compose.yml2
-rw-r--r--docker-compose/postgres-init.sql1
2 files changed, 3 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:
diff --git a/docker-compose/postgres-init.sql b/docker-compose/postgres-init.sql
new file mode 100644
index 0000000000..0c96de5b55
--- /dev/null
+++ b/docker-compose/postgres-init.sql
@@ -0,0 +1 @@
+ALTER SYSTEM SET shared_buffers = '512MB';