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 1qtsMy-00EN3J-0h for pgsql-committers@arkaria.postgresql.org; Fri, 20 Oct 2023 16:29:04 +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 1qtsMw-004AAd-1K for pgsql-committers@arkaria.postgresql.org; Fri, 20 Oct 2023 16:29:02 +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 1qtsMv-004AAS-Px for pgsql-committers@lists.postgresql.org; Fri, 20 Oct 2023 16:29:02 +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 1qtsMs-001ktH-0i for pgsql-committers@lists.postgresql.org; Fri, 20 Oct 2023 16:29:01 +0000 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 1qtsMr-0005yW-9X for pgsql-committers@lists.postgresql.org; Fri, 20 Oct 2023 16:28:57 +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 1qtsMq-001WcL-06 for pgsql-committers@lists.postgresql.org; Fri, 20 Oct 2023 16:28:56 +0000 Content-Type: multipart/mixed; boundary="===============2129679556707612771==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Extend ALTER OPERATOR to allow setting more optimization attribu X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 20 Oct 2023 16:28:56 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2129679556707612771== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RXh0ZW5kIEFMVEVSIE9QRVJBVE9SIHRvIGFsbG93IHNldHRpbmcgbW9yZSBvcHRpbWl6YXRpb24g YXR0cmlidXRlcy4KCkFsbG93IHRoZSBDT01NVVRBVE9SLCBORUdBVE9SLCBNRVJHRVMsIGFuZCBI QVNIRVMgYXR0cmlidXRlcyB0byBiZSBzZXQKYnkgQUxURVIgT1BFUkFUT1IuICBIb3dldmVyLCB3 ZSBkb24ndCBhbGxvdyBDT01NVVRBVE9SL05FR0FUT1IgdG8gYmUKY2hhbmdlZCBvbmNlIHNldCwg bm9yIGFsbG93IHRoZSBNRVJHRVMvSEFTSEVTIGZsYWdzIHRvIGJlIHVuc2V0IG9uY2UKc2V0LiAg Q2hhbmdlcyBsaWtlIHRoYXQgbWlnaHQgaW52YWxpZGF0ZSBwbGFucyBhbHJlYWR5IG1hZGUsIGFu ZApkZWFsaW5nIHdpdGggdGhlIGNvbnNlcXVlbmNlcyBzZWVtcyBsaWtlIG1vcmUgdHJvdWJsZSB0 aGFuIGl0J3Mgd29ydGguClRoZSBtYWluIHVzZS1jYXNlIHdlIGZvcmVzZWUgZm9yIHRoaXMgaXMg dG8gYWxsb3cgYWRkaXRpb24gb2YgbWlzc2VkCnByb3BlcnRpZXMgaW4gZXh0ZW5zaW9uIHVwZGF0 ZSBzY3JpcHRzLCBzdWNoIGFzIGV4dGVuZGluZyBhbiBleGlzdGluZwpvcGVyYXRvciB0byBzdXBw b3J0IGhhc2hpbmcuICBTbyBvbmx5IHRyYW5zaXRpb25zIGZyb20gbm90LXNldCB0byBzZXQKc3Rh dGVzIHNlZW0gdmVyeSB1c2VmdWwuCgpUaGlzIHBhdGNoIGFsc28gY2F1c2VzIHVzIHRvIHJlamVj dCBzb21lIGluY29ycmVjdCBjYXNlcyB0aGF0IGZvcm1lcmx5CnJlc3VsdGVkIGluIGluY29uc2lz dGVudCBjYXRhbG9nIHN0YXRlLCBzdWNoIGFzIHRyeWluZyB0byBzZXQgdGhlCmNvbW11dGF0b3Ig b2YgYW4gb3BlcmF0b3IgdG8gYmUgc29tZSBvdGhlciBvcGVyYXRvciB0aGF0IGFscmVhZHkgaGFz IGEKKGRpZmZlcmVudCkgY29tbXV0YXRvci4KCldoaWxlIGF0IGl0LCBtb3ZlIHRoZSBJbnZva2VP YmplY3RQb3N0Q3JlYXRlSG9vayBjYWxsIGZvciBDUkVBVEUKT1BFUkFUT1IgdG8gbm90IG9jY3Vy IHVudGlsIGFmdGVyIHdlJ3ZlIGZpeGVkIHVwIGNvbW11dGF0b3Igb3IgbmVnYXRvcgpsaW5rcyBh cyBuZWVkZWQuICBUaGUgcHJldmlvdXMgb3JkZXJpbmcgY291bGQgb25seSBiZSBqdXN0aWZpZWQg YnkKdGhpbmtpbmcgb2YgdGhlIE9wZXJhdG9yVXBkIGNhbGwgYXMgYSBraW5kIG9mIEFMVEVSIE9Q RVJBVE9SIHN0ZXA7CmJ1dCB3ZSBkb24ndCBjYWxsIEludm9rZU9iamVjdFBvc3RBbHRlckhvb2sg dGhlcmVpbi4gIEl0IHNlZW1zIGJldHRlcgp0byBsZXQgdGhlIGhvb2sgc2VlIHRoZSBmaW5hbCBz dGF0ZSBvZiB0aGUgb3BlcmF0b3Igb2JqZWN0LgoKSW4gdGhlIGRvY3VtZW50YXRpb24sIG1vdmUg dGhlIGRpc2N1c3Npb24gb2YgaG93IHRvIGVzdGFibGlzaApjb21tdXRhdG9yIHBhaXJzIGZyb20g eG9wZXIuc2dtbCB0byB0aGUgQ1JFQVRFIE9QRVJBVE9SIHJlZiBwYWdlLgoKVG9tbXkgUGF2bGlj ZWssIHJldmlld2VkIGFuZCBlZGl0b3JpYWxpemVkIGEgYml0IGJ5IG1lCgpEaXNjdXNzaW9uOiBo dHRwczovL3Bvc3Rnci5lcy9tL0NBRWhQLVctdkdWemY0dWRoUjVNOEJkdjg4VVluUHJob1NrajNp ZVIzUU5yc0dRb3FkZ0BtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFp bHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzJiNTE1 NGJlYWI3OTRlYWU2ZTYyNGMxNjJkNDk3ZGY5MjdlYzlkMjcKCk1vZGlmaWVkIEZpbGVzCi0tLS0t LS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9yZWYvYWx0ZXJfb3BlcmF0b3Iuc2dtbCAgICAgICAgICB8 ICA4NiArKysrKysrKy0KZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVfb3BlcmF0b3Iuc2dtbCAgICAg ICAgIHwgIDY2ICsrKysrKy0KZG9jL3NyYy9zZ21sL3hvcGVyLnNnbWwgICAgICAgICAgICAgICAg ICAgICAgIHwgIDQ0IC0tLS0tCnNyYy9iYWNrZW5kL2NhdGFsb2cvcGdfb3BlcmF0b3IuYyAgICAg ICAgICAgICB8IDI1NCArKysrKysrKysrKysrKysrKy0tLS0tLS0tLQpzcmMvYmFja2VuZC9jb21t YW5kcy9vcGVyYXRvcmNtZHMuYyAgICAgICAgICAgfCAxOTQgKysrKysrKysrKysrKysrKystLS0K c3JjL2JhY2tlbmQvcGFyc2VyL2dyYW0ueSAgICAgICAgICAgICAgICAgICAgIHwgICAyICsKc3Jj L2JhY2tlbmQvcGFyc2VyL3BhcnNlX29wZXIuYyAgICAgICAgICAgICAgIHwgIDM4ICsrLS0Kc3Jj L2luY2x1ZGUvY2F0YWxvZy9wZ19vcGVyYXRvci5oICAgICAgICAgICAgIHwgIDE1ICsrCnNyYy9p bmNsdWRlL3BhcnNlci9wYXJzZV9vcGVyLmggICAgICAgICAgICAgICB8ICAgMyArCnNyYy90ZXN0 L3JlZ3Jlc3MvZXhwZWN0ZWQvYWx0ZXJfb3BlcmF0b3Iub3V0ICB8IDE0OCArKysrKysrKysrKysr Ky0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9jcmVhdGVfb3BlcmF0b3Iub3V0IHwgIDQ0ICsr KysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2FsdGVyX29wZXJhdG9yLnNxbCAgICAgICB8IDEzNyAr KysrKysrKysrKysrLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9jcmVhdGVfb3BlcmF0b3Iuc3FsICAg ICAgfCAgNDMgKysrKysKMTMgZmlsZXMgY2hhbmdlZCwgODY5IGluc2VydGlvbnMoKyksIDIwNSBk ZWxldGlvbnMoLSkKCg== --===============2129679556707612771==--