From 80a6f24a45c2076d3b00d9951d4f9f358d8817f4 Mon Sep 17 00:00:00 2001 From: Sam Date: Thu, 2 Apr 2015 08:07:22 +1100 Subject: [PATCH] add comments about shared buffer and db work mem --- samples/data.yml | 12 ++++++++++-- samples/standalone.yml | 11 +++++++++-- 2 files changed, 19 insertions(+), 4 deletions(-) diff --git a/samples/data.yml b/samples/data.yml index cef5c78..29888c9 100644 --- a/samples/data.yml +++ b/samples/data.yml @@ -14,9 +14,17 @@ expose: params: db_default_text_search_config: "pg_catalog.english" - ## Set db_shared_buffers to 1/3 of the memory you wish to allocate to postgres - ## on 1GB install set to 128MB on a 4GB instance you may raise to 1GB + + ## Set db_shared_buffers to a max of 25% of the total memory. + ## + ## On 1GB installs set to 128MB (to leave room for other processes) + ## on a 4GB instance you may raise to 1GB #db_shared_buffers: "256MB" + # + ## Set higher on large instances it defaults to 10MB, for a 3GB install 40MB is a good default + ## this improves sorting performance, but adds memory usage per-connection + #db_work_mem: "40MB" + # env: # ensure locale exists in container, you may need to install it diff --git a/samples/standalone.yml b/samples/standalone.yml index 9c372b3..cac5c73 100644 --- a/samples/standalone.yml +++ b/samples/standalone.yml @@ -27,10 +27,17 @@ expose: params: db_default_text_search_config: "pg_catalog.english" - ## Set db_shared_buffers to 1/3 of the memory you wish to allocate to postgres - ## on 1GB install set to 128MB on a 4GB instance you may raise to 1GB + + ## Set db_shared_buffers to a max of 25% of the total memory. + ## + ## On 1GB installs set to 128MB (to leave room for other processes) + ## on a 4GB instance you may raise to 1GB #db_shared_buffers: "256MB" # + ## Set higher on large instances it defaults to 10MB, for a 3GB install 40MB is a good default + ## this improves sorting performance, but adds memory usage per-connection + #db_work_mem: "40MB" + # ## Which Git revision should this container use? (default: tests-passed) #version: tests-passed -- 2.25.1