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 1muhg8-00078E-0Y for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Dec 2021 21:07:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1muhfa-0006vj-N4 for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Dec 2021 21:06:38 +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 1muhfa-0006va-A8 for pgsql-hackers@lists.postgresql.org; Tue, 07 Dec 2021 21:06:38 +0000 Received: from smtp-fw-80006.amazon.com ([99.78.197.217]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1muhfX-0005Xr-8o for pgsql-hackers@lists.postgresql.org; Tue, 07 Dec 2021 21:06:37 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1638911196; x=1670447196; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-id:content-transfer-encoding: mime-version; bh=6zDdMNNPeQlKr3pGex+RkMe/8CfkrGh1qeiR5zAy8e8=; b=K6oIftOenTo0m7vVwNeBSoLuH5LNNeE+MS6+6YEKGZCLQ60FNVcUePZg xIMfZuAkuKUWNU54VKLNtFsWDovI9vEL3WMQ/Bqeuht+iDq+boQcKnYkw 08/QVBidsIHT/ZvHE4vV/ZwfjpZB3N+C+kVpFx7ue/lPIXIuXlw+lX6Cf E=; X-IronPort-AV: E=Sophos;i="5.87,295,1631577600"; d="scan'208";a="46851231" Received: from pdx4-co-svc-p1-lb2-vlan3.amazon.com (HELO email-inbound-relay-pdx-2b-1f9d5b26.us-west-2.amazon.com) ([10.25.36.214]) by smtp-border-fw-80006.pdx80.corp.amazon.com with ESMTP; 07 Dec 2021 21:06:01 +0000 Received: from EX13MTAUWB001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan2.pdx.amazon.com [10.236.137.194]) by email-inbound-relay-pdx-2b-1f9d5b26.us-west-2.amazon.com (Postfix) with ESMTPS id C0DD04227A; Tue, 7 Dec 2021 21:06:00 +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.26; Tue, 7 Dec 2021 21:01:13 +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.26; Tue, 7 Dec 2021 21:01:13 +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.026; Tue, 7 Dec 2021 21:01:12 +0000 From: "Bossart, Nathan" To: Bharath Rupireddy CC: Maxim Orlov , "pgsql-hackers@lists.postgresql.org" Subject: Re: Pre-allocating WAL files Thread-Topic: Pre-allocating WAL files Thread-Index: AQHX662RxOqXSm+pqkOQKRTdIvZAmg== Date: Tue, 7 Dec 2021 21:01:12 +0000 Message-ID: References: <20201225200953.jjkrytlrzojbndh5@alap3.anarazel.de> <51BAAB3B-9D3C-4155-B125-42E4F06DCDF4@amazon.com> <163352276350.15435.3988688227048304232.pgcf@coridan.postgresql.org> <96E4FEA2-331C-46DF-8F78-6F8B86FD2142@amazon.com> In-Reply-To: <96E4FEA2-331C-46DF-8F78-6F8B86FD2142@amazon.com> 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.161.102] Content-Type: text/plain; charset="utf-8" Content-ID: <37AFD7E72DE6AF45A0AA4DF9E45F6D12@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 T24gMTIvNy8yMSwgOTozNSBBTSwgIkJvc3NhcnQsIE5hdGhhbiIgPGJvc3NhcnRuQGFtYXpvbi5j b20+IHdyb3RlOg0KPiBPbiAxMi83LzIxLCAxMjoyOSBBTSwgIkJoYXJhdGggUnVwaXJlZGR5IiA8 YmhhcmF0aC5ydXBpcmVkZHlmb3Jwb3N0Z3Jlc0BnbWFpbC5jb20+IHdyb3RlOg0KPj4gV2h5IGNh bid0IHRoZSB3YWx3cml0ZXIgcHJlLWFsbG9jYXRlIHNvbWUgb2YgdGhlIFdBTCBzZWdtZW50cyBp bnN0ZWFkDQo+PiBvZiBhIG5ldyBiYWNrZ3JvdW5kIHByb2Nlc3M/IE9mIGNvdXJzZSwgaXQgbWln aHQgZGVsYXkgdGhlIG1haW4NCj4+IGZ1bmN0aW9uYWxpdHkgb2YgdGhlIHdhbHdyaXRlciBpLmUu IGZsdXNoIGFuZCBzeW5jIHRoZSBXQUwgZmlsZXMsIGJ1dA0KPj4gaGF2aW5nIGNoZWNrcG9pbnRl ciBkbyB0aGUgcHJlLWFsbG9jYXRpb24gbWFrZXMgaXQgZG8gYW5vdGhlciBleHRyYQ0KPj4gdGFz ay4gSGVyZSB0aGUgYW1vdW50IG9mIHdhbHdyaXRlciB3b3JrIHZzIGNoZWNrcG9pbnRlciB3b3Jr LCBJJ20gbm90DQo+PiBzdXJlIHdoaWNoIG9uZSBkb2VzIG1vcmUgd29yayBjb21wYXJlZCB0byB0 aGUgb3RoZXIuDQo+DQo+IFRoZSBhcmd1bWVudCBhZ2FpbnN0IGFkZGluZyBpdCB0byB0aGUgV0FM IHdyaXRlciBpcyB0aGF0IHdlIHdhbnQgaXQgdG8NCj4gcnVuIHdpdGggbG93IGxhdGVuY3kgdG8g Zmx1c2ggYXN5bmNocm9ub3VzIGNvbW1pdHMuICBJZiB3ZSBhZGRlZCBXQUwNCj4gcHJlLWFsbG9j YXRpb24gdG8gdGhlIFdBTCB3cml0ZXIsIHRoZXJlIGNvdWxkIHBlcmlvZGljYWxseSBiZSBsYXJn ZQ0KPiBkZWxheXMuDQoNClRvIHlvdXIgcG9pbnQgb24gdHJ5aW5nIHRvIGF2b2lkIGdpdmluZyB0 aGUgY2hlY2twb2ludGVyIGV4dHJhIHRhc2tzDQooYmFzaWNhbGx5IHdoYXQgd2UgYXJlIHRhbGtp bmcgYWJvdXQgb24gdGhlIG90aGVyIHRocmVhZCBbMF0pLCBXQUwNCnByZS1hbGxvY2F0aW9uIG1p Z2h0IG5vdCBiZSBvZiBtdWNoIGNvbmNlcm4gYmVjYXVzZSBpdCB3aWxsIGdlbmVyYWxseQ0KYmUg YSBzbWFsbCwgZml4ZWQgKGFuZCBjb25maWd1cmFibGUpIGFtb3VudCBvZiB3b3JrLCBhbmQgaXQg Y2FuIGJlDQpwZXJmb3JtZWQgY29uY3VycmVudGx5IHdpdGggdGhlIGNoZWNrcG9pbnQuICBQbHVz LCBXQUwgcHJlLWFsbG9jYXRpb24NCnNob3VsZCBvcmRpbmFyaWx5IGJlIHBoYXNlZCBvdXQgYXMg V0FMIHNlZ21lbnRzIGJlY29tZSBlbGlnaWJsZSBmb3INCnJlY3ljbGluZy4gIElNTyBpdCdzIG5v dCBjb21wYXJhYmxlIHRvIHRhc2tzIGxpa2UNCkNoZWNrUG9pbnRTbmFwQnVpbGQoKSB0aGF0IGNh biBkZWxheSBjaGVja3BvaW50aW5nIGZvciBhIGxvbmcgdGltZS4NCg0KTmF0aGFuDQoNClswXSBo dHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkL2ZsYXQvQzFFRTY0QjAtRDREQi00 MEYzLTk4QzgtMENFRDMyNEQzNENCJTQwYW1hem9uLmNvbQ0KDQo=