postgresql-container icon indicating copy to clipboard operation
postgresql-container copied to clipboard

Change default value of checkpoint_segments and checkpoint_completion_target for better performance?

Open odunybrad opened this issue 5 years ago • 0 comments

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.

odunybrad avatar Aug 01 '19 19:08 odunybrad