Re: Change default of checkpoint_completion_target
| От | Magnus Hagander |
|---|---|
| Тема | Re: Change default of checkpoint_completion_target |
| Дата | |
| Msg-id | CABUevEzYPRtrA1gPtT6d6XhevzK3wpmn-=1AqEq2HoysN1_MUg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Change default of checkpoint_completion_target (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-hackers |
On Tue, Dec 8, 2020 at 6:42 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
"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.
В списке pgsql-hackers по дате отправления: