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 1tOObs-0063ON-8e for pgsql-committers@arkaria.postgresql.org; Thu, 19 Dec 2024 22:03:08 +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 1tOObq-000bDD-Tp for pgsql-committers@arkaria.postgresql.org; Thu, 19 Dec 2024 22:03:06 +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 1tOObq-000b8K-Lf for pgsql-committers@lists.postgresql.org; Thu, 19 Dec 2024 22:03:06 +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 1tOObm-000eRR-RF for pgsql-committers@lists.postgresql.org; Thu, 19 Dec 2024 22:03:05 +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 1tOObl-001MU1-4y for pgsql-committers@lists.postgresql.org; Thu, 19 Dec 2024 22:03:01 +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 1tOObk-000PxL-HW for pgsql-committers@lists.postgresql.org; Thu, 19 Dec 2024 22:03:01 +0000 Content-Type: multipart/mixed; boundary="===============3064285047403713556==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve planner's handling of SetOp plans. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 19 Dec 2024 22:03:01 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3064285047403713556== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSBwbGFubmVyJ3MgaGFuZGxpbmcgb2YgU2V0T3AgcGxhbnMuCgpSZW1vdmUgdGhlIGNv ZGUgZm9yIGluc2VydGluZyBmbGFnIGNvbHVtbnMgaW4gdGhlIGlucHV0cyBvZiBhIFNldE9wLgpU aGF0IHdhcyB0aGUgb25seSByZWFzb24gd2h5IHRoZXJlIHdvdWxkIGJlIHJlc2p1bmsgY29sdW1u cyBpbiBhCnNldC1vcGVyYXRpb25zIHBsYW4gdHJlZSwgc28gd2UgY2FuIGdldCByaWQgb2Ygc29t ZSBjb2RlIHRoYXQKc3VwcG9ydGVkIHRoYXQsIHRvby4KCkdldCByaWQgb2YgY2hvb3NlX2hhc2hl ZF9zZXRvcCgpIGluIGZhdm9yIG9mIGJ1aWxkaW5nIFBhdGhzIGZvcgp0aGUgaGFzaGVkIGFuZCBz b3J0ZWQgYWx0ZXJuYXRpdmVzLCBhbmQgbGV0dGluZyB0aGVtIGZpZ2h0IGl0IG91dAp3aXRoaW4g YWRkX3BhdGgoKS4KClJlbW92ZSBzZXRfb3BlcmF0aW9uX29yZGVyZWRfcmVzdWx0c191c2VmdWwo KSwgd2hpY2ggd2FzIGdpdmluZyB3cm9uZwphbnN3ZXJzIGR1ZSB0byBleGFtaW5pbmcgdGhlIHdy b25nIGFuY2VzdG9yIG5vZGU6IHdlIG5lZWQgdG8gZXhhbWluZQp0aGUgaW1tZWRpYXRlIFNldE9w ZXJhdGlvblN0bXQgcGFyZW50IG5vdCB0aGUgdG9wbW9zdCBub2RlLiAgSW5zdGVhZAptYWtlIGVh Y2ggY2FsbGVyIG9mIHJlY3Vyc2Vfc2V0X29wZXJhdGlvbnMoKSBwYXNzIGRvd24gdGhlIHJlbGV2 YW50CnBhcmVudCBub2RlLiAgKFRoaXMgdGhpbmtvIHNlZW1zIHRvIGhhdmUgbGVkIG9ubHkgdG8g d2FzdGVkIHBsYW5uaW5nCmN5Y2xlcyBhbmQgcG9zc2libHktaW5mZXJpb3IgcGxhbnMsIG5vdCB3 cm9uZyBxdWVyeSBhbnN3ZXJzLiAgUGVyaGFwcwp3ZSBzaG91bGQgYmFjay1wYXRjaCBpdCwgYnV0 IEknbSBub3QgZG9pbmcgc28gcmlnaHQgbm93LikKClRlYWNoIGdlbmVyYXRlX25vbnVuaW9uX3Bh dGhzKCkgdG8gY29uc2lkZXIgcHJlLXNvcnRlZCBpbnB1dHMgZm9yCnNvcnRlZCBTZXRPcHMsIHJh dGhlciB0aGFuIGFsd2F5cyBnZW5lcmF0aW5nIGEgU29ydCBub2RlLgoKUGF0Y2ggYnkgbWU7IHRo YW5rcyB0byBSaWNoYXJkIEd1byBhbmQgRGF2aWQgUm93bGV5IGZvciByZXZpZXcuCgpEaXNjdXNz aW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzE4NTAxMzguMTczMTU0OTYxMUBzc3MucGdoLnBhLnVz CgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3Rn cmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvOGQ5NmY1N2Q1Y2M3OWMwYzUxMDUwYmI3MDdjMTliZjA3 ZDI4OTVlYgoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1p emVyL3BsYW4vcGxhbm5lci5jICAgIHwgICA3ICstCnNyYy9iYWNrZW5kL29wdGltaXplci9wcmVw L3ByZXB1bmlvbi5jICB8IDQ3OCArKysrKysrKysrKystLS0tLS0tLS0tLS0tLS0tLS0tLQpzcmMv YmFja2VuZC9vcHRpbWl6ZXIvdXRpbC9wYXRobm9kZS5jICAgfCAgNjkgKysrKy0Kc3JjL2luY2x1 ZGUvb3B0aW1pemVyL3ByZXAuaCAgICAgICAgICAgIHwgICAxIC0Kc3JjL3Rlc3QvcmVncmVzcy9l eHBlY3RlZC9zdWJzZWxlY3Qub3V0IHwgIDQ4ICsrKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3Rl ZC91bmlvbi5vdXQgICAgIHwgIDUzICsrLS0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvc3Vic2VsZWN0 LnNxbCAgICAgIHwgIDMyICsrLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC91bmlvbi5zcWwgICAgICAg ICAgfCAgIDkgKwo4IGZpbGVzIGNoYW5nZWQsIDM2NSBpbnNlcnRpb25zKCspLCAzMzIgZGVsZXRp b25zKC0pCgo= --===============3064285047403713556==--