diff options
| author | mo khan <mo.khan@gmail.com> | 2020-04-29 11:58:53 -0600 |
|---|---|---|
| committer | mo khan <mo.khan@gmail.com> | 2020-04-29 11:58:53 -0600 |
| commit | 7af7607b33a9822d2ae107712c589e5ed5a5157a (patch) | |
| tree | 961888c861527b4e369a1904b2e3c5a40c41ddbd | |
| parent | 4984ccc6c2fe3e336a2cd2d3b85d8cda52b68225 (diff) | |
Add a few more config options to tune
| -rw-r--r-- | README.md | 2 |
1 files changed, 2 insertions, 0 deletions
@@ -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) |
