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

diff --git a/docker-compose/docker-compose.yml b/docker-compose/docker-compose.yml
index de427af..a604b06 100644 (file)
--- 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 (file)
index 0000000..0c96de5
--- /dev/null
+++ b/docker-compose/postgres-init.sql
@@ -0,0 +1 @@
+ALTER SYSTEM SET shared_buffers = '512MB';