Revision 1721
Added by Aaron Marcuse-Kubitza over 12 years ago
| postgresql.nimoy.conf | ||
|---|---|---|
| 179 | 179 |
|
| 180 | 180 |
# - Checkpoints - |
| 181 | 181 |
|
| 182 |
checkpoint_segments = 32 # in logfile segments, min 1, 16MB each |
|
| 182 | 183 |
#checkpoint_segments = 3 # in logfile segments, min 1, 16MB each |
| 183 | 184 |
#checkpoint_timeout = 5min # range 30s-1h |
| 185 |
checkpoint_completion_target = 0.9 # checkpoint target duration, 0.0 - 1.0 |
|
| 184 | 186 |
#checkpoint_completion_target = 0.5 # checkpoint target duration, 0.0 - 1.0 |
| 185 | 187 |
#checkpoint_warning = 30s # 0 is off |
| 186 | 188 |
|
Also available in: Unified diff
schemas/postgresql*.conf: Increased checkpoint_segments and checkpoint_completion_target so that checkpoints (performance intensive) are written less often and load-balanced better