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 1tLl5O-00Go9F-O7 for pgsql-committers@arkaria.postgresql.org; Thu, 12 Dec 2024 15:26:42 +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 1tLl5L-00D1GL-7P for pgsql-committers@arkaria.postgresql.org; Thu, 12 Dec 2024 15:26:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tLl5K-00D1GD-Vw for pgsql-committers@lists.postgresql.org; Thu, 12 Dec 2024 15:26:40 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tLl5I-002U3i-Oh for pgsql-committers@lists.postgresql.org; Thu, 12 Dec 2024 15:26:39 +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 1tLl5H-007eYN-7x for pgsql-committers@lists.postgresql.org; Thu, 12 Dec 2024 15:26:35 +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 1tLl5F-002McP-Mx for pgsql-committers@lists.postgresql.org; Thu, 12 Dec 2024 15:26:34 +0000 Content-Type: multipart/mixed; boundary="===============2595834176540874281==" MIME-Version: 1.0 From: =?utf-8?q?=C3=81lvaro_Herrera?= To: pgsql-committers@lists.postgresql.org Subject: pgsql: Backpatch critical performance fixes to pgarch.c X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 12 Dec 2024 15:26:34 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2595834176540874281== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QmFja3BhdGNoIGNyaXRpY2FsIHBlcmZvcm1hbmNlIGZpeGVzIHRvIHBnYXJjaC5jCgpUaGlzIGJh Y2twYXRjaGVzIGNvbW1pdHMgYmViNGU5YmExNjUyIGFuZCAxZmIxN2IxOTAzNDEgKG9yaWdpbmFs bHkKYXBwZWFyaW5nIGluIHByZXZpb3VzbHkgaW4gUkVMXzE1X1NUQUJMRSkgdG8gUkVMXzE0X1NU QUJMRS4gIFBlcmZvcm1hbmNlCm9mIHRoZSBXQUwgYXJjaGl2ZXIgY2FuIGJlY29tZSBwcmV0dHkg Y3JpdGljYWwgYXQgdGltZXMsIGFuZCByZXBvcnRzCmV4aXN0IG9mIHVzZXJzIGdldHRpbmcgaW4g c2VyaW91cyB0cm91YmxlIChob3VycyBvZiBkb3dudGltZSwgbG9zcyBvZgpyZXBsaWNhcykgYmVj YXVzZSBvZiBsYWNrIG9mIHRoaXMgb3B0aW1pemF0aW9uLgoKV2UnZCBsaWtlIHRvIGJhY2twYXRj aCB0aGVzZSB0byBSRUxfMTNfU1RBQkxFIHRvbywgYnV0IGJlY2F1c2Ugb2YgdGhlCnZlcnkgaW52 YXNpdmUgY2hhbmdlcyBtYWRlIGJ5IGNvbW1pdCBkNzUyODhmYjI3YjggaW4gdGhlIDE0IHRpbWVm cmFtZSwKd2UgZGVlbSBpdCB0b28gcmlza3kgOi0oCgpPcmlnaW5hbCBjb21taXQgbWVzc2FnZXMg YXBwZWFyIGJlbG93LgoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8yMDI0MTExMzE2 MDUubTY2c3lxNWk1dWNsQGFsdmhlcnJlLnBnc3FsCgogIGNvbW1pdCBiZWI0ZTliYTE2NTJhMDRm NjZmZjIwMjYxNDQ0ZDA2ZjY3OGMwYjJkCiAgQXV0aG9yOiAgICAgUm9iZXJ0IEhhYXMgPHJoYWFz QHBvc3RncmVzcWwub3JnPgogIEF1dGhvckRhdGU6IFRodSBOb3YgMTEgMTU6MDI6NTMgMjAyMSAt MDUwMAoKICBJbXByb3ZlIHBlcmZvcm1hbmNlIG9mIHBnYXJjaF9yZWFkeVhsb2coKSB3aXRoIG1h bnkgc3RhdHVzIGZpbGVzLgoKICBQcmVzZW50bHksIHRoZSBhcmNoaXZlX3N0YXR1cyBkaXJlY3Rv cnkgd2FzIHNjYW5uZWQgZm9yIGVhY2ggZmlsZSB0bwogIGFyY2hpdmUuICBXaGVuIHRoZXJlIGFy ZSBtYW55IHN0YXR1cyBmaWxlcywgc2F5IGJlY2F1c2UgYXJjaGl2ZV9jb21tYW5kCiAgaGFzIGJl ZW4gZmFpbGluZyBmb3IgYSBsb25nIHRpbWUsIHRoZXNlIGRpcmVjdG9yeSBzY2FucyBjYW4gZ2V0 IHZlcnkKICBzbG93LiAgV2l0aCB0aGlzIGNoYW5nZSwgdGhlIGFyY2hpdmVyIHJlbWVtYmVycyBz ZXZlcmFsIGZpbGVzIHRvIGFyY2hpdmUKICBkdXJpbmcgZWFjaCBkaXJlY3Rvcnkgc2Nhbiwgc3Bl ZWRpbmcgdGhpbmdzIHVwLgoKICBUbyBlbnN1cmUgdGltZWxpbmUgaGlzdG9yeSBmaWxlcyBhcmUg YXJjaGl2ZWQgYXMgcXVpY2tseSBhcyBwb3NzaWJsZSwKICBYTG9nQXJjaGl2ZU5vdGlmeSgpIGZv cmNlcyB0aGUgYXJjaGl2ZXIgdG8gZG8gYSBuZXcgZGlyZWN0b3J5IHNjYW4gYXMKICBzb29uIGFz IHRoZSAucmVhZHkgZmlsZSBmb3Igb25lIGlzIGNyZWF0ZWQuCgogIE5hdGhhbiBCb3NzYXJ0LCBw ZXIgYSBsb25nIGRpc2N1c3Npb24gaW52b2x2aW5nIG1hbnkgcGVvcGxlLiBJdCBpcwogIG5vdCBj bGVhciB0byBtZSBleGFjdGx5IHdobyBvdXQgb2YgYWxsIHRob3NlIHBlb3BsZSByZXZpZXdlZCB0 aGlzCiAgcGFydGljdWxhciBwYXRjaC4KCiAgRGlzY3Vzc2lvbjogaHR0cDovL3Bvc3Rnci5lcy9t L0NBK1RnbW9iaEFiczJ5YWJUdVRSa0pUcV9ra0M4MC0ranc9cGZweXBkT0o3K2dBYlFid0BtYWls LmdtYWlsLmNvbQogIERpc2N1c3Npb246IGh0dHA6Ly9wb3N0Z3IuZXMvbS82MjBGM0NFMS0wMjU1 LTRENjYtOUQ4Ny0wRUFERTg2Njk4NUFAYW1hem9uLmNvbQoKICBjb21taXQgMWZiMTdiMTkwMzQx NDY3NmJkMzcxMDY4NzM5NTQ5Y2QyOTY2ZmU4NwogIEF1dGhvcjogICAgIFRvbSBMYW5lIDx0Z2xA c3NzLnBnaC5wYS51cz4KICBBdXRob3JEYXRlOiBXZWQgRGVjIDI5IDE3OjAyOjUwIDIwMjEgLTA1 MDAKCiAgRml4IGlzc3VlcyBpbiBwZ2FyY2gncyBuZXcgZGlyZWN0b3J5LXNjYW5uaW5nIGxvZ2lj LgoKICBUaGUgYXJjaF9maWxlbmFtZXNbXSBhcnJheSBlbGVtZW50cyB3ZXJlIG9uZSBieXRlIHRv byBzbWFsbCwgc28gdGhhdAogIGEgbWF4aW11bS1sZW5ndGggZmlsZW5hbWUgd291bGQgZ2V0IGNv cnJ1cHRlZCBpZiBhbm90aGVyIGVudHJ5CiAgd2VyZSBtYWRlIGFmdGVyIGl0LiAgKE5vdGVkIGJ5 IFRob21hcyBNdW5ybywgZml4IGJ5IE5hdGhhbiBCb3NzYXJ0LikKCiAgTW92ZSB0aGVzZSBhcnJh eXMgaW50byBhIHBhbGxvYydkIHN0cnVjdCwgc28gdGhhdCB3ZSBhcmVuJ3Qgd2FzdGluZwogIGEg ZmV3IGtpbG9ieXRlcyBvZiBzdGF0aWMgZGF0YSBpbiBlYWNoIG5vbi1hcmNoaXZlciBwcm9jZXNz LgoKICBBZGQgYSBiaW5hcnloZWFwX3Jlc2V0KCkgY2FsbCB0byBtYWtlIGl0IHBsYWluIHRoYXQg d2Ugc3RhcnQgdGhlCiAgZGlyZWN0b3J5IHNjYW4gd2l0aCBhbiBlbXB0eSBoZWFwLiAgSSBkb24n dCB0aGluayB0aGVyZSdzIGFueSBsaXZlCiAgYnVnIG9mIHRoYXQgc29ydCwgYnV0IGl0IHNlZW1z IGZyYWdpbGUsIGFuZCB0aGlzIGlzIHZlcnkgY2hlYXAKICBpbnN1cmFuY2UuCgogIENsZWFudXAg Zm9yIGNvbW1pdCBiZWI0ZTliYTEsIHNvIG5vIGJhY2stcGF0Y2ggbmVlZGVkLgoKICBEaXNjdXNz aW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBK2hVS0dMSEFqSHVLdXd0enNXN3VNSkY0QlZQY1FS TC1VTVpHX0hNLWcweTd5TGtVZ0BtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQpSRUxfMTRf U1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29t bWl0ZGlmZi80YWJmNjE1Y2M4YThjYTgwNDMwYjVhMGJmYTE4YmU2ZWZjZWE5NmIyCgpNb2RpZmll ZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9hY2Nlc3MvdHJhbnNhbS94bG9nYXJj aGl2ZS5jIHwgIDE0ICsrKwpzcmMvYmFja2VuZC9wb3N0bWFzdGVyL3BnYXJjaC5jICAgICAgICAg IHwgMjA4ICsrKysrKysrKysrKysrKysrKysrKysrKysrKy0tLS0Kc3JjL2luY2x1ZGUvcG9zdG1h c3Rlci9wZ2FyY2guaCAgICAgICAgICB8ICAgMSArCjMgZmlsZXMgY2hhbmdlZCwgMTk3IGluc2Vy dGlvbnMoKyksIDI2IGRlbGV0aW9ucygtKQoK --===============2595834176540874281==--