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 1mY9pd-0003v3-K1 for pgsql-hackers@arkaria.postgresql.org; Wed, 06 Oct 2021 16:31: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 1mY9pc-0000w8-Hd for pgsql-hackers@arkaria.postgresql.org; Wed, 06 Oct 2021 16:31:48 +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 1mY9pc-0000vz-7r for pgsql-hackers@lists.postgresql.org; Wed, 06 Oct 2021 16:31:48 +0000 Received: from smtp-fw-6001.amazon.com ([52.95.48.154]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mY9pZ-0008AD-Vl for pgsql-hackers@lists.postgresql.org; Wed, 06 Oct 2021 16:31:47 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1633537906; x=1665073906; h=from:to:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=7iYqYPyBTjccuKNDhaJF+g/+TyMtZ7Sfm+4MTSQrkrw=; b=Yk4/KU8ebRWcZNCrmJsjNfZQGqmQAQTQrVNVPt6Tu1nvWrLKhno7m7iV AiM3GGBHf+q4iqkq7gMtU/WfbpgQXRs+r8VT0EzwzKkIa0BmG0NBdw0I3 l8WgAN9sKg94GKsH6NgpdI+HJ8stbSA2aqqsa6Rso1l4yuGmcVw/uIZKz 4=; X-IronPort-AV: E=Sophos;i="5.85,352,1624320000"; d="scan'208";a="147286804" Subject: Re: Pre-allocating WAL files Thread-Topic: Pre-allocating WAL files Received: from iad12-co-svc-p1-lb1-vlan3.amazon.com (HELO email-inbound-relay-pdx-2c-9ec26c6c.us-west-2.amazon.com) ([10.43.8.6]) by smtp-border-fw-6001.iad6.amazon.com with ESMTP; 06 Oct 2021 16:31:44 +0000 Received: from EX13MTAUWB001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan3.pdx.amazon.com [10.236.137.198]) by email-inbound-relay-pdx-2c-9ec26c6c.us-west-2.amazon.com (Postfix) with ESMTPS id 1B59641F79; Wed, 6 Oct 2021 16:31:43 +0000 (UTC) Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13MTAUWB001.ant.amazon.com (10.43.161.249) with Microsoft SMTP Server (TLS) id 15.0.1497.23; Wed, 6 Oct 2021 16:31:42 +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; Wed, 6 Oct 2021 16:31:42 +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; Wed, 6 Oct 2021 16:31:42 +0000 From: "Bossart, Nathan" To: Maxim Orlov , "pgsql-hackers@lists.postgresql.org" Thread-Index: AQHXWav8+6ha4BKnPEG53jEY0XwfWasIN++AgCyQ/oCAb1ZkgIAihiGA///RJwA= Date: Wed, 6 Oct 2021 16:31:42 +0000 Message-ID: <60A38487-AE37-4B57-8980-FB52D153A68B@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: <163352276350.15435.3988688227048304232.pgcf@coridan.postgresql.org> 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.199] Content-Type: text/plain; charset="utf-8" Content-ID: <35D06BB9D44AB1479374FF7892AE9234@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 T24gMTAvNi8yMSwgNToyMCBBTSwgIk1heGltIE9ybG92IiA8bS5vcmxvdkBwb3N0Z3Jlc3Byby5y dT4gd3JvdGU6DQo+IFdlJ3ZlIGxvb2tlZCB0aHJvdWdoIHRoZSBjb2RlIGFuZCBldmVyeXRoaW5n IGxvb2tzIGdvb2QgZXhjZXB0IGZldyBtaW5vciB0aGluZ3M6DQo+IDEpLiBVc2luZyBkZWRpY2F0 ZWQgYmcgd29ya2VyIHNlZW1zIG5vdCBvcHRpbWFsLCBpdCBpbnRyb2R1Y2VzIGEgbG90IG9mIHJl ZHVuZGFudCBjb2RlIGZvciBsaXR0bGUgc2luZ2xlIGFjdGlvbi4NCj4gICAgIFdlJ2Qgam9pbiBp bml0aWFsIHByb3Bvc2FsIG9mIEFuZHJlcyB0byBpbXBsZW1lbnQgaXQgYXMgYW4gZXh0cmEgZnVj dGlvbiBvZiBjaGVja3BvaW50ZXIuDQoNClRoYW5rcyBmb3IgdGFraW5nIGEgbG9vayENCg0KSSBo YXZlIGJlZW4gdGhpbmtpbmcgYWJvdXQgdGhlIHJpZ2h0IHBsYWNlIHRvIHB1dCB0aGlzIGxvZ2lj LiAgTXkNCmZpcnN0IHRob3VnaHQgaXMgdGhhdCBpdCBzb3VuZHMgbGlrZSBzb21ldGhpbmcgdGhh dCBvdWdodCB0byBnbyBpbiB0aGUNCldBTCB3cml0ZXIgcHJvY2VzcywgYnV0IGFzIEFuZHJlcyBu b3RlZCB1cHRocmVhZCwgdGhhdCBpcyB1bmRlc2lyYWJsZQ0KYmVjYXVzZSBpdCdsbCBhZGQgbGF0 ZW5jeSBmb3IgYXN5bmNocm9ub3VzIGNvbW1pdHMuICBUaGUgY2hlY2twb2ludGVyDQpwcm9jZXNz IHNlZW1zIHRvIGJlIGFub3RoZXIgY2FuZGlkYXRlLCBidXQgSSdtIG5vdCB0b3RhbGx5IHN1cmUg aG93DQppdCdsbCBmaXQgaW4uICBNeSBwYXRjaCB3b3JrcyBieSBtYWludGFpbmluZyBhIHNtYWxs IHBvb2wgb2YgcHJlLQ0KYWxsb2NhdGVkIHNlZ21lbnRzIHRoYXQgaXMgcXVpY2tseSByZXBsZW5p c2hlZCB3aGVuZXZlciBvbmUgaXMgdXNlZC4NCklmIHRoZSBjaGVja3BvaW50ZXIgaXMgc3BlbmRp bmcgbW9zdCBvZiBpdHMgdGltZSBjaGVja3BvaW50aW5nLCB0aGlzDQpzbWFsbCBwb29sIGNvdWxk IHJlbWFpbiBlbXB0eSBmb3IgbG9uZyBwZXJpb2RzIG9mIHRpbWUuICBUbyBrZWVwIHByZS0NCmFs bG9jYXRpbmcgV0FMIHdoaWxlIHdlJ3JlIGNoZWNrcG9pbnRpbmcsIHBlcmhhcHMgd2UgY291bGQg YWRkIGFub3RoZXINCmZ1bmN0aW9uIGxpa2UgQ2hlY2twb2ludFdyaXRlRGVsYXkoKSB0aGF0IGlz IGNhbGxlZCBwZXJpb2RpY2FsbHkuDQpUaGVyZSBzdGlsbCBtaWdodCBiZSBzZXZlcmFsIG9wZXJh dGlvbnMgaW4gQ2hlY2tQb2ludEd1dHMoKSB0aGF0IHRha2UNCmEgd2hpbGUgYW5kIGxlYXZlIHRo ZSBzZWdtZW50IHBvb2wgZW1wdHksIGJ1dCBtYXliZSB0aGF0J3Mgb2theSBmb3INCm5vdy4NCg0K TmF0aGFuDQoNCg==