In my postgresql log, I see statements such as checkpoints are occurring too frequently (26 seconds apart). Currently in the conf, checkpoint_segments are 32, checkpoint_timeout is 15 mins and checkpoint_completion_target is 0.9.

I've seen many suggestions that I need to increase my checkpoint_segments. But they don't talk about by how much? Around 6GBs of postgresql log is generated daily (it's a write heavy chat application).

How do I go about tuning checkpoint_segments to a higher value?



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.