On Tue, Dec 8, 2020 at 6:42 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > "Bossart, Nathan" <bossa...@amazon.com> writes: > > On 12/7/20, 9:53 AM, "Stephen Frost" <sfr...@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. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
