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 1lOZdo-0007JW-2Y for pgsql-hackers@arkaria.postgresql.org; Tue, 23 Mar 2021 05:31:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lOZdm-0008Ra-V5 for pgsql-hackers@arkaria.postgresql.org; Tue, 23 Mar 2021 05:31:42 +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 1lOZdm-0008RR-Og for pgsql-hackers@lists.postgresql.org; Tue, 23 Mar 2021 05:31:42 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lOZdk-0007QA-QX for pgsql-hackers@postgresql.org; Tue, 23 Mar 2021 05:31:41 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id B7BAA12FA; Tue, 23 Mar 2021 01:31:38 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Tue, 23 Mar 2021 01:31:39 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=NSbsPDS/2lCdAvO99EUlKi/qPmV n2YLD4351C2iYTLI=; b=Falq7Ec5BQmxjLLwCV9Mkf1Dwujd9nfqnfjdOykeYSf rQrl374+rXrD8BJAnaT1f1Y/Ndgu0T3zSdgGLUHQEA47h50i1MBG2tQtN0pg+vvB p8bxvjZ1K5C6IcSiMblhEPmVg+KNuWBeAPBxVre0rmf4pY/GqUj8sQFs5ZpdfrG/ 1AO/bhK5n4iFn5x16MGK3Ez07NL4Jae8/F9SCqVm4cFGxEa6Srn490V/n6Rq2hVQ ScyYzcov3NPiV9qlNaHSjGlpfvusNEuQ7ZBTLmN/nMkB8RJPqOrzcl1NiBRqYuzX 5km7FOu88HFTePHqKHp8Og05T9XkgtubTc0kaZBi+GQ== 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:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=NSbsPD S/2lCdAvO99EUlKi/qPmVn2YLD4351C2iYTLI=; b=wY8VrRZoPGeUbysaak/97b ntXGU9gjMlEAdolsLr2yj/AggJgY154VtiBceC70bzBKjuzfGJqSrGyw2F4RjUhF Bu46gJaOhGTxGy+D1/vBVHqe2FGBkz2ceiAN//sP47kPtQaUpRGqQtljT1e0+QKO YluCtFvNqkiGa4RQwjy2B2gm5C0wuSM6fIT6KEUDQjBzY9H/mU/4OF6ZYrrwm+av qStsvvsqihEaugXOT96Kk8VvzBFQlSJsivPfwn/nhh4n2peiJqN7+7qrJXwOmMRL 4Ve3jNuBKTrZa2q/3Er0JdsiXkmbMuTDwma+B6JHtoo3RvDCE3fRK3zp3Crv0geQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrudeghedgkeegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpedvgeduuefhtdeuleettdevjeeh heeiveeuieegleetgeeljeelieeuieehgeevhfenucfkphepudduuddruddtvddrudektd drudekheenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhm pehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 018CC1080063; Tue, 23 Mar 2021 01:31:33 -0400 (EDT) Date: Tue, 23 Mar 2021 14:31:30 +0900 From: Michael Paquier To: Stephen Frost Cc: David Steele , Peter Eisentraut , Alvaro Herrera , Laurenz Albe , "Bossart, Nathan" , Bernd Helmle , "tsunakawa.takay@fujitsu.com" , "pgsql-hackers@postgresql.org" , Tom Lane Subject: Re: Change default of checkpoint_completion_target Message-ID: References: <20201210171602.GP16415@tamriel.snowman.net> <20201210172126.GA25979@alvherre.pgsql> <20201210172255.GQ16415@tamriel.snowman.net> <20210113221038.GG27507@tamriel.snowman.net> <20210119191450.GO27507@tamriel.snowman.net> <519044.1611084646@sss.pgh.pa.us> <20210119194748.GP27507@tamriel.snowman.net> <20210322171059.GB20766@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="3KVk0lLyvgw2pglu" Content-Disposition: inline In-Reply-To: <20210322171059.GB20766@tamriel.snowman.net> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --3KVk0lLyvgw2pglu Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Mon, Mar 22, 2021 at 01:11:00PM -0400, Stephen Frost wrote: > Unless there's anything further on this, I'll plan to commit it tomorrow > or Wednesday. Cool, looks fine to me. This version of the patch has forgotten to update one spot: src/backend/postmaster/checkpointer.c:double CheckPointCompletionTarget = 0.5; -- Michael --3KVk0lLyvgw2pglu Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmBZfTIACgkQnvQgOdby QH0MNg//XXiXGOoOF9GSjog3GAB54s0TrJm/GiWCT7KiJ4NBjsD4JzqM017C9Ii3 dgZP7/BY1OBmu25pX7Fk3VmTyNs+6lCMt+upfon50/P/WwahPsje6wAA1CU6OJjU yTmmENh+BWD6XGDq1+tkTddPDXVnHAJJOlNbC1gh9NChgYgYYtMGYJGr7jPFu0AP tkhoZt0vg1/Qep5a9PPURESS/lhaEM14RbKED84W/F3kBre1WVaeSACIo8OEE4G2 PpfGr79EPEGR9HeBWI36D+s6RWEoaDWpStdegXfQsuDDnoEB0CuEXaI8kSbuMqti aN2cLWrEflgcEDY4U7U+o6l22ddVf9dRVrZETYhihtaVjDYdab8sQriXAp6VN9C6 zWSCGeSHJx6GoGBy/f/ZAkahiAJ3S3S0ybovE+QWvd91HaNlNehc9aThE8pFx6Ml YXmgZD/3Nv7RMSSlpKbxy7hmeC+u8mKoKXzmbvrhoQmCXZnnuSVw6+rMFwyGUXid 9tBqL6VqUdPjx9ARrcG1Hcf7Wl4aE5mLltCv57ZhBK4HanuVKMLkW3m4vUFcLcAr +hwVomVxIQ+O0alWSb8ENUoX4Hn0+AVdtfWc2Aa8pvWP+yxFY89x9aG62BBfQ3lF DlTOMmHgfuDem6/JnuCt0NpqPKUoGYMP+MaD4hjUQRtv/VRXWU4= =Dntr -----END PGP SIGNATURE----- --3KVk0lLyvgw2pglu--