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 1mY5u4-0002Dx-LT for pgsql-hackers@arkaria.postgresql.org; Wed, 06 Oct 2021 12:20:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mY5u3-0002o8-Ji for pgsql-hackers@arkaria.postgresql.org; Wed, 06 Oct 2021 12:20:07 +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 1mY5u3-0002mf-C0 for pgsql-hackers@lists.postgresql.org; Wed, 06 Oct 2021 12:20:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mY5u1-0005Fv-1O for pgsql-hackers@lists.postgresql.org; Wed, 06 Oct 2021 12:20:06 +0000 Received: from coridan.postgresql.org ([2001:4800:3e1:1::213]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mY5u0-0005ba-9d for pgsql-hackers@lists.postgresql.org; Wed, 06 Oct 2021 12:20:04 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mY5tz-0005xB-8x for pgsql-hackers@lists.postgresql.org; Wed, 06 Oct 2021 12:20:03 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: Pre-allocating WAL files To: pgsql-hackers@lists.postgresql.org From: Maxim Orlov Cc: Nathan Bossart Date: Wed, 06 Oct 2021 12:19:23 +0000 User-Agent: pgcommitfest X-cfsender: m.orlov In-Reply-To: <51BAAB3B-9D3C-4155-B125-42E4F06DCDF4@amazon.com> References: <20201225200953.jjkrytlrzojbndh5@alap3.anarazel.de> <51BAAB3B-9D3C-4155-B125-42E4F06DCDF4@amazon.com> Message-ID: <163352276350.15435.3988688227048304232.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhlIGZvbGxvd2luZyByZXZpZXcgaGFzIGJlZW4gcG9zdGVkIHRocm91Z2ggdGhlIGNvbW1pdGZl c3QgYXBwbGljYXRpb246Cm1ha2UgaW5zdGFsbGNoZWNrLXdvcmxkOiAgdGVzdGVkLCBwYXNzZWQK SW1wbGVtZW50cyBmZWF0dXJlOiAgICAgICB0ZXN0ZWQsIGZhaWxlZApTcGVjIGNvbXBsaWFudDog ICAgICAgICAgIG5vdCB0ZXN0ZWQKRG9jdW1lbnRhdGlvbjogICAgICAgICAgICBub3QgdGVzdGVk CgpIaSENCg0KV2UndmUgbG9va2VkIHRocm91Z2ggdGhlIGNvZGUgYW5kIGV2ZXJ5dGhpbmcgbG9v a3MgZ29vZCBleGNlcHQgZmV3IG1pbm9yIHRoaW5nczoNCjEpLiBVc2luZyBkZWRpY2F0ZWQgYmcg d29ya2VyIHNlZW1zIG5vdCBvcHRpbWFsLCBpdCBpbnRyb2R1Y2VzIGEgbG90IG9mIHJlZHVuZGFu dCBjb2RlIGZvciBsaXR0bGUgc2luZ2xlIGFjdGlvbi4NCiAgICBXZSdkIGpvaW4gaW5pdGlhbCBw cm9wb3NhbCBvZiBBbmRyZXMgdG8gaW1wbGVtZW50IGl0IGFzIGFuIGV4dHJhIGZ1Y3Rpb24gb2Yg Y2hlY2twb2ludGVyLg0KMikuIEluIG91ciB2aWV3LCBpdCBpcyBiZXR0ZXIgc2hpZnQgI2RlZmlu ZSBQUkVBTExPQ1NFR0RJUiBvdXRzaWRlIHRoZSBmdW5jdGlvbiBib2R5Lg0KMykuIEl0IGlzIGJl dHRlciB0byBoYXZlIGF0IGxlYXN0IHNtYWxsIGNvbW1lbnRzIG9uIGZ1bmN0aW9ucyBHZXROdW1Q cmVhbGxvY2F0ZWRXYWxTZWdzLCBTZXROdW1QcmVhbGxvY2F0ZWRXYWxTZWdzLCANCg0KV2UndmUg YWxzbyB0ZXN0ZWQgcGVyZm9ybWFuY2UgZGlmZmVyZW5jZSBiZXR3ZWVuIG1hc3RlciBicmFuY2gg YW5kIHRoaXMgcGF0Y2ggYW5kIG5vdGljZWQgbm8gc2lnbmlmaWNhbnQgZGlmZmVyZW5jZSBpbiBw ZXJmb3JtYW5jZS4NCldlIHVzZWQgcGdiZW5jaCB3aXRoIHNvbWUgc29ydCBvZiAic3RhbmRhcmQi IHNldHRpbmdzOg0KJCBwZ2JlbmNoIC1jNTAgLXM1MCAtVDIwMCAtUDEgLXIgcG9zdGdyZXMNCi4u LmFuZCB3aXRoLi4uDQokIHBnYmVuY2ggLWMxMDAgLXM1MCAtVDIwMCAtUDEgLXIgcG9zdGdyZXMN Cg0KV2hlbiBsb29raW5nIGF0IGV2ZXJ5IHNlY29uZCBvdXRwdXQgb2YgcGdiZW5jaCB3ZSBzYXcg cmVndWxhciBzcGlrZXMgb2YgbGF0ZW5jeSAoYXJvdWQgNS0xMCB0aW1lcyBpbmNyZWFzZSkgYW5k IHRoaXMgcGF0dGVybiB3YXMgc2ltaWxhciB3aXRoIGFuZCB3aXRob3V0IHBhdGNoLiBPdmVyYWxs IGF2ZXJhZ2UgbGF0ZW5jeSBzdGF0IGZvciAyMDAgc2VjIG9mIHBnYmVuY2ggYWxzbyBsb29rcyBw cmV0dHkgbXVjaCB0aGUgc2FtZSB3aXRoIGFuZCB3aXRob3V0IHBhdGNoLiBDb3VsZCB5b3UgcHJv dmlkZSB5b3VyIHRlc3Rpbmcgc2V0dXAgdG8gc2VlIHRoZSBlZmZlY3QsIHBsZWFzZS4NCg0KVGhl IGNoZWNrLXdvcmxkIHdhcyBzdWNjZXNzZnVsbC4NCg0KT3ZlcmFsbCBwYXRjaCBsb29rcyBnb29k LCBidXQgaW4gb3VyIHZpZXcgaXQncyBiZXR0ZXIgdG8gaGF2ZSBleHBlcmltZW50YWwgc3VwcG9y dCBvZiB0aGUgcGVyZm9ybWFuY2UgaW1wcm92ZW1lbnRzIHRvIGJlIGNvbW1pdGVkLg0KDQotLS0N CkJlc3QgcmVnYXJkcywNCk1heGltIE9ybG92LCBQYXZlbCBCb3Jpc292LgoKVGhlIG5ldyBzdGF0 dXMgb2YgdGhpcyBwYXRjaCBpczogV2FpdGluZyBvbiBBdXRob3IK