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 1ncMog-0003Ir-LU for pgsql-committers@arkaria.postgresql.org; Thu, 07 Apr 2022 07:44:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ncMof-0004q3-I5 for pgsql-committers@arkaria.postgresql.org; Thu, 07 Apr 2022 07:44:29 +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 1ncMof-0004pg-AZ for pgsql-committers@lists.postgresql.org; Thu, 07 Apr 2022 07:44:29 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ncMoY-00071B-OZ for pgsql-committers@lists.postgresql.org; Thu, 07 Apr 2022 07:44:28 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=/Obr2zQJGFjhTRwwcV0mJewU5o1VpxKUtQaDNY0o0ug=; b=mGoCp9naTc2qk1gtEyMBH2c9hM FRkrhuKzfijopCy/zFgecVjuJ/cgtVzddfV+xjJbrVydmKPNi4U2j2oU+0FSGvDR8LjVEkX3feDTg 58EkkwhEhGtDEfIwTr8Xz5sYZosy+z/CnjnWXjPteuurC5q2Xty9JMNyCOJTQ5PAJvnpZRHJrWk/i 9adVpxXDE8N3nHjUYUJLXNAiPPD/FY6+KhRLbuYU5qqWpz+Xsxtr+k9D0KvdhiO0yDE3QcfCfTtsh q+x59WbINVZ/rYAJ24ozwqVrQBzgZCW5PEJcrXNZKFvVUav0X7+sx6bLkLX576CZkUwgMuT72JeF/ CR5ubqPw==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ncMoX-0004vS-H8 for pgsql-committers@lists.postgresql.org; Thu, 07 Apr 2022 07:44:21 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ncMoW-000hhv-4s for pgsql-committers@lists.postgresql.org; Thu, 07 Apr 2022 07:44:20 +0000 Content-Type: multipart/mixed; boundary="===============3810760212910290623==" MIME-Version: 1.0 From: Thomas Munro To: pgsql-committers@lists.postgresql.org Subject: pgsql: Prefetch data referenced by the WAL, take II. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 07 Apr 2022 07:44:20 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3810760212910290623== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UHJlZmV0Y2ggZGF0YSByZWZlcmVuY2VkIGJ5IHRoZSBXQUwsIHRha2UgSUkuCgpJbnRyb2R1Y2Ug YSBuZXcgR1VDIHJlY292ZXJ5X3ByZWZldGNoLiAgV2hlbiBlbmFibGVkLCBsb29rIGFoZWFkIGlu IHRoZQpXQUwgYW5kIHRyeSB0byBpbml0aWF0ZSBhc3luY2hyb25vdXMgcmVhZGluZyBvZiByZWZl cmVuY2VkIGRhdGEgYmxvY2tzCnRoYXQgYXJlIG5vdCB5ZXQgY2FjaGVkIGluIG91ciBidWZmZXIg cG9vbC4gIEZvciBub3csIHRoaXMgaXMgZG9uZSB3aXRoCnBvc2l4X2ZhZHZpc2UoKSwgd2hpY2gg aGFzIHNldmVyYWwgY2F2ZWF0cy4gIFNpbmNlIG5vdCBhbGwgT1NlcyBoYXZlCnRoYXQgc3lzdGVt IGNhbGwsICJ0cnkiIGlzIHByb3ZpZGVkIHNvIHRoYXQgaXQgY2FuIGJlIGVuYWJsZWQgd2hlcmUK YXZhaWxhYmxlLiAgQmV0dGVyIG1lY2hhbmlzbXMgZm9yIGFzeW5jaHJvbm91cyBJL08gYXJlIHBv c3NpYmxlIGluIGxhdGVyCndvcmsuCgpTZXQgdG8gInRyeSIgZm9yIG5vdyBmb3IgdGVzdCBjb3Zl cmFnZS4gIERlZmF1bHQgc2V0dGluZyB0byBiZSBmaW5hbGl6ZWQKYmVmb3JlIHJlbGVhc2UuCgpU aGUgR1VDIHdhbF9kZWNvZGVfYnVmZmVyX3NpemUgbGltaXRzIHRoZSBkaXN0YW5jZSB3ZSBjYW4g bG9vayBhaGVhZCBpbgpieXRlcyBvZiBkZWNvZGVkIGRhdGEuCgpUaGUgZXhpc3RpbmcgR1VDIG1h aW50ZW5hbmNlX2lvX2NvbmN1cnJlbmN5IGlzIHVzZWQgdG8gbGltaXQgdGhlIG51bWJlcgpvZiBj b25jdXJyZW50IEkvT3MgYWxsb3dlZCwgYmFzZWQgb24gcGVzc2ltaXN0aWMgaGV1cmlzdGljcyB1 c2VkIHRvCmluZmVyIHRoYXQgSS9PcyBoYXZlIGJlZ3VuIGFuZCBjb21wbGV0ZWQuICBXZSdsbCBh bHNvIG5vdCBsb29rIG1vcmUgdGhhbgptYWludGVuYW5jZV9pb19jb25jdXJyZW5jeSAqIDQgYmxv Y2sgcmVmZXJlbmNlcyBhaGVhZC4KClJldmlld2VkLWJ5OiBKdWxpZW4gUm91aGF1ZCA8cmp1anUx MjNAZ21haWwuY29tPgpSZXZpZXdlZC1ieTogVG9tYXMgVm9uZHJhIDx0b21hcy52b25kcmFAMm5k cXVhZHJhbnQuY29tPgpSZXZpZXdlZC1ieTogQWx2YXJvIEhlcnJlcmEgPGFsdmhlcnJlQDJuZHF1 YWRyYW50LmNvbT4gKGVhcmxpZXIgdmVyc2lvbikKUmV2aWV3ZWQtYnk6IEFuZHJlcyBGcmV1bmQg PGFuZHJlc0BhbmFyYXplbC5kZT4gKGVhcmxpZXIgdmVyc2lvbikKUmV2aWV3ZWQtYnk6IEp1c3Rp biBQcnl6YnkgPHByeXpieUB0ZWxzYXNvZnQuY29tPiAoZWFybGllciB2ZXJzaW9uKQpUZXN0ZWQt Ynk6IFRvbWFzIFZvbmRyYSA8dG9tYXMudm9uZHJhQDJuZHF1YWRyYW50LmNvbT4gKGVhcmxpZXIg dmVyc2lvbikKVGVzdGVkLWJ5OiBKYWt1YiBXYXJ0YWsgPEpha3ViLldhcnRha0B0b210b20uY29t PiAoZWFybGllciB2ZXJzaW9uKQpUZXN0ZWQtYnk6IERtaXRyeSBEb2xnb3YgPDllcnRoYWxpb242 QGdtYWlsLmNvbT4gKGVhcmxpZXIgdmVyc2lvbikKVGVzdGVkLWJ5OiBTYWl0IFRhbGhhIE5pc2Fu Y2kgPFNhaXQuTmlzYW5jaUBtaWNyb3NvZnQuY29tPiAoZWFybGllciB2ZXJzaW9uKQpEaXNjdXNz aW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBJTJCaFVLR0o0VkpOOHR0eFNjVUZNOGRPS1gwQnJC aWJvbzV1ejFjcSUzREFvdk9kZGZIcEElNDBtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQpt YXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21t aXRkaWZmLzVkYzA0MThmYWIyODFkMDE3YTYxYTU3NTYyNDA0NjdhZjk4MmJkZmQKCk1vZGlmaWVk IEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9jb25maWcuc2dtbCAgICAgICAgICAg ICAgICAgICAgICB8ICAgNjQgKysKZG9jL3NyYy9zZ21sL21vbml0b3Jpbmcuc2dtbCAgICAgICAg ICAgICAgICAgIHwgICA4NiArLQpkb2Mvc3JjL3NnbWwvd2FsLnNnbWwgICAgICAgICAgICAgICAg ICAgICAgICAgfCAgIDEyICsKc3JjL2JhY2tlbmQvYWNjZXNzL3RyYW5zYW0vTWFrZWZpbGUgICAg ICAgICAgIHwgICAgMSArCnNyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3hsb2cuYyAgICAgICAg ICAgICB8ICAgIDIgKwpzcmMvYmFja2VuZC9hY2Nlc3MvdHJhbnNhbS94bG9ncHJlZmV0Y2hlci5j ICAgfCAxMDgyICsrKysrKysrKysrKysrKysrKysrKysrKysKc3JjL2JhY2tlbmQvYWNjZXNzL3Ry YW5zYW0veGxvZ3JlYWRlci5jICAgICAgIHwgICAyNyArLQpzcmMvYmFja2VuZC9hY2Nlc3MvdHJh bnNhbS94bG9ncmVjb3ZlcnkuYyAgICAgfCAgMTc5ICsrLS0Kc3JjL2JhY2tlbmQvYWNjZXNzL3Ry YW5zYW0veGxvZ3V0aWxzLmMgICAgICAgIHwgICAyNyArLQpzcmMvYmFja2VuZC9jYXRhbG9nL3N5 c3RlbV92aWV3cy5zcWwgICAgICAgICAgfCAgIDE0ICsKc3JjL2JhY2tlbmQvc3RvcmFnZS9idWZm ZXIvYnVmbWdyLmMgICAgICAgICAgIHwgICAgNCArCnNyYy9iYWNrZW5kL3N0b3JhZ2UvZnJlZXNw YWNlL2ZyZWVzcGFjZS5jICAgICB8ICAgIDMgKy0Kc3JjL2JhY2tlbmQvc3RvcmFnZS9pcGMvaXBj aS5jICAgICAgICAgICAgICAgIHwgICAgMyArCnNyYy9iYWNrZW5kL3N0b3JhZ2Uvc21nci9tZC5j ICAgICAgICAgICAgICAgICB8ICAgIDYgKy0Kc3JjL2JhY2tlbmQvdXRpbHMvYWR0L3Bnc3RhdGZ1 bmNzLmMgICAgICAgICAgIHwgICAgNSArLQpzcmMvYmFja2VuZC91dGlscy9taXNjL2d1Yy5jICAg ICAgICAgICAgICAgICAgfCAgIDU1ICstCnNyYy9iYWNrZW5kL3V0aWxzL21pc2MvcG9zdGdyZXNx bC5jb25mLnNhbXBsZSB8ICAgIDYgKwpzcmMvaW5jbHVkZS9hY2Nlc3MveGxvZy5oICAgICAgICAg ICAgICAgICAgICAgfCAgICAxICsKc3JjL2luY2x1ZGUvYWNjZXNzL3hsb2dwcmVmZXRjaGVyLmgg ICAgICAgICAgIHwgICA1MyArKwpzcmMvaW5jbHVkZS9hY2Nlc3MveGxvZ3JlYWRlci5oICAgICAg ICAgICAgICAgfCAgICA4ICsKc3JjL2luY2x1ZGUvYWNjZXNzL3hsb2d1dGlscy5oICAgICAgICAg ICAgICAgIHwgICAgMyArLQpzcmMvaW5jbHVkZS9jYXRhbG9nL2NhdHZlcnNpb24uaCAgICAgICAg ICAgICAgfCAgICAyICstCnNyYy9pbmNsdWRlL2NhdGFsb2cvcGdfcHJvYy5kYXQgICAgICAgICAg ICAgICB8ICAgIDcgKwpzcmMvaW5jbHVkZS91dGlscy9ndWMuaCAgICAgICAgICAgICAgICAgICAg ICAgfCAgICA0ICsKc3JjL2luY2x1ZGUvdXRpbHMvZ3VjX3RhYmxlcy5oICAgICAgICAgICAgICAg IHwgICAgMSArCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcnVsZXMub3V0ICAgICAgICAgICB8 ICAgMTEgKwpzcmMvdG9vbHMvcGdpbmRlbnQvdHlwZWRlZnMubGlzdCAgICAgICAgICAgICAgfCAg ICA2ICsKMjcgZmlsZXMgY2hhbmdlZCwgMTU5NSBpbnNlcnRpb25zKCspLCA3NyBkZWxldGlvbnMo LSkKCg== --===============3810760212910290623==--