I have a question about two postgre config: It seems you keep the default setting of checkpoint_segments to 5min and checkpoint_completion_target to 0.5.
However, The official document recommends to set checkpoint_segments to at least 10, which improves the performance: "Unless you're running on a very small configuration, you'll almost certainly be better setting this to at least 10, which also allows usefully increasing the completion target."
The document also recommends to set checkpoint_completion_target to 0.9, which is the more useful value and improves the performance: "You can spread those writes out further, lowering the average write overhead, by increasing the checkpoint_completion_target parameter to its useful maximum of 0.9"
Shall we change the default of checkpoint_segments to 10 and checkpoint_completion_target to 0.9 for better performance?
Thanks.
Thanks for providing this useful container.
I have a question about two postgre config: It seems you keep the default setting of
checkpoint_segmentsto 5min andcheckpoint_completion_targetto 0.5.However, The official document recommends to set
checkpoint_segmentsto at least10, which improves the performance: "Unless you're running on a very small configuration, you'll almost certainly be better setting this to at least 10, which also allows usefully increasing the completion target."The document also recommends to set
checkpoint_completion_targetto0.9, which is the more useful value and improves the performance: "You can spread those writes out further, lowering the average write overhead, by increasing the checkpoint_completion_target parameter to its useful maximum of 0.9"Shall we change the default of
checkpoint_segmentsto 10 andcheckpoint_completion_targetto 0.9 for better performance? Thanks.