Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfMSl-00HBSO-BX for pgsql-committers@arkaria.postgresql.org; Wed, 28 Feb 2024 16:07:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rfMSj-00Byt0-SL for pgsql-committers@arkaria.postgresql.org; Wed, 28 Feb 2024 16:07:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfMSj-00Byss-LJ for pgsql-committers@lists.postgresql.org; Wed, 28 Feb 2024 16:07:18 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfMSf-001q77-VJ for pgsql-committers@lists.postgresql.org; Wed, 28 Feb 2024 16:07:16 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfMSg-0046HZ-0D for pgsql-committers@lists.postgresql.org; Wed, 28 Feb 2024 16:07:14 +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 1rfMSf-001FbI-Co for pgsql-committers@lists.postgresql.org; Wed, 28 Feb 2024 16:07:13 +0000 Content-Type: multipart/mixed; boundary="===============1921961767849954317==" MIME-Version: 1.0 From: Alvaro Herrera To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve performance of subsystems on top of SLRU X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 28 Feb 2024 16:07:13 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1921961767849954317== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSBwZXJmb3JtYW5jZSBvZiBzdWJzeXN0ZW1zIG9uIHRvcCBvZiBTTFJVCgpNb3JlIHBy ZWNpc2VseSwgd2hhdCB3ZSBkbyBoZXJlIGlzIG1ha2UgdGhlIFNMUlUgY2FjaGUgc2l6ZXMKY29u ZmlndXJhYmxlIHdpdGggbmV3IEdVQ3MsIHNvIHRoYXQgc2l0ZXMgd2l0aCBoaWdoIGNvbmN1cnJl bmN5IGFuZCBiaWcKcmFuZ2VzIG9mIHRyYW5zYWN0aW9ucyBpbiBmbGlnaHQgKHJlc3AuIG11bHRp eGFjdHMvc3VidHJhbnNhY3Rpb25zKSBjYW4KYmVuZWZpdCBmcm9tIGJpZ2dlciBjYWNoZXMuICBJ biBvcmRlciBmb3IgdGhpcyB0byB3b3JrIHdpdGggZ29vZApwZXJmb3JtYW5jZSwgdHdvIGFkZGl0 aW9uYWwgY2hhbmdlcyBhcmUgbWFkZToKCjEuIHRoZSBjYWNoZSBpcyBkaXZpZGVkIGluICJiYW5r cyIgKHRvIGJvcnJvdyB0ZXJtaW5vbG9neSBmcm9tIENQVQogICBjYWNoZXMpLCBhbmQgYWxnb3Jp dGhtcyBzdWNoIGFzIGV2aWN0aW9uIGJ1ZmZlciBzZWFyY2ggb25seSBhZmZlY3QKICAgb25lIHNw ZWNpZmljIGJhbmsuICBUaGlzIGZvcmVzdGFsbHMgdGhlIHByb2JsZW0gdGhhdCBsaW5lYXIgc2Vh cmNoaW5nCiAgIGZvciBhIHNwZWNpZmljIGJ1ZmZlciBhY3Jvc3MgdGhlIHdob2xlIGNhY2hlIHRh a2VzIHRvbyBsb25nOiB3ZSBvbmx5CiAgIGhhdmUgdG8gc2VhcmNoIHRoZSBzcGVjaWZpYyBiYW5r LCB3aG9zZSBzaXplIGlzIHNtYWxsLiAgVGhpcyB3b3JrIGlzCiAgIGF1dGhvcmVkIGJ5IEFuZHJl eSBCb3JvZGluLgoKMi4gQ2hhbmdlIHRoZSBsb2NraW5nIHJlZ2ltZSBmb3IgdGhlIFNMUlUgYmFu a3MsIHNvIHRoYXQgZWFjaCBiYW5rIHVzZXMKICAgYSBzZXBhcmF0ZSBMV0xvY2suICBUaGlzIGFs bG93cyBmb3IgaW5jcmVhc2VkIHNjYWxhYmlsaXR5LiAgVGhpcyB3b3JrCiAgIGlzIGF1dGhvcmVk IGJ5IERpbGlwIEt1bWFyLiAgKEEgcGFydCBvZiB0aGlzIHdhcyBwcmV2aW91c2x5IGNvbW1pdHRl ZCBhcwogICBkMTcyYjcxN2M2ZjQuKQoKU3BlY2lhbCBjYXJlIGlzIHRha2VuIHNvIHRoYXQgdGhl IGFsZ29yaXRobXMgdGhhdCBjYW4gcG90ZW50aWFsbHkKdHJhdmVyc2UgbW9yZSB0aGFuIG9uZSBi YW5rIHJlbGVhc2Ugb25lIGJhbmsncyBsb2NrIGJlZm9yZSBhY3F1aXJpbmcgdGhlCm5leHQuICBU aGlzIHNob3VsZCBoYXBwZW4gcmFyZWx5LCBidXQgcGFydGljdWxhcmx5IGNsb2cuYydzIGdyb3Vw IGNvbW1pdApmZWF0dXJlIG5lZWRlZCBjb2RlIGFkanVzdG1lbnQgdG8gY29wZSB3aXRoIHRoaXMu ICBJICjDgWx2YXJvKSBhbHNvIGFkZGVkCmxvdHMgb2YgY29tbWVudHMgdG8gbWFrZSBzdXJlIHRo ZSBkZXNpZ24gaXMgc291bmQuCgpUaGUgbmV3IEdVQ3MgbWF0Y2ggdGhlIG5hbWVzIGludHJvZHVj ZWQgYnkgYmNkZmE1ZjJlMmYyIGluIHRoZQpwZ19zdGF0X3NscnUgdmlldy4KClRoZSBkZWZhdWx0 IHZhbHVlcyBmb3IgdGhlc2UgcGFyYW1ldGVycyBhcmUgc2ltaWxhciB0byB0aGUgcHJldmlvdXMK c2l6ZXMgb2YgZWFjaCBTTFJVLiAgY29tbWl0X3RzLCBjbG9nIGFuZCBzdWJ0cmFucyBhY2NlcHQg dmFsdWUgMCwgd2hpY2gKbWVhbnMgdG8gYWRqdXN0IGJ5IGRpdmlkaW5nIHNoYXJlZF9idWZmZXJz IGJ5IDUxMiAoc28gMk1CIGZvciBldmVyeSAxR0IKb2Ygc2hhcmVkX2J1ZmZlcnMpLCB3aXRoIGEg Y2FwIG9mIDhNQi4gIChBIG5ldyBzbHJ1LmMgZnVuY3Rpb24KU2ltcGxlTHJ1QXV0b3R1bmVCdWZm ZXJzKCkgd2FzIGFkZGVkIHRvIHN1cHBvcnQgdGhpcy4pICBUaGUgY2FwIHdhcwpwcmV2aW91c2x5 IDFNQiBmb3IgY2xvZywgc28gZm9yIHNpdGVzIHdpdGggbW9yZSB0aGFuIDUxMk1CIG9mIHNoYXJl ZAptZW1vcnkgdGhlIHRvdGFsIG1lbW9yeSB1c2VkIGluY3JlYXNlcywgd2hpY2ggaXMgbGlrZWx5 IGEgZ29vZCB0cmFkZW9mZi4KSG93ZXZlciwgb3RoZXIgU0xSVXMgKG5vdGFibHkgbXVsdGl4YWN0 IG9uZXMpIHJldGFpbiBzbWFsbGVyIHNpemVzIGFuZApkb24ndCBzdXBwb3J0IGEgY29uZmlndXJl ZCB2YWx1ZSBvZiAwLiAgVGhlc2UgdmFsdWVzIGJhc2VkIG9uCnNoYXJlZF9idWZmZXJzIG1heSBu ZWVkIHRvIGJlIHJldmlzaXRlZCwgYnV0IHRoYXQncyBhbiBlYXN5IGNoYW5nZS4KClRoZXJlIHdh cyBzb21lIHJlc2lzdGFuY2UgdG8gYWRkaW5nIHRoZXNlIG5ldyBHVUNzOiBpdCB3b3VsZCBiZSBi ZXR0ZXIKdG8gYWRqdXN0IHRvIG1lbW9yeSBwcmVzc3VyZSBhdXRvbWF0aWNhbGx5IHNvbWVob3cs IGZvciBleGFtcGxlIGJ5CnN0ZWFsaW5nIG1lbW9yeSBmcm9tIHNoYXJlZF9idWZmZXJzICh3aGVy ZSB0aGUgY2FjaGVzIGNhbiBncm93IGFuZApzaHJpbmsgbmF0dXJhbGx5KS4gIEhvd2V2ZXIsIGRv aW5nIHRoYXQgc2VlbXMgdG8gYmUgYSBtdWNoIGxhcmdlcgpwcm9qZWN0IGFuZCBvbmUgd2hpY2gg aGFzIG1hZGUgdmlydHVhbGx5IG5vIHByb2dyZXNzIGluIHNldmVyYWwgeWVhcnMsCmFuZCBiZWNh dXNlIHRoaXMgaXMgc3VjaCBhIHBhaW4gcG9pbnQgZm9yIHNvIG1hbnkgdXNlcnMsIGhlcmUgd2Ug dGFrZQp0aGUgcHJhZ21hdGljIGFwcHJvYWNoLgoKQXV0aG9yOiBBbmRyZXkgQm9yb2RpbiA8eDRt bW1AeWFuZGV4LXRlYW0ucnU+CkF1dGhvcjogRGlsaXAgS3VtYXIgPGRpbGlwYmFsYXV0QGdtYWls LmNvbT4KUmV2aWV3ZWQtYnk6IEFtdWwgU3VsLCBHaWxsZXMgRGFyb2xkLCBBbmFzdGFzaWEgTHVi ZW5uaWtvdmEsCiAgICAgICAgSXZhbiBMYXphcmV2LCBSb2JlcnQgSGFhcywgVGhvbWFzIE11bnJv LCBUb21hcyBWb25kcmEsCiAgICAgICAgWXVyYSBTb2tvbG92LCDQktCw0YHQuNC70YzQtdCyINCU 0LzQuNGC0YDQuNC5IChEbWl0cnkgVmFzaWxpZXYpLgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rn ci5lcy9tLzJCRUMyQjNGLTlCNjEtNEMxRC05RkI1LTVGQUIwRjA1RUY4NkB5YW5kZXgtdGVhbS5y dQpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBRmlUTi12ekR2Tno9RXhHWHo2Z2R5 anR6R2l4S1NxczBtS0hNbWFROHNPU0VGWjMzQUBtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0t LQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9j b21taXRkaWZmLzUzYzJhOTdhOTI2NjViZTZiZDdkNzBiZDYyYWU2MTU4ZmU0ZGI5NmUKCk1vZGlm aWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9jb25maWcuc2dtbCAgICAgICAg ICAgICAgICAgICAgICAgIHwgMTM5ICsrKysrKysrKwpkb2Mvc3JjL3NnbWwvbW9uaXRvcmluZy5z Z21sICAgICAgICAgICAgICAgICAgICB8ICAgOSArLQpzcmMvYmFja2VuZC9hY2Nlc3MvdHJhbnNh bS9jbG9nLmMgICAgICAgICAgICAgICB8IDI0MyArKysrKysrKysrKy0tLS0tCnNyYy9iYWNrZW5k L2FjY2Vzcy90cmFuc2FtL2NvbW1pdF90cy5jICAgICAgICAgIHwgIDg4ICsrKystLQpzcmMvYmFj a2VuZC9hY2Nlc3MvdHJhbnNhbS9tdWx0aXhhY3QuYyAgICAgICAgICB8IDE5MCArKysrKysrKyst LS0tCnNyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3NscnUuYyAgICAgICAgICAgICAgIHwgMzU3 ICsrKysrKysrKysrKysrKysrLS0tLS0tLQpzcmMvYmFja2VuZC9hY2Nlc3MvdHJhbnNhbS9zdWJ0 cmFucy5jICAgICAgICAgICB8IDExMCArKysrKystLQpzcmMvYmFja2VuZC9jb21tYW5kcy9hc3lu Yy5jICAgICAgICAgICAgICAgICAgICB8ICA2MSArKy0tCnNyYy9iYWNrZW5kL3N0b3JhZ2UvbG1n ci9sd2xvY2suYyAgICAgICAgICAgICAgIHwgICA5ICstCnNyYy9iYWNrZW5kL3N0b3JhZ2UvbG1n ci9sd2xvY2tuYW1lcy50eHQgICAgICAgIHwgIDE0ICstCnNyYy9iYWNrZW5kL3N0b3JhZ2UvbG1n ci9wcmVkaWNhdGUuYyAgICAgICAgICAgIHwgIDM0ICsrLQpzcmMvYmFja2VuZC91dGlscy9hY3Rp dml0eS93YWl0X2V2ZW50X25hbWVzLnR4dCB8ICAxNSArLQpzcmMvYmFja2VuZC91dGlscy9pbml0 L2dsb2JhbHMuYyAgICAgICAgICAgICAgICB8ICAgOSArCnNyYy9iYWNrZW5kL3V0aWxzL21pc2Mv Z3VjX3RhYmxlcy5jICAgICAgICAgICAgIHwgIDc4ICsrKysrKwpzcmMvYmFja2VuZC91dGlscy9t aXNjL3Bvc3RncmVzcWwuY29uZi5zYW1wbGUgICB8ICAgOSArCnNyYy9pbmNsdWRlL2FjY2Vzcy9j bG9nLmggICAgICAgICAgICAgICAgICAgICAgIHwgICAxIC0Kc3JjL2luY2x1ZGUvYWNjZXNzL2Nv bW1pdF90cy5oICAgICAgICAgICAgICAgICAgfCAgIDEgLQpzcmMvaW5jbHVkZS9hY2Nlc3MvbXVs dGl4YWN0LmggICAgICAgICAgICAgICAgICB8ICAgNCAtCnNyYy9pbmNsdWRlL2FjY2Vzcy9zbHJ1 LmggICAgICAgICAgICAgICAgICAgICAgIHwgIDg2ICsrKystLQpzcmMvaW5jbHVkZS9hY2Nlc3Mv c3VidHJhbnMuaCAgICAgICAgICAgICAgICAgICB8ICAgMyAtCnNyYy9pbmNsdWRlL2NvbW1hbmRz L2FzeW5jLmggICAgICAgICAgICAgICAgICAgIHwgICA1IC0Kc3JjL2luY2x1ZGUvbWlzY2FkbWlu LmggICAgICAgICAgICAgICAgICAgICAgICAgfCAgIDggKwpzcmMvaW5jbHVkZS9zdG9yYWdlL2x3 bG9jay5oICAgICAgICAgICAgICAgICAgICB8ICAgNyArCnNyYy9pbmNsdWRlL3N0b3JhZ2UvcHJl ZGljYXRlLmggICAgICAgICAgICAgICAgIHwgICA0IC0Kc3JjL2luY2x1ZGUvdXRpbHMvZ3VjX2hv b2tzLmggICAgICAgICAgICAgICAgICAgfCAgMTEgKwpzcmMvdGVzdC9tb2R1bGVzL3Rlc3Rfc2xy dS90ZXN0X3NscnUuYyAgICAgICAgICB8ICAzNSArLS0KMjYgZmlsZXMgY2hhbmdlZCwgMTE3NyBp bnNlcnRpb25zKCspLCAzNTMgZGVsZXRpb25zKC0pCgo= --===============1921961767849954317==--