diff options
author | danielhanrahan <daniel.hanrahan@est.tech> | 2024-03-14 18:02:09 +0000 |
---|---|---|
committer | danielhanrahan <daniel.hanrahan@est.tech> | 2024-03-19 11:40:09 +0000 |
commit | 4e2c927201143795748e599d205ebe46679c7e05 (patch) | |
tree | e05664a6f7b1cb763d3b26b7d0cc070f75f9bd41 /docker-compose/docker-compose.yml | |
parent | e1277ab49cfbd8fd980336b1f2b84bca3166a449 (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.yml | 2 |
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: |