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 1lP6Xm-00021E-35 for pgsql-bugs@arkaria.postgresql.org; Wed, 24 Mar 2021 16:39:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lP6Xl-0002G4-1u for pgsql-bugs@arkaria.postgresql.org; Wed, 24 Mar 2021 16:39:41 +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 1lP6Xk-0002Fr-BX for pgsql-bugs@lists.postgresql.org; Wed, 24 Mar 2021 16:39:40 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lP6Xh-0007NR-L2 for pgsql-bugs@lists.postgresql.org; Wed, 24 Mar 2021 16:39:39 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailout.west.internal (Postfix) with ESMTP id 2E3265D3; Wed, 24 Mar 2021 12:39:36 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Wed, 24 Mar 2021 12:39:36 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding: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= fm2; bh=GZZv3dSTSe7AEZMlbdd2+mJ6I97GanQi86wgV+l9kVI=; b=WAFVxs/o FTAy7AHSNPx7maHEtQk7y4APEVaAYKoP6YaesLHjkyX0Pg1yzjFEKAw+08UvuNP3 T/yXItujc5OBYjIOV+SzduG9AEu47cbJ0W4Av+hOP7KfuC0pJpHonrd8moz1g9Bn MFgvIhH7GAZZaenEM32D1/eeCfT2ijImEMqTIb5tZVih/DhNyXI7TMnR0kPt/Dzl fjxBsljFYSxLbJIdoEVZCJQVaMTDCmrMPo2iVG7/hiCoecjy6zuPCG/ZICLbG8yR DjWtmCflIpAgbwO4p2LIvVfxMoo8z8AIXrndcM9WbdZCd5LbNI3pg7yEEEDj5CRr eUga3xhrhdQiLA== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrudegkedgkeelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffukfggtggugfgjfgesthekredttderudenucfhrhhomheptehlvhgr rhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh eqnecuggftrfgrthhtvghrnheptdevgeelhfevgeegtdffgeefgedtuedufedugffhgfek gffgieehfeeutdeiffdtnecuffhomhgrihhnpegsuhhrnhhinhhgsghirhgurdhnvghtne cukfhppeduledtrdelhedrudelrdelheenucevlhhushhtvghrufhiiigvpedtnecurfgr rhgrmhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorh hg X-ME-Proxy: Received: from perhan.alvh.no-ip.org (unknown [190.95.19.95]) by mail.messagingengine.com (Postfix) with ESMTPA id 965DB1080063; Wed, 24 Mar 2021 12:39:34 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id E871F2A0FB1; Wed, 24 Mar 2021 13:39:31 -0300 (-03) Date: Wed, 24 Mar 2021 13:39:31 -0300 From: Alvaro Herrera To: Fujii Masao Cc: zoulx1982@163.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16931: source code problem about commit_ts Message-ID: <20210324163931.GA24841@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <38d5b3c4-3bbf-64be-69f5-5f50cd1f6c2d@oss.nttdata.com> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2021-Mar-24, Fujii Masao wrote: > On 2021/03/24 18:05, Alvaro Herrera wrote: > > Yeah, it seems like a bug. With your patch, the write_xlog=true path > > becomes unused, and thus the whole COMMIT_TS_SETTS record, so we could > > remove those things in branch master. The timestamp is acquired from > > the COMMIT record. > > I agree to remove COMMIT_TS_SETTS record from the master branch > if there are no users or extensions of it. Patch attached. Looks good in a quick skim. Let's get this pushed quickly; if anything exists out there that is calling that code, it'd be good to know sooner rather than later. However, my feeling is that no such caller exists, because they would have told us about this problem already. Are you bumping WAL page magic? It'd be logical to do so, but on the other hand if no code exists that is capable of emitting that record, then it'd be pointless. > Anyway, at first, what about applying the bugfix patch I posted upthread > to all supported branches? Yeah, let's do that. -- Álvaro Herrera 39°49'30"S 73°17'W "XML!" Exclaimed C++. "What are you doing here? You're not a programming language." "Tell that to the people who use me," said XML. https://burningbird.net/the-parable-of-the-languages/