"Bossart, Nathan" <bossartn@amazon.com> writes: > On 12/7/20, 9:53 AM, "Stephen Frost" <sfrost@snowman.net> wrote: >> Concretely, attached is a patch which changes the default and updates >> the documentation accordingly.
> +1 to setting checkpoint_completion_target to 0.9 by default.
FWIW, I kind of like the idea of getting rid of it completely. Is there really ever a good reason to set it to something different than that? If not, well, we have too many GUCs already, and each of them carries nonzero performance, documentation, and maintenance overhead.
+1.
There are plenty of cases I think where it doesn't really matter with the values, but when it does I'm not sure what it would be where something else would actually be better.