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 | |
| 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
| -rw-r--r-- | docker-compose/docker-compose.yml | 2 | ||||
| -rw-r--r-- | docker-compose/postgres-init.sql | 1 |
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'; |