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 1uoARE-00HHJJ-UV for pgsql-committers@arkaria.postgresql.org; Tue, 19 Aug 2025 00:42:58 +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 1uoARE-0048ja-D5 for pgsql-committers@arkaria.postgresql.org; Tue, 19 Aug 2025 00:42:57 +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 1uoAOG-0046s1-JP for pgsql-committers@lists.postgresql.org; Tue, 19 Aug 2025 00:39:53 +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.96) (envelope-from ) id 1uoAOE-000bvx-0v for pgsql-committers@lists.postgresql.org; Tue, 19 Aug 2025 00:39:52 +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=x0vKi0lrbldgJ772b4Vo1pNxej54RIcYag1DPkKEC8I=; b=o8z6ZihxCdYw9ZyFkyrQN83F3J Iof8RWT6pLkXiIT3w53D8ZKNeztoRlYH2csYY2wQSGPrtbe29WbnUOV1C0VTxzuHWmbszO+rQzBTp /0WnUkxqLNeM7jr5T6Wn09D8C5IslpkL0EoUkmKZfBz/F3zn9mcoLWjnd++f2BwZqc5tzJFksNFpZ F7Avj78XHXnS/rAMoyGTMFnUJeXs+XEv69AlQH/PsjFYPoeQJo6qYzZNKn2paiPOQoegQLffMTCTe Xa+xnxPL8zqPIb1s6eqUashBNhvtzynwDZ9GGp8f0nuCi1bl2zUcplyuEj2D0tiEE2eOfTR+ReEDW lOAKiKEw==; 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 1uoAOC-001bTP-Pz for pgsql-committers@lists.postgresql.org; Tue, 19 Aug 2025 00:39:48 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uoAOB-000Yq1-0a for pgsql-committers@lists.postgresql.org; Tue, 19 Aug 2025 00:39:47 +0000 Content-Type: multipart/mixed; boundary="===============7406817781996665856==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Pathify RHS unique-ification for semijoin planning X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 19 Aug 2025 00:39:47 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7406817781996665856== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UGF0aGlmeSBSSFMgdW5pcXVlLWlmaWNhdGlvbiBmb3Igc2VtaWpvaW4gcGxhbm5pbmcKClRoZXJl IGFyZSB0d28gaW1wbGVtZW50YXRpb24gdGVjaG5pcXVlcyBmb3Igc2VtaWpvaW5zOiBvbmUgdXNl cyB0aGUKSk9JTl9TRU1JIGpvaW50eXBlLCB3aGVyZSB0aGUgZXhlY3V0b3IgZW1pdHMgYXQgbW9z dCBvbmUgbWF0Y2hpbmcgcm93CnBlciBsZWZ0LWhhbmQgc2lkZSAoTEhTKSByb3c7IHRoZSBvdGhl ciB1bmlxdWUtaWZpZXMgdGhlIHJpZ2h0LWhhbmQKc2lkZSAoUkhTKSBhbmQgdGhlbiBwZXJmb3Jt cyBhIHBsYWluIGlubmVyIGpvaW4uCgpUaGUgbGF0dGVyIHRlY2huaXF1ZSBjdXJyZW50bHkgaGFz IHNvbWUgZHJhd2JhY2tzIHJlbGF0ZWQgdG8gdGhlCnVuaXF1ZS1pZmljYXRpb24gc3RlcC4KCiog T25seSB0aGUgY2hlYXBlc3QtdG90YWwgcGF0aCBvZiB0aGUgUkhTIGlzIGNvbnNpZGVyZWQgZHVy aW5nCnVuaXF1ZS1pZmljYXRpb24uICBUaGlzIG1heSBjYXVzZSB1cyB0byBtaXNzIHNvbWUgb3B0 aW1pemF0aW9uCm9wcG9ydHVuaXRpZXM7IGZvciBleGFtcGxlLCBhIHBhdGggd2l0aCBhIGJldHRl ciBzb3J0IG9yZGVyIG1pZ2h0IGJlCm92ZXJsb29rZWQgc2ltcGx5IGJlY2F1c2UgaXQgaXMgbm90 IHRoZSBjaGVhcGVzdCBpbiB0b3RhbCBjb3N0LiAgU3VjaAphIHBhdGggY291bGQgaGVscCBhdm9p ZCBhIHNvcnQgYXQgYSBoaWdoZXIgbGV2ZWwsIHBvdGVudGlhbGx5CnJlc3VsdGluZyBpbiBhIGNo ZWFwZXIgb3ZlcmFsbCBwbGFuLgoKKiBXZSBjdXJyZW50bHkgcmVseSBvbiBoZXVyaXN0aWNzIHRv IGNob29zZSBiZXR3ZWVuIGhhc2gtYmFzZWQgYW5kCnNvcnQtYmFzZWQgdW5pcXVlLWlmaWNhdGlv bi4gIEEgYmV0dGVyIGFwcHJvYWNoIHdvdWxkIGJlIHRvIGdlbmVyYXRlCnBhdGhzIGZvciBib3Ro IG1ldGhvZHMgYW5kIGFsbG93IGFkZF9wYXRoKCkgdG8gZGVjaWRlIHdoaWNoIG9uZSBpcwpwcmVm ZXJhYmxlLCBjb25zaXN0ZW50IHdpdGggaG93IHBhdGggc2VsZWN0aW9uIGlzIGhhbmRsZWQgZWxz ZXdoZXJlIGluCnRoZSBwbGFubmVyLgoKKiBJbiB0aGUgc29ydC1iYXNlZCBpbXBsZW1lbnRhdGlv biwgd2UgY3VycmVudGx5IHBheSBubyBhdHRlbnRpb24gdG8KdGhlIHBhdGhrZXlzIG9mIHRoZSBp bnB1dCBzdWJwYXRoIG9yIHRoZSByZXN1bHRpbmcgb3V0cHV0LiAgVGhpcyBjYW4KcmVzdWx0IGlu IHJlZHVuZGFudCBzb3J0IG5vZGVzIGJlaW5nIGFkZGVkIHRvIHRoZSBmaW5hbCBwbGFuLgoKVGhp cyBwYXRjaCBpbXByb3ZlcyBzZW1pam9pbiBwbGFubmluZyBieSBjcmVhdGluZyBhIG5ldyBSZWxP cHRJbmZvIGZvcgp0aGUgUkhTIHJlbCB0byByZXByZXNlbnQgaXRzIHVuaXF1ZS1pZmllZCB2ZXJz aW9uLiAgSXQgdGhlbiBnZW5lcmF0ZXMKbXVsdGlwbGUgcGF0aHMgdGhhdCByZXByZXNlbnQgZWxp bWluYXRpb24gb2YgZGlzdGluY3Qgcm93cyBmcm9tIHRoZQpSSFMsIGNvbnNpZGVyaW5nIGJvdGgg YSBoYXNoLWJhc2VkIGltcGxlbWVudGF0aW9uIHVzaW5nIHRoZSBjaGVhcGVzdAp0b3RhbCBwYXRo IG9mIHRoZSBvcmlnaW5hbCBSSFMgcmVsLCBhbmQgc29ydC1iYXNlZCBpbXBsZW1lbnRhdGlvbnMK dGhhdCBlaXRoZXIgZXhwbG9pdCBwcmVzb3J0ZWQgaW5wdXQgcGF0aHMgb3IgZXhwbGljaXRseSBz b3J0IHRoZQpjaGVhcGVzdCB0b3RhbCBwYXRoLiAgQWxsIHJlc3VsdGluZyBwYXRocyBjb21wZXRl IGluIGFkZF9wYXRoKCksIGFuZAp0aG9zZSBkZWVtZWQgd29ydGh5IG9mIGNvbnNpZGVyYXRpb24g YXJlIGFkZGVkIHRvIHRoZSBuZXcgUmVsT3B0SW5mby4KRmluYWxseSwgdGhlIHVuaXF1ZS1pZmll ZCByZWwgaXMgam9pbmVkIHdpdGggdGhlIG90aGVyIHNpZGUgb2YgdGhlCnNlbWlqb2luIHVzaW5n IGEgcGxhaW4gaW5uZXIgam9pbi4KCkFzIGEgc2lkZSBlZmZlY3QsIG1vc3Qgb2YgdGhlIGNvZGUg cmVsYXRlZCB0byB0aGUgSk9JTl9VTklRVUVfT1VURVIKYW5kIEpPSU5fVU5JUVVFX0lOTkVSIGpv aW50eXBlcyAtLSB1c2VkIHRvIGluZGljYXRlIHRoYXQgdGhlIExIUyBvcgpSSFMgcGF0aCBzaG91 bGQgYmUgbWFkZSB1bmlxdWUgLS0gaGFzIGJlZW4gcmVtb3ZlZC4gIEJlc2lkZXMsIHRoZQpUX1Vu aXF1ZSBwYXRoIG5vdyBoYXMgdGhlIHNhbWUgbWVhbmluZyBmb3IgYm90aCBzZW1pam9pbnMgYW5k IHVwcGVyCkRJU1RJTkNUIGNsYXVzZXM6IGl0IHJlcHJlc2VudHMgYWRqYWNlbnQtZHVwbGljYXRl IHJlbW92YWwgb24KcHJlc29ydGVkIGlucHV0LiAgVGhpcyBwYXRjaCB1bmlmaWVzIHRoZWlyIGhh bmRsaW5nIGJ5IHNoYXJpbmcgdGhlCnNhbWUgZGF0YSBzdHJ1Y3R1cmVzIGFuZCBmdW5jdGlvbnMu CgpUaGlzIHBhdGNoIGFsc28gcmVtb3ZlcyB0aGUgVU5JUVVFX1BBVEhfTk9PUCByZWxhdGVkIGNv ZGUgYWxvbmcgdGhlCndheSwgYXMgaXQgaXMgZGVhZCBjb2RlIC0tIGlmIHRoZSBSSFMgcmVsIGlz IHByb3ZhYmx5IHVuaXF1ZSwgdGhlCnNlbWlqb2luIHNob3VsZCBoYXZlIGFscmVhZHkgYmVlbiBz aW1wbGlmaWVkIHRvIGEgcGxhaW4gaW5uZXIgam9pbiBieQphbmFseXplam9pbnMuYy4KCkF1dGhv cjogUmljaGFyZCBHdW8gPGd1b2ZlbmdsaW51eEBnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBBbGV4 YW5kcmEgV2FuZyA8YWxleGFuZHJhLndhbmcub3NzQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IHdl bmh1aSBxaXUgPHFpdXdlbmh1aWZ4QGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0 Z3IuZXMvbS9DQU1iV3M0LUVCbmFSdkVzN2ZyVExic1hpd2VTVFVYaWZzdGVGLWQzcnZ2MDFGS084 NndAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0K aHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8yNDIyNWFkOWFhZmM1NzYy OTVlMjEwMDI2ZDhmZmE5ZjUwZDYxMTQ1CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpz cmMvYmFja2VuZC9vcHRpbWl6ZXIvUkVBRE1FICAgICAgICAgICAgICAgICB8ICAgMyArLQpzcmMv YmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9jb3N0c2l6ZS5jICAgICAgICB8ICAxMSArLQpzcmMvYmFj a2VuZC9vcHRpbWl6ZXIvcGF0aC9qb2lucGF0aC5jICAgICAgICB8IDMzOCArKysrKy0tLS0tLS0t LS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9qb2lucmVscy5jICAgICAgICB8ICAxOCAr LQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9jcmVhdGVwbGFuLmMgICAgICB8IDMwMSArKy0t LS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3BsYW5uZXIuYyAgICAgICAg IHwgNTE4ICsrKysrKysrKysrKysrKysrKysrKysrKysrLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIv cHJlcC9wcmVwdW5pb24uYyAgICAgICB8ICAzMCArLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRp bC9wYXRobm9kZS5jICAgICAgICB8IDMwNiArLS0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL29w dGltaXplci91dGlsL3JlbG5vZGUuYyAgICAgICAgIHwgIDEzICstCnNyYy9pbmNsdWRlL25vZGVz L25vZGVzLmggICAgICAgICAgICAgICAgICAgIHwgICA0ICstCnNyYy9pbmNsdWRlL25vZGVzL3Bh dGhub2Rlcy5oICAgICAgICAgICAgICAgIHwgIDc3ICsrLS0Kc3JjL2luY2x1ZGUvb3B0aW1pemVy L3BhdGhub2RlLmggICAgICAgICAgICAgfCAgMTIgKy0Kc3JjL2luY2x1ZGUvb3B0aW1pemVyL3Bs YW5uZXIuaCAgICAgICAgICAgICAgfCAgIDMgKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2pv aW4ub3V0ICAgICAgICAgICB8ICAxNSArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3BhcnRp dGlvbl9qb2luLm91dCB8ICA5NCArKy0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3N1YnNl bGVjdC5vdXQgICAgICB8IDIzMyArKysrKysrKysrKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvc3Vi c2VsZWN0LnNxbCAgICAgICAgICAgfCAgNjcgKysrKwpzcmMvdG9vbHMvcGdpbmRlbnQvdHlwZWRl ZnMubGlzdCAgICAgICAgICAgICB8ICAgMiAtCjE4IGZpbGVzIGNoYW5nZWQsIDEwNzQgaW5zZXJ0 aW9ucygrKSwgOTcxIGRlbGV0aW9ucygtKQoK --===============7406817781996665856==--