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 1tw2F8-00A7Tg-Q3 for pgsql-committers@arkaria.postgresql.org; Sat, 22 Mar 2025 17:02: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 1tw2F6-00GcWr-S6 for pgsql-committers@arkaria.postgresql.org; Sat, 22 Mar 2025 17:02:40 +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 1tw2F6-00GcWj-G5 for pgsql-committers@lists.postgresql.org; Sat, 22 Mar 2025 17:02:40 +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.96) (envelope-from ) id 1tw2F3-000XLv-2A for pgsql-committers@lists.postgresql.org; Sat, 22 Mar 2025 17:02: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 1tw2F2-00BI5C-ON for pgsql-committers@lists.postgresql.org; Sat, 22 Mar 2025 17:02:36 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1tw2F1-000UGZ-2N for pgsql-committers@lists.postgresql.org; Sat, 22 Mar 2025 17:02:36 +0000 Content-Type: multipart/mixed; boundary="===============7281317919504145359==" MIME-Version: 1.0 From: Peter Geoghegan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve nbtree array primitive scan scheduling. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 22 Mar 2025 17:02:36 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7281317919504145359== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSBuYnRyZWUgYXJyYXkgcHJpbWl0aXZlIHNjYW4gc2NoZWR1bGluZy4KCkFkZCBhIG5l dyBzY2hlZHVsaW5nIGhldXJpc3RpYzogZG9uJ3QgZW5kIHRoZSBvbmdvaW5nIHByaW1pdGl2ZSBp bmRleApzY2FuIGltbWVkaWF0ZWx5IChhdCB0aGUgcG9pbnQgd2hlcmUgX2J0X2FkdmFuY2VfYXJy YXlfa2V5cyBub3RpY2VzIHRoYXQKdGhlIG5leHQgc2V0IG9mIG1hdGNoaW5nIHR1cGxlcyBtdXN0 IGJlIG9uIGEgbGF0ZXIgcGFnZSkgaWYgdGhlIHByaW1zY2FuCmFscmVhZHkgbWFuYWdlZCB0byBz dGVwIHJpZ2h0L2xlZnQgZnJvbSBpdHMgZmlyc3QgbGVhZiBwYWdlLiAgU2NoZWR1bGUgYQpyZWNo ZWNrIGFnYWluc3QgdGhlIG5leHQgc2libGluZyBsZWFmIHBhZ2UncyBmaW5hbHR1cCBpbnN0ZWFk LgoKVGhlIG5ldyBoZXVyaXN0aWMgdGVuZHMgdG8gYXZvaWQgc2NlbmFyaW9zIHdoZXJlIHRoZSB0 b3AtbGV2ZWwgc2NhbgpyZXBlYXRlZGx5IHN0YXJ0cyBhbmQgZW5kcyBwcmltaXRpdmUgaW5kZXgg c2NhbnMgdGhhdCBlYWNoIHJlYWQgb25seSBvbmUKbGVhZiBwYWdlIGZyb20gYSBncm91cCBvZiBu ZWlnaGJvcmluZyBsZWFmIHBhZ2VzLiAgQWZmZWN0ZWQgdG9wLWxldmVsCnNjYW5zIHdpbGwgbm93 IHRlbmQgdG8gc3RlcCBmb3J3YXJkIChvciBiYWNrd2FyZCkgdGhyb3VnaCB0aGUgaW5kZXgKaW5z dGVhZCwgd2l0aG91dCB3YXN0aW5nIGN5Y2xlcyBvbiBkZXNjZW5kaW5nIHRoZSBpbmRleCBhbmV3 LgoKVGhlIHJlY2hlY2sgbWVjaGFuaXNtIGlzbid0IGV4YWN0bHkgbmV3LiAgQnV0IHVwIHVudGls IG5vdyBpdCBoYXMgb25seQpiZWVuIHVzZWQgdG8gZGVhbCB3aXRoIGVkZ2UgY2FzZXMgaW52b2x2 aW5nIGhpZ2gga2V5IGZpbmFsdHVwcyB3aXRoIG9uZQpvciBtb3JlIHRydW5jYXRlZCAtaW5mIGF0 dHJpYnV0ZXMgdGhhdCBfYnRfYWR2YW5jZV9hcnJheV9rZXlzIGRlZW1lZAoicHJvdmlzaW9uYWxs eSBzYXRpc2ZpZWQiIChzYXRpc2ZpZWQgZm9yIHRoZSBwdXJwb3NlcyBvZiBhbGxvd2luZyB0aGUK c2NhbiB0byBzdGVwIG9udG8gdGhlIG5leHQgcGFnZSwgc3ViamVjdCB0byByZWNoZWNrIG9uY2Ug b24gdGhhdCBwYWdlKS4KVGhlIG1lY2hhbmlzbSB3YXMgYWRkZWQgYnkgY29tbWl0IDViZjc0OGI4 LCB3aGljaCBpbnZlbnRlZCB0aGUgZ2VuZXJhbApjb25jZXB0IG9mIHByaW1pdGl2ZSBzY2FuIHNj aGVkdWxpbmcuICBJdCB3YXMgbGF0ZXIgZW5oYW5jZWQgYnkgY29tbWl0Cjc5ZmE3YjNiLCB3aGlj aCB0YXVnaHQgaXQgYWJvdXQgY2FzZXMgaW52b2x2aW5nIC1pbmYgYXR0cmlidXRlcyB0aGF0CnNh dGlzZnkgaW5lcXVhbGl0eSBzY2FuIGtleXMgcmVxdWlyZWQgaW4gdGhlIG9wcG9zaXRlLXRvLXNj YW4gZGlyZWN0aW9uCm9ubHkgKGFyZ3VhYmx5LCB0aGV5IHNob3VsZCBoYXZlIGJlZW4gY292ZXJl ZCBieSB0aGUgZWFybGllc3QgdmVyc2lvbikuCk5vdyB0aGUgcmVjaGVjayBtZWNoYW5pc20gY2Fu IGJlIGFwcGxpZWQgYmFzZWQgb24gc2Nhbi1sZXZlbCBoZXVyaXN0aWNzLAp3aGljaCBoYXZlIG5v dGhpbmcgdG8gZG8gd2l0aCB0cnVuY2F0ZWQgaGlnaCBrZXlzLiAgTm93IHJlY2hlY2tzIG1pZ2h0 CmJlIHBlcmZvcm1lZCBieSBfYnRfcmVhZHBhZ2Ugd2hlbiBzY2FubmluZyBpbiBfZWl0aGVyXyBz Y2FuIGRpcmVjdGlvbi4KClRoZSB0aGVvcnkgYmVoaW5kIHRoZSBuZXcgaGV1cmlzdGljIGlzIHRo YXQgYW55IHByaW1pdGl2ZSBzY2FuIHRoYXQKbWFrZXMgaXQgcGFzdCBpdHMgZmlyc3QgbGVhZiBw YWdlIGlzIG9uZSB0aGF0IGlzIGFscmVhZHkgbGlrZWx5IHRvIGhhdmUKYXJyYXlzIHdob3NlIGtl eSB2YWx1ZXMgbWF0Y2ggaW5kZXggdHVwbGVzIHRoYXQgYXJlIGNsb3NlbHkgY2x1c3RlcmVkCnRv Z2V0aGVyIGluIHRoZSBpbmRleC4gIFRoZSBydWxlcyB0aGF0IGRldGVybWluZSB3aGV0aGVyIHdl IGV2ZXIgZ2V0CnBhc3QgdGhlIGZpcnN0IHBhZ2UgYXJlIHN0aWxsIGNvbnNlcnZhdGl2ZSAodGhh dCdsbCBzdGlsbCBvbmx5IGhhcHBlbgp3aGVuIHBzdGF0ZS5maW5hbHR1cCBzdHJvbmdseSBzdWdn ZXN0cyB0aGF0IGl0J3MgdGhlIHJpZ2h0IHRoaW5nIHRvIGRvKS4KU3Vydml2aW5nIHBhc3QgdGhl IGZpcnN0IGxlYWYgcGFnZSBpcyBhIHN0cm9uZyBzaWduYWwgaW4gaXRzZWxmLgoKUHJlcGFyYXRp b24gZm9yIGFuIHVwY29taW5nIHBhdGNoIHRoYXQgd2lsbCBhZGQgc2tpcCBzY2FuIG9wdGltaXph dGlvbnMKdG8gbmJ0cmVlLiAgVGhhdCdsbCB3b3JrIGJ5IGFkZGluZyBza2lwIGFycmF5cywgd2hp Y2ggYmVoYXZlIHNpbWlsYXJseQp0byBTQU9QIGFycmF5cywgYnV0IGdlbmVyYXRlIHRoZWlyIGVs ZW1lbnRzIHByb2NlZHVyYWxseSBhbmQgb24tZGVtYW5kLgoKTm90ZSB0aGF0IHRoaXMgY29tbWl0 IGlzbid0IHNwZWNpZmljYWxseSBjb25jZXJuZWQgd2l0aCBza2lwIGFycmF5czsgdGhlCnNjaGVk dWxpbmcgbG9naWMgZG9lc24ndCAoYW5kIHdvbid0KSBjb25kaXRpb24gYW55dGhpbmcgb24gd2hl dGhlciB0aGUKc2NhbiB1c2VzIHNraXAgYXJyYXlzLCBTQU9QIGFycmF5cywgb3Igc29tZSBjb21i aW5hdGlvbiBvZiB0aGUgdHdvCih3aGljaCBzZWVtcyBsaWtlIGEgZ29vZCBnZW5lcmFsIHByaW5j aXBsZSBmb3IgX2J0X2FkdmFuY2VfYXJyYXlfa2V5cykuCldoaWxlIHRoZSBwcm9ibGVtcyB0aGF0 IHRoaXMgY29tbWl0IGFtZWxpb3JhdGVzIGFyZSBtb3JlIGxpa2VseSB3aXRoCnNraXAgYXJyYXlz IChhdCBsZWFzdCBpbiBwcmFjdGljZSksIFNBT1AgYXJyYXlzIChvciB0aG9zZSB3aXRoIHZlcnkK ZGVuc2UsIGNvbnRpZ3VvdXMgYXJyYXkgZWxlbWVudHMpIGFyZSBhbHNvIGFmZmVjdGVkLgoKQXV0 aG9yOiBQZXRlciBHZW9naGVnYW4gPHBnQGJvd3QuaWU+ClJldmlld2VkLUJ5OiBNYXR0aGlhcyB2 YW4gZGUgTWVlbnQgPGJvZWtld3VybStwb3N0Z3Jlc0BnbWFpbC5jb20+CkRpc2N1c3Npb246IGh0 dHBzOi8vcG9zdGdyLmVzL20vQ0FIMi1Xemt6MHdQZTYrMDJrcitoQytKSk5LZkd0akdUenBHM0NG VlRRbUt3V05yWE53QG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWls cwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvOWEyZTJh Mjg1YTE0OTQ5MGE2OWE3YmQ5MmRkNjE4YmI3Y2E5NzViMwoKTW9kaWZpZWQgRmlsZXMKLS0tLS0t LS0tLS0tLS0Kc3JjL2JhY2tlbmQvYWNjZXNzL25idHJlZS9uYnRzZWFyY2guYyB8ICA2OCArKysr KystLS0tLQpzcmMvYmFja2VuZC9hY2Nlc3MvbmJ0cmVlL25idHV0aWxzLmMgIHwgMjIxICsrKysr KysrKysrKysrKysrKy0tLS0tLS0tLS0tLS0tLS0Kc3JjL2luY2x1ZGUvYWNjZXNzL25idHJlZS5o ICAgICAgICAgICB8ICAxMSArLQozIGZpbGVzIGNoYW5nZWQsIDE2MiBpbnNlcnRpb25zKCspLCAx MzggZGVsZXRpb25zKC0pCgo= --===============7281317919504145359==--