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 1mueMf-00060E-6j for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Dec 2021 17:34:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mueMd-00009M-Ub for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Dec 2021 17:34:51 +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 1mueMd-00009D-Bb for pgsql-hackers@lists.postgresql.org; Tue, 07 Dec 2021 17:34:51 +0000 Received: from smtp-fw-80007.amazon.com ([99.78.197.218]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mueMa-0003j1-PE for pgsql-hackers@lists.postgresql.org; Tue, 07 Dec 2021 17:34:50 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1638898489; x=1670434489; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=8fSJhHxlINYGMGdlrxg1y5qBD1CEd4Amz8Eq8ewpGho=; b=b65/j6liAoxEvg/zfieFBQ7FlgN8qKXXoxZiNuYiWPlMHR9UQz8uexFz IFF179TitsFJ5MwvYeYp6mfR8K60ASfPgeH2FiaG70E1YfedJ4O0iAtMR CwgAljpbp6EephHiA3/ORY17OsJI+aGm5SaSmMBR1jaFgoPe1UgusQBUu 0=; X-IronPort-AV: E=Sophos;i="5.87,293,1631577600"; d="scan'208";a="46780919" Subject: Re: Pre-allocating WAL files Thread-Topic: Pre-allocating WAL files Received: from pdx4-co-svc-p1-lb2-vlan2.amazon.com (HELO email-inbound-relay-pdx-2a-92ba9394.us-west-2.amazon.com) ([10.25.36.210]) by smtp-border-fw-80007.pdx80.corp.amazon.com with ESMTP; 07 Dec 2021 17:34:47 +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-2a-92ba9394.us-west-2.amazon.com (Postfix) with ESMTPS id 3487E423E0; Tue, 7 Dec 2021 17:34:47 +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 17:34:46 +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 17:34:46 +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 17:34:46 +0000 From: "Bossart, Nathan" To: Bharath Rupireddy CC: Maxim Orlov , "pgsql-hackers@lists.postgresql.org" Thread-Index: AQHXWav8+6ha4BKnPEG53jEY0XwfWasIN++AgCyQ/oCAb1ZkgIAihiGAgDbrVgCAKkSLAIAAEquA Date: Tue, 7 Dec 2021 17:34:46 +0000 Message-ID: <96E4FEA2-331C-46DF-8F78-6F8B86FD2142@amazon.com> References: <20201225200953.jjkrytlrzojbndh5@alap3.anarazel.de> <51BAAB3B-9D3C-4155-B125-42E4F06DCDF4@amazon.com> <163352276350.15435.3988688227048304232.pgcf@coridan.postgresql.org> In-Reply-To: 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.223] Content-Type: text/plain; charset="utf-8" Content-ID: <2D1815163B8BBD40A58AD8AB3364893F@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 T24gMTIvNy8yMSwgMTI6MjkgQU0sICJCaGFyYXRoIFJ1cGlyZWRkeSIgPGJoYXJhdGgucnVwaXJl ZGR5Zm9ycG9zdGdyZXNAZ21haWwuY29tPiB3cm90ZToNCj4gV2h5IGNhbid0IHRoZSB3YWx3cml0 ZXIgcHJlLWFsbG9jYXRlIHNvbWUgb2YgdGhlIFdBTCBzZWdtZW50cyBpbnN0ZWFkDQo+IG9mIGEg bmV3IGJhY2tncm91bmQgcHJvY2Vzcz8gT2YgY291cnNlLCBpdCBtaWdodCBkZWxheSB0aGUgbWFp bg0KPiBmdW5jdGlvbmFsaXR5IG9mIHRoZSB3YWx3cml0ZXIgaS5lLiBmbHVzaCBhbmQgc3luYyB0 aGUgV0FMIGZpbGVzLCBidXQNCj4gaGF2aW5nIGNoZWNrcG9pbnRlciBkbyB0aGUgcHJlLWFsbG9j YXRpb24gbWFrZXMgaXQgZG8gYW5vdGhlciBleHRyYQ0KPiB0YXNrLiBIZXJlIHRoZSBhbW91bnQg b2Ygd2Fsd3JpdGVyIHdvcmsgdnMgY2hlY2twb2ludGVyIHdvcmssIEknbSBub3QNCj4gc3VyZSB3 aGljaCBvbmUgZG9lcyBtb3JlIHdvcmsgY29tcGFyZWQgdG8gdGhlIG90aGVyLg0KDQpUaGUgYXJn dW1lbnQgYWdhaW5zdCBhZGRpbmcgaXQgdG8gdGhlIFdBTCB3cml0ZXIgaXMgdGhhdCB3ZSB3YW50 IGl0IHRvDQpydW4gd2l0aCBsb3cgbGF0ZW5jeSB0byBmbHVzaCBhc3luY2hyb25vdXMgY29tbWl0 cy4gIElmIHdlIGFkZGVkIFdBTA0KcHJlLWFsbG9jYXRpb24gdG8gdGhlIFdBTCB3cml0ZXIsIHRo ZXJlIGNvdWxkIHBlcmlvZGljYWxseSBiZSBsYXJnZQ0KZGVsYXlzLg0KDQo+IEFub3RoZXIgaWRl YSBjb3VsZCBiZSB0byBsZXQgd2Fsd3J0aWVyIG9yIGNoZWNrcG9pbnRlciBwcmUtYWxsb2NhdGUN Cj4gdGhlIFdBTCBmaWxlcyB3aGljaGV2ZXIgc2VlbXMgZnJlZSBhcy1vZi10aGUtbW9tZW50IHdo ZW4gdGhlIFdBTA0KPiBzZWdtZW50IHByZS1hbGxvY2F0aW9uIHJlcXVlc3QgY29tZXMuIFdlIGNh biBnbyBmdXJ0aGVyIHRvIGxldCB0aGUNCj4gdXNlciBjaG9vc2Ugd2hpY2ggcHJvY2VzcyBpLmUu IGNoZWNrcG9pbnRlciBvciB3YWx3cnRpZXIgZG8gdGhlDQo+IHByZS1hbGxvY2F0aW9uIHdpdGgg YSBHVUMgbWF5YmU/DQoNCk15IGxhdGVzdCBwYXRjaCBzZXQgWzBdIGFkZHMgV0FMIHByZS1hbGxv Y2F0aW9uIHRvIHRoZSBjaGVja3BvaW50ZXIuDQpJbiB0aGF0IHBhdGNoIHNldCwgV0FMIHByZS1h bGxvY2F0aW9uIGlzIGRvbmUgYm90aCBvdXRzaWRlIG9mDQpjaGVja3BvaW50cyBhcyB3ZWxsIGFz IGR1cmluZyBjaGVja3BvaW50cyAodmlhDQpDaGVja1BvaW50V3JpdGVEZWxheSgpKS4gIA0KDQpO YXRoYW4NCg0KWzBdIGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL21lc3NhZ2UtaWQvQ0IxNUJF QkQtOThGQy00RTcyLTg2QUUtNTEzRDM0MDE0MTc2JTQwYW1hem9uLmNvbQ0KDQo=