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 1roZC7-002B1k-NW for pgsql-committers@arkaria.postgresql.org; Mon, 25 Mar 2024 01:32:12 +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 1roZC5-00Gbwk-VW for pgsql-committers@arkaria.postgresql.org; Mon, 25 Mar 2024 01:32:10 +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 1roZC5-00Gbwa-FZ for pgsql-committers@lists.postgresql.org; Mon, 25 Mar 2024 01:32:10 +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.94.2) (envelope-from ) id 1roZC1-006Fqr-Hi for pgsql-committers@lists.postgresql.org; Mon, 25 Mar 2024 01:32:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=rTPDMnk9ncX4Rz8vKbn2c1SY85D5u6PtV78P+Xktros=; b=wS0ANrSfjbitEX5E0XQfJVwcgt 0mtjX+Q3r+u5CMfwrSHALFvvk6/QuswzQvBy55NQ/DeFMvw0nGx+RxC5HEHrbcBdrMgCj5yuWYdET C5OdIX0+q2fBth0FtsCc10wKvlEaCVBbWeQqcqFFr7J4GO0IjdDl27xXq9QAP1PZ1eWf94wvMgCD4 +qTQYIYXu4y8VwsfHeXbM5LNnI1yusfqbhUJsGiq29WrADOPKRDeQQaSfOJ8iQ/D49IlJO2JRNbNj kfveCZ3kjN4mlJyH0eKCtgfD9xql1kSOMv2wrFhJKSvw3uNaZKO38q2dKNfedwiY326/PIZlTVpJb /5f9yxnw==; 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 1roZC2-00HMZi-4h for pgsql-committers@lists.postgresql.org; Mon, 25 Mar 2024 01:32:06 +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 1roZC0-005V2k-Vi for pgsql-committers@lists.postgresql.org; Mon, 25 Mar 2024 01:32:05 +0000 Content-Type: multipart/mixed; boundary="===============3197639975748664359==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Allow planner to use Merge Append to efficiently implement UNION X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 25 Mar 2024 01:32:05 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3197639975748664359== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWxsb3cgcGxhbm5lciB0byB1c2UgTWVyZ2UgQXBwZW5kIHRvIGVmZmljaWVudGx5IGltcGxlbWVu dCBVTklPTgoKVW50aWwgbm93LCBVTklPTiBxdWVyaWVzIGhhdmUgb2Z0ZW4gYmVlbiBzdWJvcHRp bWFsIGFzIHRoZSBwbGFubmVyIGhhcwpvbmx5IGV2ZXIgY29uc2lkZXJlZCB1c2luZyBhbiBBcHBl bmQgbm9kZSBhbmQgbWFraW5nIHRoZSByZXN1bHRzIHVuaXF1ZQpieSBlaXRoZXIgdXNpbmcgYSBI YXNoIEFnZ3JlZ2F0ZSwgb3IgYnkgU29ydGluZyB0aGUgZW50aXJlIEFwcGVuZCByZXN1bHQKYW5k IHJ1bm5pbmcgaXQgdGhyb3VnaCB0aGUgVW5pcXVlIG9wZXJhdG9yLiAgQm90aCBvZiB0aGVzZSBt ZXRob2RzCmFsd2F5cyByZXF1aXJlIHJlYWRpbmcgYWxsIHJvd3MgZnJvbSB0aGUgdW5pb24gc3Vi cXVlcmllcy4KCkhlcmUgd2UgYWRqdXN0IHRoZSB1bmlvbiBwbGFubmVyIHNvIHRoYXQgaXQgY2Fu IHJlcXVlc3QgdGhhdCBlYWNoIHN1YnF1ZXJ5CnByb2R1Y2UgcmVzdWx0cyBpbiB0YXJnZXQgbGlz dCBvcmRlciBzbyB0aGF0IHRoZXNlIGNhbiBiZSBNZXJnZSBBcHBlbmRlZAp0b2dldGhlciBhbmQg bWFkZSB1bmlxdWUgd2l0aCBhIFVuaXF1ZSBub2RlLiAgVGhpcyBjYW4gaW1wcm92ZSBwZXJmb3Jt YW5jZQpzaWduaWZpY2FudGx5IGFzIHRoZSB1bmlvbiBjaGlsZCBjYW4gbWFrZSB1c2Ugb2YgdGhl IGxpa2VzIG9mIGJ0cmVlCmluZGV4ZXMgYW5kL29yIE1lcmdlIEpvaW5zIHRvIHByb3ZpZGUgdGhl IHRvcC1sZXZlbCBVTklPTiB3aXRoIHByZXNvcnRlZAppbnB1dC4gIFRoaXMgaXMgZXNwZWNpYWxs eSBnb29kIGlmIHRoZSB0b3AtbGV2ZWwgVU5JT04gY29udGFpbnMgYSBMSU1JVApub2RlIHRoYXQg bGltaXRzIHRoZSBvdXRwdXQgcm93cyB0byBhIHNtYWxsIHN1YnNldCBvZiB0aGUgdW5pb25lZCBy b3dzIGFzCmNoZWFwIHN0YXJ0dXAgcGxhbnMgY2FuIGJlIHVzZWQuCgpBdXRob3I6IERhdmlkIFJv d2xleQpSZXZpZXdlZC1ieTogUmljaGFyZCBHdW8sIEFuZHkgRmFuCkRpc2N1c3Npb246IGh0dHBz Oi8vcG9zdGdyLmVzL20vQ0FBcEhEdnBiXzYzWFFvZG14S1VGOHZiOU03Q3h5VXlUNHNXdkVncWVR VS1HQjdRRm9RQG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwot LS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNjZjMDE4NWEz ZDE0YmJiZjUxZDBmYzlkMjY3MDkzZmZlYzczNTIzMQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0t LS0tLS0KY29udHJpYi9wb3N0Z3Jlc19mZHcvZXhwZWN0ZWQvcG9zdGdyZXNfZmR3Lm91dCB8ICAg NyArCmNvbnRyaWIvcG9zdGdyZXNfZmR3L3NxbC9wb3N0Z3Jlc19mZHcuc3FsICAgICAgfCAgIDkg KwpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9lcXVpdmNsYXNzLmMgICAgICAgIHwgIDYxICsr KwpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9wYXRoa2V5cy5jICAgICAgICAgIHwgIDE5ICsK c3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vcGxhbm5lci5jICAgICAgICAgICB8ICA4NSArKy0K c3JjL2JhY2tlbmQvb3B0aW1pemVyL3ByZXAvcHJlcHVuaW9uLmMgICAgICAgICB8IDcxMSArKysr KysrKysrKysrKysrKy0tLS0tLS0tCnNyYy9iYWNrZW5kL3BhcnNlci9hbmFseXplLmMgICAgICAg ICAgICAgICAgICAgfCAgIDMgKy0Kc3JjL2luY2x1ZGUvbm9kZXMvcGF0aG5vZGVzLmggICAgICAg ICAgICAgICAgICB8ICAgMiArCnNyYy9pbmNsdWRlL29wdGltaXplci9wYXRocy5oICAgICAgICAg ICAgICAgICAgfCAgIDQgKwpzcmMvaW5jbHVkZS9vcHRpbWl6ZXIvcHJlcC5oICAgICAgICAgICAg ICAgICAgIHwgICAyICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvY29sbGF0ZS5pY3UudXRm OC5vdXQgfCAgIDIgKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2luY3JlbWVudGFsX3NvcnQu b3V0IHwgIDEzICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvdW5pb24ub3V0ICAgICAgICAg ICAgfCAgMzIgKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvY29sbGF0ZS5pY3UudXRmOC5zcWwgICAg ICB8ICAgMiArCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3VuaW9uLnNxbCAgICAgICAgICAgICAgICAg fCAgIDggKy0KMTUgZmlsZXMgY2hhbmdlZCwgNzA3IGluc2VydGlvbnMoKyksIDI1MyBkZWxldGlv bnMoLSkKCg== --===============3197639975748664359==--