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 1mIgDp-0001XL-9P for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Aug 2021 23:52:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mIgDm-0005aY-AR for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Aug 2021 23:52:46 +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 1mIgDl-0005aI-Q6 for pgsql-hackers@lists.postgresql.org; Tue, 24 Aug 2021 23:52:46 +0000 Received: from smtp-fw-80007.amazon.com ([99.78.197.218]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mIgDg-0005Lm-EC for pgsql-hackers@lists.postgresql.org; Tue, 24 Aug 2021 23:52:44 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1629849161; x=1661385161; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=401gaks7pykCUBnbEZSShQCgbaTJYzDqJnKJOf7SZpQ=; b=BAH0+vAJBWfQCSkxKXC0zchA6TBmrh3+RUtkj+srJaKULaGv4QS9l+7y EIwS9MS1ozxR8EkDDgmxwxUREAJuTfHGOrQvUaLbFYQ/5kVSHXsm71oP8 qBUPj1l4DaVQGQyKx53Kahi3rX+u/+AXNhD3IBm0yTZ58PrSFg9LqdXYj U=; X-IronPort-AV: E=Sophos;i="5.84,348,1620691200"; d="scan'208";a="21676782" Subject: Re: prevent immature WAL streaming Thread-Topic: prevent immature WAL streaming Received: from pdx4-co-svc-p1-lb2-vlan2.amazon.com (HELO email-inbound-relay-2b-c300ac87.us-west-2.amazon.com) ([10.25.36.210]) by smtp-border-fw-80007.pdx80.corp.amazon.com with ESMTP; 24 Aug 2021 23:52:37 +0000 Received: from EX13MTAUWB001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan2.pdx.amazon.com [10.236.137.194]) by email-inbound-relay-2b-c300ac87.us-west-2.amazon.com (Postfix) with ESMTPS id 75E88A0326; Tue, 24 Aug 2021 23:52:36 +0000 (UTC) Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13MTAUWB001.ant.amazon.com (10.43.161.207) with Microsoft SMTP Server (TLS) id 15.0.1497.23; Tue, 24 Aug 2021 23:52:35 +0000 Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13D03UWC004.ant.amazon.com (10.43.162.49) with Microsoft SMTP Server (TLS) id 15.0.1497.23; Tue, 24 Aug 2021 23:52:35 +0000 Received: from EX13D03UWC004.ant.amazon.com ([10.43.162.49]) by EX13D03UWC004.ant.amazon.com ([10.43.162.49]) with mapi id 15.00.1497.023; Tue, 24 Aug 2021 23:52:35 +0000 From: "Bossart, Nathan" To: "alvherre@alvh.no-ip.org" CC: Kyotaro Horiguchi , "pgsql-hackers@lists.postgresql.org" , "mengjuan.cmj@alibaba-inc.com" , "Jakub.Wartak@tomtom.com" Thread-Index: AQHXmHGjU2YgwUqX8kaxqQEs0VJtnauB+HiAgACM3YCAAMG3gP//mO6A Date: Tue, 24 Aug 2021 23:52:34 +0000 Message-ID: <8687C486-BC80-4150-8519-13FE395485BF@amazon.com> References: <68B0D14A-0304-448A-884E-51D0CD286816@amazon.com> <202108242301.clv7fhgmvjq7@alvherre.pgsql> In-Reply-To: <202108242301.clv7fhgmvjq7@alvherre.pgsql> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.162.164] Content-Type: text/plain; charset="utf-8" Content-ID: <31A2B300A8BB1B41A18222F229695DBF@amazon.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gOC8yNC8yMSwgNDowMyBQTSwgImFsdmhlcnJlQGFsdmgubm8taXAub3JnIiA8YWx2aGVycmVA YWx2aC5uby1pcC5vcmc+IHdyb3RlOg0KPiBPbiAyMDIxLUF1Zy0yNCwgQm9zc2FydCwgTmF0aGFu IHdyb3RlOg0KPg0KPj4gSSB3b25kZXIgaWYgd2UgbmVlZCB0byBtb3ZlIHRoZSBjYWxsIHRvIFJl Z2lzdGVyU2VnbWVudEJvdW5kYXJ5KCkgdG8NCj4+IHNvbWV3aGVyZSBiZWZvcmUgV0FMSW5zZXJ0 TG9ja1JlbGVhc2UoKSBmb3IgdGhpcyB0byB3b3JrIGFzIGludGVuZGVkLg0KPj4gUmlnaHQgbm93 LCBib3VuZGFyeSByZWdpc3RyYXRpb24gY291bGQgdGFrZSBwbGFjZSBhZnRlciB0aGUgZmx1c2gN Cj4+IHBvaW50ZXIgaGFzIGJlZW4gYWR2YW5jZWQsIHdoaWNoIG1lYW5zIEdldFNhZmVGbHVzaFJl Y1B0cigpIGNvdWxkDQo+PiBzdGlsbCByZXR1cm4gYW4gdW5zYWZlIHBvc2l0aW9uLg0KPg0KPiBZ ZWFoLCB5b3UncmUgcmlnaHQgLS0gdGhhdCdzIGEgZGVmaW5pdGUgcmlzay4gIEkgZGlkbid0IHRy eSB0byByZXByb2R1Y2UNCj4gYSBwcm9ibGVtIHdpdGggdGhhdCwgYnV0IGl0IGlzIHNlZW1zIHBy ZXR0eSBvYnZpb3VzIHRoYXQgaXQgY2FuIGhhcHBlbi4NCj4NCj4gSSBkaWRuJ3QgaGF2ZSBhIGxv dCBvZiBsdWNrIHdpdGggYSByZWxpYWJsZSByZXByb2R1Y2VyIHNjcmlwdC4gIEkgd2FzDQo+IGFi bGUgdG8gcmVwcm9kdWNlIHRoZSBwcm9ibGVtIHN0YXJ0aW5nIHdpdGggUnlvIE1hdHN1bXVyYSdz IHNjcmlwdCBhbmQNCj4gYXR0YWNoaW5nIGEgcmVwbGljYTsgbW9zdCBvZiB0aGUgdGltZSB0aGUg cmVwbGljYSB3b3VsZCByZWNvdmVyIGJ5DQo+IHJlc3RhcnRpbmcgZnJvbSBhIHN0cmVhbWluZyBw b3NpdGlvbiBlYXJsaWVyIHRoYW4gd2hlcmUgdGhlIHByb2JsZW0NCj4gb2NjdXJyZWQ7IGJ1dCBh IGZldyB0aW1lcyBpdCB3b3VsZCBqdXN0IGdldCBzdHVjayB3aXRoIGEgV0FMIHNlZ21lbnQNCj4g Y29udGFpbmluZyBhIGJvZ3VzIHJlY29yZC4gIFRoZW4sIGFmdGVyIHBhdGNoLCB0aGUgcHJvYmxl bSBubyBsb25nZXINCj4gb2NjdXJzLg0KDQpJZiBtb3ZpbmcgUmVnaXN0ZXJTZWdtZW50Qm91bmRh cnkoKSBpcyBzdWZmaWNpZW50IHRvIHByZXZlbnQgdGhlIGZsdXNoDQpwb2ludGVyIGZyb20gYWR2 YW5jaW5nIGJlZm9yZSB3ZSByZWdpc3RlciB0aGUgYm91bmRhcnksIEkgYmV0IHdlIGNvdWxkDQph bHNvIHJlbW92ZSB0aGUgV0FMIHdyaXRlciBudWRnZS4NCg0KQW5vdGhlciBpbnRlcmVzdGluZyB0 aGluZyBJIHNlZSBpcyB0aGF0IHRoZSBib3VuZGFyeSBzdG9yZWQgaW4NCmVhcmxpZXN0U2VnQm91 bmRhcnkgaXMgbm90IG5lY2Vzc2FyaWx5IHRoZSBlYXJsaWVzdCBvbmUuICBJdCdzIGp1c3QNCnRo ZSBmaXJzdCBvbmUgdGhhdCBoYXMgYmVlbiByZWdpc3RlcmVkLiAgSSBkaWQgdGhpcyBmb3Igc2lt cGxpY2l0eSBmb3INCnRoZSAucmVhZHkgZmlsZSBmaXgsIGJ1dCBJIGNhbiBzZWUgaXQgY2F1c2lu ZyBwcm9ibGVtcyBoZXJlLiAgSSB0aGluaw0Kd2UgY2FuIG1vdmUgZWFybGllc3RTZWdCb3VuZGFy eSBiYWNrd2FyZHMgYXMgbG9uZyBhcyBpdCBpcyBncmVhdGVyDQp0aGFuIGxhc3ROb3RpZmllZFNl ZyArIDEuICBIb3dldmVyLCBpdCdzIHN0aWxsIG5vdCBuZWNlc3NhcmlseSB0aGUNCmVhcmxpZXN0 IG9uZSBpZiB3ZSBjb3BpZWQgbGF0ZXN0U2VnQm91bmRhcnkgdG8gZWFybGllc3RTZWdCb3VuZGFy eSBpbg0KTm90aWZ5U2VnbWVudHNSZWFkeUZvckFyY2hpdmUoKS4gIFRvIGhhbmRsZSB0aGlzLCB3 ZSBjb3VsZCB0cmFjaw0Kc2V2ZXJhbCBib3VuZGFyaWVzIGluIGFuIGFycmF5LCBidXQgdGhlbiB3 ZSdkIGhhdmUgdG8gaG9sZCB0aGUgc2FmZQ0KTFNOIGJhY2sgd2hlbmV2ZXIgdGhlIGFycmF5IG92 ZXJmbG93ZWQgYW5kIHdlIHN0YXJ0ZWQgZm9yZ2V0dGluZw0KYm91bmRhcmllcy4NCg0KUGVyaGFw cyB0aGVyZSdzIGEgc2ltcGxlciBzb2x1dGlvbi4gIEknbGwga2VlcCB0aGlua2luZy4uLg0KDQpO YXRoYW4NCg0K