The Postgre 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. ".
I wonder if the default need to be changed for performance concern. Thanks.