You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
Thanks for providing this useful container.
I have a question about two postgre config: It seems you keep the default setting of
checkpoint_segments
to 5min andcheckpoint_completion_target
to 0.5.However, The official document recommends to set
checkpoint_segments
to 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_target
to0.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 andcheckpoint_completion_target
to 0.9 for better performance?Thanks.
The text was updated successfully, but these errors were encountered: