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 1n0jQh-0001yk-1h for pgsql-hackers@arkaria.postgresql.org; Fri, 24 Dec 2021 12:12:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n0jQf-0002jI-Us for pgsql-hackers@arkaria.postgresql.org; Fri, 24 Dec 2021 12:12:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n0jQf-0002j9-Li for pgsql-hackers@lists.postgresql.org; Fri, 24 Dec 2021 12:12:09 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n0jQc-0007SM-Ul for pgsql-hackers@lists.postgresql.org; Fri, 24 Dec 2021 12:12:09 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.west.internal (Postfix) with ESMTP id D3ED63201BC8; Fri, 24 Dec 2021 07:12:03 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Fri, 24 Dec 2021 07:12:04 -0500 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=fm3; bh=jaNCtKcqkiuRGdZm+0ZI8pc+kp5 HaCwIdlHLkTXaY6Y=; b=XXPkpLBnDRUIMz2t38j6maUJex+X8IZOQLD8qRmU6hn ECG+vyh7PPdmHjiIP4pT16TsPWkeU6WqYuFJEwgYOhAaILuwgXGydRlKabaJIe5r hcmg6MrdAkRSd04ioe/2Sa/gSesD43gnuRkpiqH+YyWXxbdOZhH/CP2T/TyK8nuL VYzUqn3c0PboEBm7FFUWHER4LEJGL566dcG807c0RmIpnuz1qg5/M+ygNPjxm/YK PLoj9vKY3wZBRpTFQvJhmNYjQm7+3PRtznH9zkB6qdDtp0HkYrSO16aktVuW4xyE i57nDVI1kvJ/GnFuXu1EfVq9yyEvAS6XGdVL/219xpg== 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=fm1; bh=jaNCtK cqkiuRGdZm+0ZI8pc+kp5HaCwIdlHLkTXaY6Y=; b=TsiSSJob0q4bcfgIDOGy6f /D05jCF5TiCAqqNkvuj10Qp1vQqHmyNaUn1NuxzTHO1tjIMQiVW8CSOcfyWC44aL h1ahVd2VQcvaZetQzETO1UJPik9B7YmNAtTT7AOTAc3O70hTFd1/of24o0ee2BaX yijzuNgpK/YIa+akQrJPnP6BQ67tM6MAoEuT8hYGbbTd4qfaZm/zP7onSAXgF1G4 tAu4Dm8E+rtLh8QABZOSc7xsmxnTE0dRZkpw65Wi0omDkoS3P2lgGKuqEU1ye6DG A7Iu6vwCw7IMVVV3SKRt2Mxbk9t9umTBK5WW9PJDwRxbdzc6acgqWDtWvRW+6ZBg == X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvuddruddutddgfeekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucgfrhhlucfvnfffucdljedtmdenucfjughrpeffhf fvuffkfhggtggujgesghdtreertddtvdenucfhrhhomhepofhitghhrggvlhcurfgrqhhu ihgvrhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenucggtffrrghtthgvrh hnpedvgeduuefhtdeuleettdevjeehheeiveeuieegleetgeeljeelieeuieehgeevhfen ucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthh grvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 24 Dec 2021 07:12:01 -0500 (EST) Date: Fri, 24 Dec 2021 21:11:59 +0900 From: Michael Paquier To: Kyotaro Horiguchi Cc: bharath.rupireddyforpostgres@gmail.com, pgsql-hackers@lists.postgresql.org Subject: Re: Add checkpoint and redo LSN to LogCheckpointEnd log message Message-ID: References: <20211224.145134.1164706994861031206.horikyota.ntt@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="khchaqLO/hmuNzaq" Content-Disposition: inline In-Reply-To: <20211224.145134.1164706994861031206.horikyota.ntt@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --khchaqLO/hmuNzaq Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Dec 24, 2021 at 02:51:34PM +0900, Kyotaro Horiguchi wrote: > I thougt about something like the following, but your proposal may be > clearer. + "LSN=3D%X/%X, REDO LSN=3D%X/%X", This could be rather confusing for the average user, even if I agree that this is some information that only an advanced user could understand. Could it be possible to define those fields in a more deterministic way? For one, it is hard to understand the relationship between both fields without looking at the code, particulary if both share the same value. It is at least rather.. Well, mostly, easy to guess what each other field means in this context, which is not the case of what you are proposing here. One idea could be use also "start point" for REDO, for example.=20 -- Michael --khchaqLO/hmuNzaq Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmHFuQ8ACgkQnvQgOdby QH2VpBAAqGYLbCo8OBzN8ZNZuNdBbfxbxXzpVEcNC4iqiLGsGeWGbls48uTsIElB jah47dgD2q8wkwpo3lYQkhLmZffMzlbPCUzKIJPy2ZROme1V1YNnriZmbvtyFmY6 mclZz9iHZJjt1lQEkq3MGlyvMqzpSs0QUDduY0lMBDVHLTlqzE7MMcjCkCrDUK4U Qy90cVzwi0VDjUzz4G4BX/kyDW3yjnfDH5R4zn53omzdX9XVoFxfpJ+gOTKcsDjx OREk45NluVqF3H2oeNLnhqR8UIkITc364/WdgGffu76+8F7pbjmNuXrvO/nwKODy 5aQsf+OznBPWobdxOG4WN2yV55yAvAd2v0sBhzWXToKUuY2jSk2CrvLDll83FQZe sK5Zb+HtZnw7JGbM/1Gnk1yVwHf5HBJ11CmzZhWbPI8kN/MF4uzgYzV6+fkaIA+1 LIO2VY6uNMj84c9XIxDXchoYZmCzGh//eWcMS252X8sLRIyT7EvlM/M+o3VDCj2H +Z4GP6kTbnjqTJK23VmNKHEwvUMfU7DsZJiyjDwCDGEVcrThmqNbe3ra+3ZKAGgc 41DEtNn56Hv/iCbx9xesHEGK8eiNkl7w6FghsjPvg6QiB+csbf5bp2FXAAbwf5Op dmH6+p2Jqd7MvUeOACbFHWmCrK7eCs9VoQgok/Ys7eVqh5hznG8= =joJ6 -----END PGP SIGNATURE----- --khchaqLO/hmuNzaq--