summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authormo khan <mo.khan@gmail.com>2020-04-29 11:58:53 -0600
committermo khan <mo.khan@gmail.com>2020-04-29 11:58:53 -0600
commit7af7607b33a9822d2ae107712c589e5ed5a5157a (patch)
tree961888c861527b4e369a1904b2e3c5a40c41ddbd
parent4984ccc6c2fe3e336a2cd2d3b85d8cda52b68225 (diff)
Add a few more config options to tune
-rw-r--r--README.md2
1 files changed, 2 insertions, 0 deletions
diff --git a/README.md b/README.md
index d58003a..0e89e7f 100644
--- a/README.md
+++ b/README.md
@@ -1986,6 +1986,8 @@ FROM pg_buffercache GROUP BY 1 ORDER BY 1;
* `huge_pages = try` is good to use on linux.
* `work_mem` default is 4MB.
* `max_connections` has a default of 100. This can be a rather high default.
+* `synchronous_commit = on` default is `on`. Setting it to `off` means not every commit will flush to the transaction log.
+* `commit_delay` default to `0`. Can be used to batch transaction to log. Will wait 5 seconds to see what else needs to be flushed and flush them together. Does make transactions a little bit longer.
```text
RAM >= shared_buffers + (work_mem * max_connections)