From: "Shinoda, Noriyoshi (PN Japan FSIP)" <noriyoshi.shinoda@hpe.com>
To: Thomas Munro <thomas.munro@gmail.com>
CC: Justin Pryzby <pryzby@telsasoft.com>,
        Tomas Vondra
	<tomas.vondra@enterprisedb.com>,
        Stephen Frost <sfrost@snowman.net>,
        "Andres
 Freund" <andres@anarazel.de>,
        Jakub Wartak <Jakub.Wartak@tomtom.com>,
        "Alvaro
 Herrera" <alvherre@2ndquadrant.com>,
        Tomas Vondra
	<tomas.vondra@2ndquadrant.com>,
        Dmitry Dolgov <9erthalion6@gmail.com>,
        "David
 Steele" <david@pgmasters.net>,
        pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: RE: WIP: WAL prefetch (another approach)
Thread-Topic: WIP: WAL prefetch (another approach)
Thread-Index: AQHYSn7R+FRCuoQZzU2BSX36Feokh6zlQAiAgAbCc/CAAAfaAIAAAH2A
Date: Tue, 12 Apr 2022 09:32:16 +0000
Message-ID: 
 <PH7PR84MB1885C60124FBA813850C83B4EEED9@PH7PR84MB1885.NAMPRD84.PROD.OUTLOOK.COM>
References: <eed83eaa-91e1-91fe-32d0-ece36c0fa810@enterprisedb.com>
 <20210214231815.GO27507@tamriel.snowman.net>
 <17b3f450-048c-f3a6-7086-259523f33cbc@enterprisedb.com>
 <20210317214331.GF20766@tamriel.snowman.net>
 <28c3352e-5388-6410-aae7-05907079e6c9@enterprisedb.com>
 <CA+hUKGLHTjbBPFX6E1ZCGVyQD30-vWtH=N6EcHEzW13q+jh7FQ@mail.gmail.com>
 <8dd2dcc2-0b6b-a4ab-c1b3-032c0a5ab1c3@enterprisedb.com>
 <CA+hUKGKmkKfH1h9XG5ctYCgqeOHGdN5bHMoQMZLR=+kLY0PQzA@mail.gmail.com>
 <CA+hUKGLsF8sEE+n3qoaV6+XjmYEwYoFVDbLPbYTGz7oGkL=iZA@mail.gmail.com>
 <20210409033703.GP6592@telsasoft.com> <20220407125555.GC24419@telsasoft.com>
 <CA+hUKGL4V4UvdJ+RFxCdp0Lq=63jit-7=SVZeyNQaWJtCEuPRw@mail.gmail.com>
 <PH7PR84MB1885401C5FAECB66521E7F91EEED9@PH7PR84MB1885.NAMPRD84.PROD.OUTLOOK.COM>
 <CA+hUKGJptHrMLYPF1s3NvS9rU3JzqtOOWAVfokBN7HCgEXtruQ@mail.gmail.com>
In-Reply-To: 
 <CA+hUKGJptHrMLYPF1s3NvS9rU3JzqtOOWAVfokBN7HCgEXtruQ@mail.gmail.com>
Accept-Language: ja-JP, en-US
Content-Language: ja-JP
x-ms-exchange-antispam-messagedata-chunkcount: 2
x-ms-exchange-antispam-messagedata-0: 
 =?utf-8?B?eGpuKzlBWHRJVVF0QXk0eDRLd2g3UXk0bHB6MXpGbmFhTTFMTmJEZ0xvc1hl?=
 =?utf-8?B?MjR0bS9pajFiWjkyZXJlcHZObE9HMjcraHByUjhIaXlvZjdnUDVNekM3ZDND?=
 =?utf-8?B?ODdSejAvNHNOTVlTVzhPYzdyUlVFck5rd20yMWVUTEpRbzRzR0h3emNKVzY0?=
 =?utf-8?B?eW1XalB6TnNBWnJSRGpPS1B5V1pHSk8yWkFNd2l0RXJCaG1zZlNJQ1A1OExa?=
 =?utf-8?B?anN5c0xWUVFOQVpFS0FEaUd1ZFpzWEYzaGpDd0FWY2RpTTBucDJsSnRDamU2?=
 =?utf-8?B?WWZTYnpCVVlacUhwNERXK1VjVFpWUWVyQk5wajMxMmU4eTJMMDd0d29Ha1N0?=
 =?utf-8?B?STZlWlJjZ2dnbitHNGxoeFdLUXpISktnbTlSTmpWVGVzZjRka0NsNWJuTkp4?=
 =?utf-8?B?QlJIeG5uWVgxNDFrWGRtZUU4MEZHZ01DeU1BeDAyeUs3K3ZFdy9qZ2dRblpM?=
 =?utf-8?B?NlJ5ejhOY2xCZGV5WTF4SHgzdGZrYXBrcUw0NGY3a3M1Ukw1RDlDTHU0SSti?=
 =?utf-8?B?dlk3QkdKZW5ONndkRVFaNmFyWFJIZ1hWblRqeU5CUjEveWtIUkloVS9Ub040?=
 =?utf-8?B?aVArdzJmbnRVdW1vL09hNDI0RHJoL1djeTBtNW9YNENyQjB1LzJTTVJRU3Br?=
 =?utf-8?B?VE9qSDdyZUhWQTkrMURtcVNiNWwvbXUvaVh6VThpTWpOcWlaaEMwS21lbklu?=
 =?utf-8?B?dTVLaWNsNjJjYmxiOE84UmdXKzMwblpuK1phaXlhb29NcG0vTW9Ccml0L21C?=
 =?utf-8?B?QVV4Wmk5SEJuUHUyeUNLeDMyNjNiZVFtdU1LMDNHUml6djRVS2t5QzR6Ujli?=
 =?utf-8?B?K1o3Mkx3ZlU1c2lZdjZhamxCc1NIR0VEcFpOVFFFL3hiaUw3NXlTVTZJM0tB?=
 =?utf-8?B?R3hMUmM3dlJmRjA1aThpTTFEZVBQSkRFRVRIQSt2YkdSSW85QlJQeDN5akpT?=
 =?utf-8?B?OVNkK2JvY1RNMndWSWxXZlFKT0N6NnRteC94Mk9xZWRvcHJQU0RXSjk5TW5R?=
 =?utf-8?B?cnNjSjJ5ODcxSE42VjRRUlJXMjZUWkZ5RnVScEJvQm1maEdQRTZ3MU1kZkkr?=
 =?utf-8?B?ZjdNVlBMTmF2RC9iUEViUDNRUndsOUxWbGMwYlprL0xLQ1FMYis2cm9HS3FQ?=
 =?utf-8?B?TlN6SWRyNUxwUXY3a1ZGeWhmNHFXU2xONGVzYUdOY1BIMHFCbUlvRjVmcTJB?=
 =?utf-8?B?SlFETHdYMzV6S0dOYzJhN2E3VWRCWitreXRjZEZlYkhlbjlab1h0TytPd3VR?=
 =?utf-8?B?UERJVmova1RjVlpZSGxueHJoUlM5R2g3YTkvelNaSlFXcFZUNXN0ZEFYNDQ5?=
 =?utf-8?B?TmdlTTdDZ1JvZHYzOXl4MHp0ZlFlNm9mczVNZURFc2dMWEtHRGJ0QnlHa2ZX?=
 =?utf-8?B?VFh6T3dROWEvWE5tYVorTlZwMmZDbHpNVEp2QldsL000ZDNVRjFwVUxvRzV3?=
 =?utf-8?B?UEY3SDBjQURqTkp5KzVrMUhIUEdwdU9vRlk2bXZVUEdnTVZCSmU2b0FzalFP?=
 =?utf-8?B?VHVVN1FXMnhnR1FWV3ZkVENvaVZXTi95NlRwYWYwaCtqVU8vODJzS0Y5UVk0?=
 =?utf-8?B?MlRsbFM4aG5LK0E5VDQ2emtvV0xzWDhrOVpHdWRNRGo1VWt5eHhWZldzSGtI?=
 =?utf-8?B?TmlsOVBWZjZzVHhBY2I2RU4zYUZtSEZtWjM5cEp6bGgxYWFyWWFNU2t6UTk5?=
 =?utf-8?B?aTRKM3VDaUdYY1I1d3FuTGhYemdsMUhGRm55RXN3aDllN1dSODQwWTd5L09k?=
 =?utf-8?B?cTFsKzhHZExJSEI4UjZFc0JBOUYrMmhaTnptYWtOV3BvQlRBRTRFdEhFeUww?=
 =?utf-8?B?VDdiZ1lNUWp1bTFLQy9kLzM0bVIwWVFEOFM3UmtqRVZMTWJKbjdpc0M2SUVl?=
 =?utf-8?B?UEh1SEpTNDViY3ZEWmIrbDhxVUcvdHpvYkJTdUNSaDllN1hqWEpMU0FoTTlS?=
 =?utf-8?B?SjN5SEgvakRPWTZQVUN6K0RzeEdrQ0ZZWnN2SDFOaHBjTlZqOUdZUWptWXQz?=
 =?utf-8?B?Y21RdEhGZFg2Tm1mUEJiSzJ4M2hBZWRMdExDS0ZickxYd3U3RjhyWVhoMlRH?=
 =?utf-8?B?UWJSaHZRa3E2bjdnWTFDNHhhdFB1SUtGb0hvc0lYSHdZUFBycFMzU29qQlIy?=
 =?utf-8?B?WlVTd1poSjRRN1Fzb2tVa2lFS21Cbk9lREJLbWppbldHeXRsYVlQOStnUDY1?=
 =?utf-8?B?N29qTE9vWXVMTXRjOE56dXVkWktHNmdGTFIrZnBUVzNpUnptaFZ0SHpHaGF0?=
 =?utf-8?B?N3N4OVVML01aaFIyQVh6UWF4RXVNelFFV3hqTUZOQ3lqU1NUbWwrZVpQMnZw?=
 =?utf-8?B?RE9FMjRGSVA5TldjbmdJMi9sUWEvSkIrZnVPWEwrSjc5ak44M1JkYXYrS1RR?=
 =?utf-8?Q?DIDmtAWf5vaiwkHZVLd5yDNuOhjWdScR1JV3QrexPzAHc?=
x-ms-exchange-antispam-messagedata-1: XczLfdFwco0EOKglkfjAZlWaPOmWOIpz2dY=
Content-Type: text/plain; charset="utf-8"
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: PH7PR84MB1885.NAMPRD84.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 8cb9e759-acd6-4ab2-d612-08da1c675569
X-MS-Exchange-CrossTenant-originalarrivaltime: 12 Apr 2022 09:32:16.4993
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 105b2061-b669-4b31-92ac-24d304d195dc
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 A8EcsbkI4pNEH98DS91XmCGHoKDYkGb5WN8iRL8VMOxTA0d7II+WdTccPdps7PZRAefhthYQCOC+2yvZBwMHq9Hov0ip8aRkKIwfKr4u5Is=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: MW4PR84MB1849
X-OriginatorOrg: hpe.com
X-Proofpoint-ORIG-GUID: 99wGd-0sjEbfsM01PRfE6UlT3I1ZIKDU
X-Proofpoint-GUID: 99wGd-0sjEbfsM01PRfE6UlT3I1ZIKDU
Content-Transfer-Encoding: base64
X-Proofpoint-UnRewURL: 1 URL was un-rewritten
MIME-Version: 1.0
X-HPE-SCL: -1
X-Proofpoint-Virus-Version: vendor=baseguard
 engine=ICAP:2.0.205,Aquarius:18.0.858,Hydra:6.0.425,FMLib:17.11.64.514
 definitions=2022-04-12_03,2022-04-11_01,2022-02-23_01
X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0
 bulkscore=0 suspectscore=0
 spamscore=0 clxscore=1015 mlxscore=0 priorityscore=1501 phishscore=0
 adultscore=0 mlxlogscore=999 malwarescore=0 impostorscore=0
 lowpriorityscore=0 classifier=spam adjust=0 reason=mlx scancount=1
 engine=8.12.0-2202240000 definitions=main-2204120044
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/PH7PR84MB1885C60124FBA813850C83B4EEED9%40PH7PR84MB1885.NAMPRD84.PROD.OUTLOOK.COM>
Precedence: bulk

SGksDQpUaGFuayB5b3UgZm9yIHlvdXIgcmVwbHkuIA0KSSBtaXNzZWQgdGhlIG1lc3NhZ2UsIHNv
cnJ5Lg0KDQpSZWdhcmRzLA0KTm9yaXlvc2hpIFNoaW5vZGENCg0KLS0tLS1PcmlnaW5hbCBNZXNz
YWdlLS0tLS0NCkZyb206IFRob21hcyBNdW5ybyA8dGhvbWFzLm11bnJvQGdtYWlsLmNvbT4gDQpT
ZW50OiBUdWVzZGF5LCBBcHJpbCAxMiwgMjAyMiA2OjI4IFBNDQpUbzogU2hpbm9kYSwgTm9yaXlv
c2hpIChQTiBKYXBhbiBGU0lQKSA8bm9yaXlvc2hpLnNoaW5vZGFAaHBlLmNvbT4NCkNjOiBKdXN0
aW4gUHJ5emJ5IDxwcnl6YnlAdGVsc2Fzb2Z0LmNvbT47IFRvbWFzIFZvbmRyYSA8dG9tYXMudm9u
ZHJhQGVudGVycHJpc2VkYi5jb20+OyBTdGVwaGVuIEZyb3N0IDxzZnJvc3RAc25vd21hbi5uZXQ+
OyBBbmRyZXMgRnJldW5kIDxhbmRyZXNAYW5hcmF6ZWwuZGU+OyBKYWt1YiBXYXJ0YWsgPEpha3Vi
LldhcnRha0B0b210b20uY29tPjsgQWx2YXJvIEhlcnJlcmEgPGFsdmhlcnJlQDJuZHF1YWRyYW50
LmNvbT47IFRvbWFzIFZvbmRyYSA8dG9tYXMudm9uZHJhQDJuZHF1YWRyYW50LmNvbT47IERtaXRy
eSBEb2xnb3YgPDllcnRoYWxpb242QGdtYWlsLmNvbT47IERhdmlkIFN0ZWVsZSA8ZGF2aWRAcGdt
YXN0ZXJzLm5ldD47IHBnc3FsLWhhY2tlcnMgPHBnc3FsLWhhY2tlcnNAcG9zdGdyZXNxbC5vcmc+
DQpTdWJqZWN0OiBSZTogV0lQOiBXQUwgcHJlZmV0Y2ggKGFub3RoZXIgYXBwcm9hY2gpDQoNCk9u
IFR1ZSwgQXByIDEyLCAyMDIyIGF0IDk6MDMgUE0gU2hpbm9kYSwgTm9yaXlvc2hpIChQTiBKYXBh
biBGU0lQKSA8bm9yaXlvc2hpLnNoaW5vZGFAaHBlLmNvbT4gd3JvdGU6DQo+IFRoYW5rIHlvdSBm
b3IgZGV2ZWxvcGluZyB0aGUgZ3JlYXQgZmVhdHVyZS4gSSB0ZXN0ZWQgdGhpcyBmZWF0dXJlIGFu
ZCBjaGVja2VkIHRoZSBkb2N1bWVudGF0aW9uLiBDdXJyZW50bHksIHRoZSBkb2N1bWVudGF0aW9u
IGZvciB0aGUgcGdfc3RhdF9wcmVmZXRjaF9yZWNvdmVyeSB2aWV3IGlzIGluY2x1ZGVkIGluIHRo
ZSBkZXNjcmlwdGlvbiBmb3IgdGhlIHBnX3N0YXRfc3Vic2NyaXB0aW9uIHZpZXcuDQo+DQo+IElO
VkFMSUQgVVJJIFJFTU9WRUQNCj4gdG9yaW5nLXN0YXRzLmh0bWwqTU9OSVRPUklORy1QRy1TVEFU
LVNVQlNDUklQVElPTl9fO0l3ISFOcHhSIXhSdTd6YzRIYw0KPiBacHBCLTMyRnAzWWZFU1BxSjdC
NEFPUF9SRjdRdVlQLWtDV2lkb2lKNXR4dTlDVzhzWDYxVGZ3ZGRFJA0KDQpIaSEgIFRoYW5rcy4g
IEkgaGFkIGp1c3QgY29tbWl0dGVkIGEgZml4IGJlZm9yZSBJIHNhdyB5b3VyIG1lc3NhZ2UsIGJl
Y2F1c2UgdGhlcmUgd2FzIGFscmVhZHkgYW5vdGhlciByZXBvcnQgaGVyZToNCg0KaHR0cHM6Ly93
d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC9mbGF0L0NBS3JBS2VWay1MUkhNZHlUNnhfcDMz
ZUY2ZENvck0yamVkNWhfZUhkUmR2MHJlU1lUQUBtYWlsLmdtYWlsLmNvbSANCg==