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 1k7ZzL-00082i-1l for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Aug 2020 07:55:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k7ZzK-0004tO-06 for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Aug 2020 07:55:26 +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 1k7ZzJ-0004tH-Mp for pgsql-hackers@lists.postgresql.org; Mon, 17 Aug 2020 07:55:25 +0000 Received: from meesny.iki.fi ([2001:67c:2b0:1c1::201]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k7ZzD-0002s8-Ev for pgsql-hackers@postgresql.org; Mon, 17 Aug 2020 07:55:24 +0000 Received: from [192.168.1.113] (dsl-hkibng22-54faa4-119.dhcp.inet.fi [84.250.164.119]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: hlinnaka) by meesny.iki.fi (Postfix) with ESMTPSA id D61B7201E7; Mon, 17 Aug 2020 10:55:13 +0300 (EEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=meesny; t=1597650913; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=yPn3P53+zacAcGIjntdqxazjAecNQY6jBgEpvW0whlM=; b=iHNEci9EbaeiB9GaBJf0wVOKTvvcIFFZ7CZNY7KsP7wVarI1AJpXekfElOnFYCuwYfB8lu 2ItuV+7pM/0s1MPBk/opsx6OALRdKMXnIzueZNjvg5jyTJ6KkRsv0dD1hx2RfKBCL/P4ys Iazr7HNB/o3Wl0zPMJdWz+0KLqy/AzI= Subject: Re: Commit/abort WAL records with dropped rels missing XLR_SPECIAL_REL_UPDATE To: Michael Paquier , Amit Kapila Cc: pgsql-hackers References: <07b33e2c-46a6-86a1-5f9e-a7da73fddb95@iki.fi> <20200817070017.GE7787@paquier.xyz> From: Heikki Linnakangas Message-ID: <31bfe3aa-4962-955d-2f40-94de8b3e659a@iki.fi> Date: Mon, 17 Aug 2020 10:55:13 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.11.0 MIME-Version: 1.0 In-Reply-To: <20200817070017.GE7787@paquier.xyz> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=meesny; t=1597650913; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=yPn3P53+zacAcGIjntdqxazjAecNQY6jBgEpvW0whlM=; b=UF8tA0M0oQAkjpOdCfHCdi9U7QBOFjlTyHTUmGfg9iygsPtFzcLTi3A4lDWXAsPMctKSjO 40QfOhv3yHK7bk+kkbY6KXOhqr5YOhjpO32f2whuFqi0v2xm+WRA5rg7bd1B1XubePMH45 BwjRaV51SJW3A7EtwQWWqoLdCGQr/Ac= ARC-Seal: i=1; s=meesny; d=iki.fi; t=1597650913; a=rsa-sha256; cv=none; b=GTiL0XFkvgXedmhIvtJETY3MpDZQYICUHhKcsRdEwjK3DcZzdjn7Vfn5m6kNI84W2WBPRl TQqMVVSLmSO7mCRxPizjdrGf+o7ESzm3KVsQvVRFIrU8pEcJ82ZagDNYwqY0n8vbzWu5GY oJog9w7RaAn5grbnjbi7yd6Fje1H1B8= ARC-Authentication-Results: i=1; ORIGINATING; auth=pass smtp.auth=hlinnaka smtp.mailfrom=hlinnaka@iki.fi List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 17/08/2020 10:00, Michael Paquier wrote: > On Sat, Aug 15, 2020 at 11:05:43AM +0530, Amit Kapila wrote: >> On Fri, Aug 14, 2020 at 2:17 PM Heikki Linnakangas wrote: >>> It's always been like that, but I am not going backport, for fear of >>> breaking existing applications. If a program reads the WAL, and would >>> actually need to do something with commit records dropping relations, >>> that seems like such a common scenario that the author should've thought >>> about it and handled it even without the flag reminding about it. Fixing >>> it in master ought to be enough. >> >> +1 for doing it in master only. Even if someone comes up with such a >> scenario for back-branches, we can revisit our decision to backport >> this but like you, I also don't see any pressing need to do it now. > > +1. Pushed, thanks! - Heikki