Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1knPdJ-0003e6-21 for pgsql-hackers@arkaria.postgresql.org; Thu, 10 Dec 2020 17:21:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1knPdG-0002Dv-Ou for pgsql-hackers@arkaria.postgresql.org; Thu, 10 Dec 2020 17:21:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1knPdG-0002Do-Hy for pgsql-hackers@lists.postgresql.org; Thu, 10 Dec 2020 17:21:34 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1knPdE-0007Cc-40 for pgsql-hackers@postgresql.org; Thu, 10 Dec 2020 17:21:33 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailout.nyi.internal (Postfix) with ESMTP id 2BC195C01B1; Thu, 10 Dec 2020 12:21:31 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Thu, 10 Dec 2020 12:21:31 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:subject:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=gFc42jexcUThRFWOY hL8wUNEOPLXglq4zCmm7V24BF0=; b=kYjSsV/9z1+QqIH3KP0BPgyv7w4/Fbf33 /mkq4GQP7Q0f/IW3I642LGLhaJYJaLR8dvCUYGE9Xj3bcbGVtu/YEcgmW3HSczcq kvQhjDz4vr3Ch4kk7gYfP/ZOsTpR3URmm27A0YanYEMKgEuK5VdVT1WH4brgOmEa Qh+b8H2ccLdWR2vCQJIHRRE+JJFLP+iiHyFVf30MHVhRZ4/8XPlSlBKt2OGp3/wo /3eg9cq+cj6KZNb2k32r2j3WmMZV3zwdj/8Ly+HU+syaEGtASsjfd+8ROgBOK6XG sKM/59+3+pjZqSEXd6YWYolYczB/GsdI4Np0gV5k7ZNU128dkGhBw== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrudektddguddttdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpeffhffvuffkgggtuggjfgesthdtredttdervdenucfhrhhomheptehlvhgr rhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh eqnecuggftrfgrthhtvghrnhephfelueefjeejvddvgeegfeetfefgieejiedtueeujedt iefgtddvteeggeekueffnecuffhomhgrihhnpehpohhsthhgrhdrvghsnecukfhppedule dtrdelhedrudekrdejleenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgr ihhlfhhrohhmpegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhg X-ME-Proxy: Received: from perhan.alvh.no-ip.org (unknown [190.95.18.79]) by mail.messagingengine.com (Postfix) with ESMTPA id 2D93224005A; Thu, 10 Dec 2020 12:21:29 -0500 (EST) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id C83E62A1530; Thu, 10 Dec 2020 14:21:26 -0300 (-03) Date: Thu, 10 Dec 2020 14:21:26 -0300 From: Alvaro Herrera To: Stephen Frost Cc: Laurenz Albe , "Bossart, Nathan" , Peter Eisentraut , Michael Paquier , Bernd Helmle , "tsunakawa.takay@fujitsu.com" , "pgsql-hackers@postgresql.org" Subject: Re: Change default of checkpoint_completion_target Message-ID: <20201210172126.GA25979@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20201210171602.GP16415@tamriel.snowman.net> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Howdy, On 2020-Dec-10, Stephen Frost wrote: > * Laurenz Albe (laurenz.albe@cybertec.at) wrote: > > On Tue, 2020-12-08 at 17:29 +0000, Bossart, Nathan wrote: > > > +1 to setting checkpoint_completion_target to 0.9 by default. > > > > +1 for changing the default or getting rid of it, as Tom suggested. > > Attached is a patch to change it from a GUC to a compile-time #define > which is set to 0.9, with accompanying documentation updates. I think we should leave a doc stub or at least an , to let people know the GUC has been removed rather than just making it completely invisible. (Maybe piggyback on the stuff in [1]?) [1] https://postgr.es/m/CAGRY4nyA=jmBNa4LVwgGO1GyO-RnFmfkesddpT_uO+3=mot8DA@mail.gmail.com