postgresql-container
postgresql-container copied to clipboard
Change default value of checkpoint_segments and checkpoint_completion_target for better performance?
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 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.