Re: Change default of checkpoint_completion_target
От | Peter Eisentraut |
---|---|
Тема | Re: Change default of checkpoint_completion_target |
Дата | |
Msg-id | 5285eb02-3340-7728-9f62-1a4365eda850@enterprisedb.com обсуждение исходный текст |
Ответ на | Change default of checkpoint_completion_target (Stephen Frost <sfrost@snowman.net>) |
Ответы |
Re: Change default of checkpoint_completion_target
|
Список | pgsql-hackers |
On 2020-12-07 18:53, Stephen Frost wrote: > * Michael Paquier (michael@paquier.xyz) wrote: >> On Sun, Dec 06, 2020 at 10:03:08AM -0500, Stephen Frost wrote: >>> * Alvaro Herrera (alvherre@alvh.no-ip.org) wrote: >>>> You keep making this statement, and I don't necessarily disagree, but if >>>> that is the case, please explain why don't we have >>>> checkpoint_completion_target set to 0.9 by default? Should we change >>>> that? >>> >>> Yes, I do think we should change that.. >> >> Agreed. FWIW, no idea for others, but it is one of those parameters I >> keep telling to update after a default installation. > > Concretely, attached is a patch which changes the default and updates > the documentation accordingly. I agree with considering this change, but I wonder why the value 0.9. Why not, say, 0.95, 0.99, or 1.0?
В списке pgsql-hackers по дате отправления: