cloudfoundry-community / postgresql-docker-boshrelease

BOSH Release for PostgreSQL in Docker container
Apache License 2.0
4 stars 11 forks source link

Change default value of checkpoint_segments and checkpoint_completion_target for better performance? #28

Open odunybrad opened 5 years ago

odunybrad commented 5 years ago

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.

drnic commented 5 years ago

Sounds good. PR it and I’ll try to help get it merged/built/cut. -- Dr Nic Williams Stark & Wayne LLC http://starkandwayne.com +61 437 276 076 twitter @drnic