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 1rt8Gc-00CRwW-Uv for pgsql-committers@arkaria.postgresql.org; Sat, 06 Apr 2024 15:47:43 +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 1rt8Gb-00DZjV-1s for pgsql-committers@arkaria.postgresql.org; Sat, 06 Apr 2024 15:47:41 +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 1rt8Ga-00DZjG-PJ for pgsql-committers@lists.postgresql.org; Sat, 06 Apr 2024 15:47: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 1rt8GX-0013n9-5a for pgsql-committers@lists.postgresql.org; Sat, 06 Apr 2024 15:47: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 1rt8GU-002Uhv-L1 for pgsql-committers@lists.postgresql.org; Sat, 06 Apr 2024 15:47:34 +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 1rt8GT-000pMX-Bc for pgsql-committers@lists.postgresql.org; Sat, 06 Apr 2024 15:47:33 +0000 Content-Type: multipart/mixed; boundary="===============4951641822467430195==" MIME-Version: 1.0 From: Peter Geoghegan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Enhance nbtree ScalarArrayOp execution. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 06 Apr 2024 15:47:33 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4951641822467430195== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RW5oYW5jZSBuYnRyZWUgU2NhbGFyQXJyYXlPcCBleGVjdXRpb24uCgpDb21taXQgOWU4ZGEwZjcg dGF1Z2h0IG5idHJlZSB0byBoYW5kbGUgU2NhbGFyQXJyYXlPcEV4cHIgcXVhbHMKbmF0aXZlbHku ICBUaGlzIHdvcmtzIGJ5IHB1c2hpbmcgZG93biB0aGUgZnVsbCBjb250ZXh0ICh0aGUgYXJyYXkg a2V5cykKdG8gdGhlIG5idHJlZSBpbmRleCBBTSwgZW5hYmxpbmcgaXQgdG8gZXhlY3V0ZSBtdWx0 aXBsZSBwcmltaXRpdmUgaW5kZXgKc2NhbnMgdGhhdCB0aGUgcGxhbm5lciB0cmVhdHMgYXMgb25l IGNvbnRpbnVvdXMgaW5kZXggc2Nhbi9pbmRleCBwYXRoLgpUaGlzIGVhcmxpZXIgZW5oYW5jZW1l bnQgZW5hYmxlZCBuYnRyZWUgU2NhbGFyQXJyYXlPcCBpbmRleC1vbmx5IHNjYW5zLgpJdCBhbHNv IGFsbG93ZWQgc2NhbnMgd2l0aCBTY2FsYXJBcnJheU9wIHF1YWxzIHRvIHJldHVybiBvcmRlcmVk IHJlc3VsdHMKKHdpdGggc29tZSBub3RhYmxlIHJlc3RyaWN0aW9ucywgZGVzY3JpYmVkIGZ1cnRo ZXIgZG93bikuCgpUYWtlIHRoaXMgZ2VuZXJhbCBhcHByb2FjaCBhIGxvdCBmdXJ0aGVyOiB0ZWFj aCBuYnRyZWUgU0FPUCBpbmRleCBzY2Fucwp0byBkZWNpZGUgaG93IHRvIGV4ZWN1dGUgU2NhbGFy QXJyYXlPcCBzY2FucyAod2hlbiBhbmQgd2hlcmUgdG8gc3RhcnQKdGhlIG5leHQgcHJpbWl0aXZl IGluZGV4IHNjYW4pIGJhc2VkIG9uIHBoeXNpY2FsIGluZGV4IGNoYXJhY3RlcmlzdGljcy4KVGhp cyBjYW4gYmUgZmFyIG1vcmUgZWZmaWNpZW50LiAgQWxsIFNBT1Agc2NhbnMgd2lsbCBub3cgcmVs aWFibHkgYXZvaWQKZHVwbGljYXRpdmUgbGVhZiBwYWdlIGFjY2Vzc2VzIChqdXN0IGxpa2UgYW55 IG90aGVyIG5idHJlZSBpbmRleCBzY2FuKS4KU0FPUCBzY2FucyB3aG9zZSBhcnJheSBrZXlzIGFy ZSBuYXR1cmFsbHkgY2x1c3RlcmVkIHRvZ2V0aGVyIG5vdyByZXF1aXJlCmZhciBmZXdlciBpbmRl eCBkZXNjZW50cywgc2luY2Ugd2UnbGwgcmVsaWFibHkgYXZvaWQgc3RhcnRpbmcgYSBuZXcKcHJp bWl0aXZlIHNjYW4ganVzdCB0byBnZXQgdG8gYSBsYXRlciBvZmZzZXQgZnJvbSB0aGUgc2FtZSBs ZWFmIHBhZ2UuCgpUaGUgc2NhbidzIGFycmF5cyBub3cgYWR2YW5jZSB1c2luZyBiaW5hcnkgc2Vh cmNoZXMgZm9yIHRoZSBhcnJheQplbGVtZW50IHRoYXQgYmVzdCBtYXRjaGVzIHRoZSBuZXh0IHR1 cGxlJ3MgYXR0cmlidXRlIHZhbHVlLiAgUmVxdWlyZWQKc2NhbiBrZXkgYXJyYXlzIChpLmUuIGFy cmF5cyBmcm9tIHNjYW4ga2V5cyB0aGF0IGNhbiB0ZXJtaW5hdGUgdGhlIHNjYW4pCnJhdGNoZXQg Zm9yd2FyZCBpbiBsb2Nrc3RlcCB3aXRoIHRoZSBpbmRleCBzY2FuLiAgTm9uLXJlcXVpcmVkIGFy cmF5cwooaS5lLiBhcnJheXMgZnJvbSBzY2FuIGtleXMgdGhhdCBjYW4gb25seSBleGNsdWRlIG5v bi1tYXRjaGluZyB0dXBsZXMpCiJhZHZhbmNlIiB3aXRob3V0IHRoZSBwcm9jZXNzIGV2ZXIgcm9s bGluZyBvdmVyIHRvIGEgaGlnaGVyLW9yZGVyIGFycmF5LgoKTmF0dXJhbGx5LCBvbmx5IHJlcXVp cmVkIFNBT1Agc2NhbiBrZXlzIHRyaWdnZXIgc2tpcHBpbmcgb3ZlciBsZWFmIHBhZ2VzCihub24t cmVxdWlyZWQgYXJyYXlzIGNhbm5vdCBzYWZlbHkgZW5kIG9yIHN0YXJ0IHByaW1pdGl2ZSBpbmRl eCBzY2FucykuCkNvbnNlcXVlbnRseSwgZXZlbiBpbmRleCBzY2FucyBvZiBhIGNvbXBvc2l0ZSBp bmRleCB3aXRoIGEgaGlnaC1vcmRlcgppbmVxdWFsaXR5IHNjYW4ga2V5ICh3aGljaCB3ZSdsbCBt YXJrIHJlcXVpcmVkKSBhbmQgYSBsb3ctb3JkZXIgU0FPUApzY2FuIGtleSAod2hpY2ggd2Ugd29u J3QgbWFyayByZXF1aXJlZCkgbm93IGF2b2lkIHJlcGVhdGluZyBsZWFmIHBhZ2UKYWNjZXNzZXMg LS0gdGhhdCBiZW5lZml0IGlzbid0IGxpbWl0ZWQgdG8gc2ltcGxlciBlcXVhbGl0eS1vbmx5IGNh c2VzLgpJbiBnZW5lcmFsLCBhbGwgbmJ0cmVlIGluZGV4IHNjYW5zIG5vdyBvdXRwdXQgdHVwbGVz IGFzIGlmIHRoZXkgd2VyZSBvbmUKY29udGludW91cyBpbmRleCBzY2FuIC0tIGV2ZW4gc2NhbnMg dGhhdCBtaXggYSBoaWdoLW9yZGVyIGluZXF1YWxpdHkKd2l0aCBsb3dlci1vcmRlciBTQU9QIGVx dWFsaXRpZXMgcmVsaWFibHkgb3V0cHV0IHR1cGxlcyBpbiBpbmRleCBvcmRlci4KVGhpcyBhbGxv d3MgdXMgdG8gcmVtb3ZlIGEgY291cGxlIG9mIHNwZWNpYWwgY2FzZXMgdGhhdCB3ZXJlIGFwcGxp ZWQKd2hlbiBidWlsZGluZyBpbmRleCBwYXRocyB3aXRoIFNBT1AgY2xhdXNlcyBkdXJpbmcgcGxh bm5pbmcuCgpCdWdmaXggY29tbWl0IDgwN2E0MGM1IHRhdWdodCB0aGUgcGxhbm5lciB0byBhdm9p ZCBnZW5lcmF0aW5nIHVuc2FmZQpwYXRoIGtleXM6IHBhdGgga2V5cyBvbiBhIG11bHRpY29sdW1u IGluZGV4IHBhdGgsIHdpdGggYSBTQU9QIGNsYXVzZSBvbgphbnkgYXR0cmlidXRlIGJleW9uZCB0 aGUgZmlyc3QvbW9zdCBzaWduaWZpY2FudCBhdHRyaWJ1dGUuICBUaGVzZSBjYXNlcwphcmUgbm93 IGFsbCBzYWZlLCBzbyB3ZSBnbyBiYWNrIHRvIGdlbmVyYXRpbmcgcGF0aCBrZXlzIHdpdGhvdXQg cmVnYXJkCmZvciB0aGUgcHJlc2VuY2Ugb2YgU0FPUCBjbGF1c2VzIChqdXN0IGxpa2Ugd2l0aCBh bnkgb3RoZXIgY2xhdXNlIHR5cGUpLgpBZmZlY3RlZCBxdWVyaWVzIGNhbiBub3cgZXhwbG9pdCBz Y2FuIG91dHB1dCBvcmRlciBpbiBhbGwgdGhlIHVzdWFsIHdheXMKKGUuZy4sIGNlcnRhaW4gIk9S REVSIEJZIC4uLiBMSU1JVCBuIiBxdWVyaWVzIGNhbiBub3cgdGVybWluYXRlIGVhcmx5KS4KCkFs c28gdW5kbyBjaGFuZ2VzIGZyb20gZm9sbG93LXVwIGJ1Z2ZpeCBjb21taXQgYTQ1MjNjNWEsIHdo aWNoIHRhdWdodAp0aGUgcGxhbm5lciB0byBwcm9kdWNlIGFsdGVybmF0aXZlIGluZGV4IHBhdGhz LCB3aXRoIHBhdGgga2V5cywgYnV0CndpdGhvdXQgbG93LW9yZGVyIFNBT1AgaW5kZXggcXVhbHMg KGZpbHRlciBxdWFscyB3ZXJlIHVzZWQgaW5zdGVhZCkuCldlJ2xsIG5vIGxvbmdlciBnZW5lcmF0 ZSB0aGVzZSBhbHRlcm5hdGl2ZSBwYXRocywgc2luY2UgdGhleSBjYW4gbm8KbG9uZ2VyIG9mZmVy IGFueSBtZWFuaW5nZnVsIGFkdmFudGFnZXMgb3ZlciBzdGFuZGFyZCBpbmRleCBxdWFsIHBhdGhz LgpBZmZlY3RlZCBxdWVyaWVzIHRoZXJlYnkgYXZvaWQgYWxsIG9mIHRoZSBkaXNhZHZhbnRhZ2Vz IHRoYXQgY29tZSBmcm9tCnVzaW5nIGZpbHRlciBxdWFscyB3aXRoaW4gaW5kZXggc2NhbiBub2Rl cy4gIFRoZXkgY2FuIGF2b2lkIGV4dHJhIGhlYXAKcGFnZSBhY2Nlc3NlcyBmcm9tIHVzaW5nIGZp bHRlciBxdWFscyB0byBleGNsdWRlIG5vbi1tYXRjaGluZyB0dXBsZXMKKGluZGV4IHF1YWxzIHdp bGwgbmV2ZXIgaGF2ZSB0aGF0IHByb2JsZW0pLiAgVGhleSBjYW4gYWxzbyBza2lwIG92ZXIKaXJy ZWxldmFudCBzZWN0aW9ucyBvZiB0aGUgaW5kZXggaW4gbW9yZSBjYXNlcyAodGhvdWdoIG9ubHkg d2hlbiBuYnRyZWUKZGV0ZXJtaW5lcyB0aGF0IHN0YXJ0aW5nIGFub3RoZXIgcHJpbWl0aXZlIHNj YW4gYWN0dWFsbHkgbWFrZXMgc2Vuc2UpLgoKVGhlcmUgaXMgYSB0aGVvcmV0aWNhbCByaXNrIHRo YXQgcmVtb3ZpbmcgcmVzdHJpY3Rpb25zIG9uIFNBT1AgaW5kZXgKcGF0aHMgZnJvbSB0aGUgcGxh bm5lciB3aWxsIGJyZWFrIGNvbXBhdGliaWxpdHkgd2l0aCBhbWNhbm9yZGVyLWJhc2VkCmluZGV4 IEFNcyBtYWludGFpbmVkIGFzIGV4dGVuc2lvbnMuICBTdWNoIGFuIGluZGV4IEFNIGNvdWxkIGhh dmUgdGhlCnNhbWUgbGltaXRhdGlvbnMgYXJvdW5kIG9yZGVyZWQgU0FPUCBzY2FucyBhcyBuYnRy ZWUgaGFkIHVwIHVudGlsIG5vdy4KQWRkaW5nIGEgcHJvIGZvcm1hIGluY29tcGF0aWJpbGl0eSBp dGVtIGFib3V0IHRoZSBpc3N1ZSB0byB0aGUgUG9zdGdyZXMKMTcgcmVsZWFzZSBub3RlcyBzZWVt cyBsaWtlIGEgZ29vZCBpZGVhLgoKQXV0aG9yOiBQZXRlciBHZW9naGVnYW4gPHBnQGJvd3QuaWU+ CkF1dGhvcjogTWF0dGhpYXMgdmFuIGRlIE1lZW50IDxib2VrZXd1cm0rcG9zdGdyZXNAZ21haWwu Y29tPgpSZXZpZXdlZC1CeTogSGVpa2tpIExpbm5ha2FuZ2FzIDxobGlubmFrYUBpa2kuZmk+ClJl dmlld2VkLUJ5OiBNYXR0aGlhcyB2YW4gZGUgTWVlbnQgPGJvZWtld3VybStwb3N0Z3Jlc0BnbWFp bC5jb20+ClJldmlld2VkLUJ5OiBUb21hcyBWb25kcmEgPHRvbWFzLnZvbmRyYUBlbnRlcnByaXNl ZGIuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBSDItV3o9a3N2Tl9zamNu RDErQnQtV3RpZlJBNW9rNDhhRFlucTNwa0toeGdNUXBjd0BtYWlsLmdtYWlsLmNvbQoKQnJhbmNo Ci0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9y Zy9wZy9jb21taXRkaWZmLzViZjc0OGI4NmJjNjc4NmEzZmM1N2ZjN2NlMjk2YzM3ZGE2NTY0YjAK Ck1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9pbmRleGFtLnNnbWwg ICAgICAgICAgICAgICAgICAgICB8ICAgMTAgKy0KZG9jL3NyYy9zZ21sL21vbml0b3Jpbmcuc2dt bCAgICAgICAgICAgICAgICAgIHwgICAxMyArCnNyYy9iYWNrZW5kL2FjY2Vzcy9pbmRleC9pbmRl eGFtLmMgICAgICAgICAgICB8ICAgMTAgKy0Kc3JjL2JhY2tlbmQvYWNjZXNzL25idHJlZS9uYnRy ZWUuYyAgICAgICAgICAgIHwgIDIwMiArLQpzcmMvYmFja2VuZC9hY2Nlc3MvbmJ0cmVlL25idHNl YXJjaC5jICAgICAgICAgfCAgMjQ5ICsrLQpzcmMvYmFja2VuZC9hY2Nlc3MvbmJ0cmVlL25idHV0 aWxzLmMgICAgICAgICAgfCAyOTY4ICsrKysrKysrKysrKysrKysrKysrKystLS0Kc3JjL2JhY2tl bmQvZXhlY3V0b3Ivbm9kZUluZGV4b25seXNjYW4uYyAgICAgIHwgICAgMiArCnNyYy9iYWNrZW5k L2V4ZWN1dG9yL25vZGVJbmRleHNjYW4uYyAgICAgICAgICB8ICAgIDIgKwpzcmMvYmFja2VuZC9v cHRpbWl6ZXIvcGF0aC9pbmR4cGF0aC5jICAgICAgICAgfCAgIDkwICstCnNyYy9iYWNrZW5kL3V0 aWxzL2FkdC9zZWxmdW5jcy5jICAgICAgICAgICAgICB8ICAgODMgKy0Kc3JjL2luY2x1ZGUvYWNj ZXNzL2FtYXBpLmggICAgICAgICAgICAgICAgICAgIHwgICAgMiArLQpzcmMvaW5jbHVkZS9hY2Nl c3MvZ2VuYW0uaCAgICAgICAgICAgICAgICAgICAgfCAgICAzICstCnNyYy9pbmNsdWRlL2FjY2Vz cy9uYnRyZWUuaCAgICAgICAgICAgICAgICAgICB8ICAgNzkgKy0Kc3JjL2luY2x1ZGUvdXRpbHMv c2VsZnVuY3MuaCAgICAgICAgICAgICAgICAgIHwgICAgMyArCnNyYy90ZXN0L3JlZ3Jlc3MvZXhw ZWN0ZWQvYnRyZWVfaW5kZXgub3V0ICAgICB8ICAgNTIgKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVj dGVkL2NyZWF0ZV9pbmRleC5vdXQgICAgfCAgMTc5ICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0 ZWQvam9pbi5vdXQgICAgICAgICAgICB8ICAgIDUgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3Rl ZC9zZWxlY3RfcGFyYWxsZWwub3V0IHwgICAyNSArCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2J0cmVl X2luZGV4LnNxbCAgICAgICAgICB8ICAgMTUgKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9jcmVhdGVf aW5kZXguc3FsICAgICAgICAgfCAgIDY0ICstCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3NlbGVjdF9w YXJhbGxlbC5zcWwgICAgICB8ICAgIDggKwpzcmMvdG9vbHMvcGdpbmRlbnQvdHlwZWRlZnMubGlz dCAgICAgICAgICAgICAgfCAgICAyICsKMjIgZmlsZXMgY2hhbmdlZCwgMzQ4NyBpbnNlcnRpb25z KCspLCA1NzkgZGVsZXRpb25zKC0pCgo= --===============4951641822467430195==--