Change default of checkpoint_completion_target

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, "Bossart, Nathan" <bossartn(at)amazon(dot)com>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Bernd Helmle <mailings(at)oopsware(dot)de>, "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Change default of checkpoint_completion_target
Date: 2020-12-07 17:53:29
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


* Michael Paquier (michael(at)paquier(dot)xyz) wrote:
> On Sun, Dec 06, 2020 at 10:03:08AM -0500, Stephen Frost wrote:
> > * Alvaro Herrera (alvherre(at)alvh(dot)no-ip(dot)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.

Passes regression tests and doc build. Will register in the January
commitfest as Needs Review.



Attachment Content-Type Size
cct_def_v1.patch text/x-diff 5.3 KB


Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2020-12-07 18:13:25 pg_rewind race condition just after promotion
Previous Message Alexander Korotkov 2020-12-07 17:31:21 Re: POC: Better infrastructure for automated testing of concurrency issues