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 1oVNfK-0004g1-LF for pgsql-hackers@arkaria.postgresql.org; Tue, 06 Sep 2022 01:46:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oVNfI-0006QA-Ul for pgsql-hackers@arkaria.postgresql.org; Tue, 06 Sep 2022 01:46:12 +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 1oVNfI-0006Q0-LM for pgsql-hackers@lists.postgresql.org; Tue, 06 Sep 2022 01:46:12 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oVNfE-0007ox-UK for pgsql-hackers@postgresql.org; Tue, 06 Sep 2022 01:46:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:From:References:Cc: To:Subject:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=Wy0NvLfl6L29JdCfWRGVeD2jP6aeWJzQ+Us629A5gDI=; b=scaW7Z3SoJjLd66plHYhKxEOG3 oY8ysrLc8Gh9BbpcM/ADgwpYb825E1YoBnD7fQD96n+7g7vvRV41Kjg6tYPWXnhTxdgQ8w3J3nLJX 1wwU4Ldd7IMldpvT9bBTxmFp5uhxsWgWqUxdPnMMcINmJ/5IhSPXxZMFDK9C0qLsH/Hx0C0hvVofH leEOfwowsNHM8S8hWA7ARDrEZy7rMa4tzi60Ffhz8SzGqHrvkhalOt42SbG/hbpk77I72mb96MCqf pEQcqlKtfmguHSa+apJhX1TD+eJR6ImcN92Ae5WZffEJDbtzo6fW+RG/J+h2hHwJK/5iR/+gqLUO3 8TFHgwmA==; Received: from [52.119.84.106] (helo=[192.168.88.177]) by meldrar.postgresql.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oVNf3-00076F-AO; Tue, 06 Sep 2022 01:45:59 +0000 Message-ID: <7b52105d-b1ae-1c51-1794-2280e7c8cf06@postgresql.org> Date: Mon, 5 Sep 2022 21:45:48 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.13.0 Subject: Re: pg15b3: recovery fails with wal prefetch enabled Content-Language: en-US To: Thomas Munro , Kyotaro Horiguchi Cc: Justin Pryzby , "Shinoda, Noriyoshi (PN Japan FSIP)" , Tomas Vondra , Stephen Frost , Andres Freund , Alvaro Herrera , Tomas Vondra , Dmitry Dolgov <9erthalion6@gmail.com>, David Steele , pgsql-hackers , Tom Lane References: <20220905.143436.1254379754225361598.horikyota.ntt@gmail.com> From: "Jonathan S. Katz" In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------jOJNxAsIsCQwhPxQ6wuBwQSK" X-Host-Lookup-Failed: Reverse DNS lookup failed for 52.119.84.106 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------jOJNxAsIsCQwhPxQ6wuBwQSK Content-Type: multipart/mixed; boundary="------------HQnaBCoOSOfNy0BRfHEVWt84"; protected-headers="v1" From: "Jonathan S. Katz" To: Thomas Munro , Kyotaro Horiguchi Cc: Justin Pryzby , "Shinoda, Noriyoshi (PN Japan FSIP)" , Tomas Vondra , Stephen Frost , Andres Freund , Alvaro Herrera , Tomas Vondra , Dmitry Dolgov <9erthalion6@gmail.com>, David Steele , pgsql-hackers , Tom Lane Message-ID: <7b52105d-b1ae-1c51-1794-2280e7c8cf06@postgresql.org> Subject: Re: pg15b3: recovery fails with wal prefetch enabled References: <20220905.143436.1254379754225361598.horikyota.ntt@gmail.com> In-Reply-To: --------------HQnaBCoOSOfNy0BRfHEVWt84 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOS81LzIyIDc6MTggUE0sIFRob21hcyBNdW5ybyB3cm90ZToNCj4gT24gTW9uLCBTZXAg NSwgMjAyMiBhdCA5OjA4IFBNIFRob21hcyBNdW5ybyA8dGhvbWFzLm11bnJvQGdtYWlsLmNv bT4gd3JvdGU6DQo+Pj4gQXQgTW9uLCAwNSBTZXAgMjAyMiAxNDoxNToyNyArMDkwMCAoSlNU KSwgS3lvdGFybyBIb3JpZ3VjaGkgPGhvcmlreW90YS5udHRAZ21haWwuY29tPiB3cm90ZSBp bg0KPj4+IEF0IE1vbiwgNSBTZXAgMjAyMiAxNjo1NDowNyArMTIwMCwgVGhvbWFzIE11bnJv IDx0aG9tYXMubXVucm9AZ21haWwuY29tPiB3cm90ZSBpbg0KPj4+PiBPbiByZWZsZWN0aW9u LCBpdCdkIGJlIGJldHRlciBub3QgdG8gY2xvYmJlciBhbnkgcHJlLWV4aXN0aW5nIGVycm9y DQo+Pj4+IHRoZXJlLCBidXQgcmVwb3J0IG9uZSBvbmx5IGlmIHRoZXJlIGlzbid0IG9uZSBh bHJlYWR5IHF1ZXVlZC4gIEkndmUNCj4+Pj4gZG9uZSB0aGF0IGluIHRoaXMgdmVyc2lvbiwg d2hpY2ggSSdtIHBsYW5uaW5nIHRvIGRvIGEgYml0IG1vcmUgdGVzdGluZw0KPj4+PiBvbiBh bmQgY29tbWl0IHNvb25pc2ggaWYgdGhlcmUgYXJlIG5vIGNvbW1lbnRzL29iamVjdGlvbnMs IGVzcGVjaWFsbHkNCj4+Pj4gZm9yIHRoYXQgcGFydC4NCj4gDQo+IFdlbGwgSSB3YXMgYWJv dXQgdG8gY29tbWl0IHRoaXMsIGJ1dCBiZXRhNCBqdXN0IGdvdCBzdGFtcGVkIChidXQgbm90 DQo+IHlldCB0YWdnZWQpLiAgSSBzZWUgbm93IHRoYXQgSm9uYXRoYW4gKHdpdGggUk1UIGhh dCBvbiwgQ0MnZCkgbWVhbnQNCj4gY29tbWl0cyBzaG91bGQgYmUgaW4gYnkgdGhlICpzdGFy dCogb2YgdGhlIDV0aCBBb0UsIG5vdCB0aGUgZW5kLiAgU28NCj4gdGhlIHByb2NlZHVyYWwv Uk1UIHF1ZXN0aW9uIGlzIHdoZXRoZXIgaXQncyBzdGlsbCBwb3NzaWJsZSB0byBjbG9zZQ0K PiB0aGlzIGl0ZW0gaW4gYmV0YTQuDQoNClByZXN1bWFibHkgYmVjYXVzZSBUb20gc3RhbXBl ZCBpdCwgdGhlIHJlbGVhc2VkIGlzIHdyYXBwZWQgc28gaXQgDQp3b3VsZG4ndCBtYWtlIEJl dGEgNCwgYnV0IEkgZGVmZXIgdG8gaGltIHRvIHNlZSBpZiBpdCBjYW4gYmUgaW5jbHVkZWQg DQp3aXRoIHRoZSB0YWcuDQoNClRoYXQgc2FpZCwgaWYgaXQgZG9lc24ndCBtYWtlIGl0IGZv ciBCZXRhIDQsIGl0IHdvdWxkIGJlIGluIHRoZSBuZXh0IA0KcmVsZWFzZSAod2hpY2ggaXMg aG9wZWZ1bGx5IFJDMSkuDQoNClRoYW5rcywNCg0KSm9uYXRoYW4NCg== --------------HQnaBCoOSOfNy0BRfHEVWt84-- --------------jOJNxAsIsCQwhPxQ6wuBwQSK Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmMWpkwFAwAAAAAACgkQ8QSccp8cZScN Mg/8CFTdLJpLIut6T6FuImWfBlsWdEQLAuRq5RGVQS9gPE2JECCdx7JLS04GGq1/22kk7SGM++HR VEdSdtU9VZLvGQ8pLjc0g3kaE9lHdhEl806/nj9YKqa86Zjw/AnB4vAupagWrUlFCzHT9g+6VNhz uZ8xR1ocTQ62WO5/w9sVEpw/sgayRDbzQiy00wrdu4CahYep4/bR5MUVwbWTtOyiXt7dWqR8fGJR vlrwIZUzefYqywQkIeYDJWGOHZL3OfBLBK21YRJ7wpiFd0MuGZNURuw82VFAqKWMhXZjIC0HFyd1 +AS5iaPnPjJYQOrIKCT6sQc8589fmdVz/z7UUrgqDS/UqlR7//17jmy550Xkn2f8O5HSuyl/e+ju 7kj8APmPlKlsdHueTsMdr/ho76hy6SY2IAv7pzNk/Ob7sS0y4yO9CzDaUoPULunSpAdI9yIQAWo3 AR5jc/9+wyKSeW6fIdtYzKuHkiyHkb7OGUbdZ81gdMxZHSgG2ZaF4SupkfzalqSUczrP+Ra2VGeN mX8Xvq50fUAVpGXXaVM6HQ7b75amMVgBWV+uC2tO6vgDhylkv28JMca6X1SMnWXBBbkY476kY+lY oPTBJSdVI2QI6rDnwKEzCOjkWNSIxqAxbkJergBgQFLJRC5LMEYb0eshCS7kzRg7b49Bfz14+FQl ioQ= =Gnrr -----END PGP SIGNATURE----- --------------jOJNxAsIsCQwhPxQ6wuBwQSK--