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 1s55He-0033ev-Th for pgsql-committers@arkaria.postgresql.org; Thu, 09 May 2024 15:02:10 +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 1s55Hd-008BhL-7V for pgsql-committers@arkaria.postgresql.org; Thu, 09 May 2024 15:02:09 +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 1s55Hd-008BhD-0u for pgsql-committers@lists.postgresql.org; Thu, 09 May 2024 15:02:09 +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 1s55Ha-000BuM-Hc for pgsql-committers@lists.postgresql.org; Thu, 09 May 2024 15:02:08 +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 1s55HZ-000ddF-Fc for pgsql-committers@lists.postgresql.org; Thu, 09 May 2024 15:02:05 +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 1s55HY-000Aat-9B for pgsql-committers@lists.postgresql.org; Thu, 09 May 2024 15:02:05 +0000 Content-Type: multipart/mixed; boundary="===============0574518317591423068==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Make left-join removal safe under -DREALLOCATE_BITMAPSETS. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 09 May 2024 15:02:05 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0574518317591423068== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 TWFrZSBsZWZ0LWpvaW4gcmVtb3ZhbCBzYWZlIHVuZGVyIC1EUkVBTExPQ0FURV9CSVRNQVBTRVRT LgoKVGhlIGluaXRpYWwgYnVpbGRpbmcgb2YgUmVzdHJpY3RJbmZvcyBhbmQgU3BlY2lhbEpvaW5J bmZvcyB0ZW5kcyB0bwpjcmVhdGUgc3RydWN0dXJlcyB0aGF0IHNoYXJlIHJlbGlkIHNldHMgKHN1 Y2ggYXMgc3luX2xlZnRoYW5kIGFuZApvdXRlcl9yZWxpZHMpLiAgVGhlcmUncyBub3RoaW5nIHdy b25nIHdpdGggdGhhdCBpbiBpdHNlbGYsIGJ1dCB3aGVuCndlIG1vZGlmeSB0aG9zZSByZWxpZCBz ZXRzIGR1cmluZyBqb2luIHJlbW92YWwsIHdlIGhhdmUgdG8gYmUgc3VyZQpub3QgdG8gY29ycnVw dCB0aGUgdmFsdWVzIHRoYXQgb3RoZXIgc3RydWN0dXJlcyBhcmUgcG9pbnRpbmcgYXQuCnJlbW92 ZV9yZWxfZnJvbV9xdWVyeSgpIHdhcyBjYXJlbGVzcyBhYm91dCB0aGlzLiAgSXQgYWNjaWRlbnRh bGx5CndvcmtlZCBhbnl3YXkgYmVjYXVzZSAoMSkgd2UnZCBuZXZlciBiZSByZWR1Y2luZyB0aGUg c2V0cyB0byBlbXB0eSwKc28gdGhleSB3b3VsZG4ndCBnZXQgcGZyZWUnZDsgYW5kICgyKSB0aGUg aW4tcGxhY2UgbW9kaWZpY2F0aW9uIGlzIHRoZQpzYW1lIG9uZSB0aGF0IHdlIGRpZCBvciB3aWxs IGFwcGx5IHRvIHRoZSBvdGhlciBzdHJ1Y3QncyByZWxpZCBzZXQsCnNvIHRoYXQgdGhlcmUgd2Fz bid0IHZpc2libGUgY29ycnVwdGlvbiBhdCB0aGUgZW5kIG9mIHRoZSBwcm9jZXNzLgoKV2hpbGUg dGhlcmUncyBubyBsaXZlIGJ1ZyBpbiBhIHN0YW5kYXJkIGJ1aWxkLCBvZiBjb3Vyc2UgdGhpcyBp cyB3YXkKdG9vIGZyYWdpbGUgdG8gYWNjZXB0IGdvaW5nIGZvcndhcmQuICAoTWF5YmUgd2Ugc2hv dWxkIGJhY2stcGF0Y2gKdGhpcyBjaGFuZ2UgdG9vIGZvciBzYWZldHksIGJ1dCBJJ3ZlIHJlZnJh aW5lZCBmb3Igbm93LikKClRoaXMgYnVnIHdhcyBleHBvc2VkIGJ5IHRoZSByZWNlbnQgaW52ZW50 aW9uIG9mIFJFQUxMT0NBVEVfQklUTUFQU0VUUy4KQ29tbWl0IGUwNDc3ODM3YyBoYWQgaW5zdGFs bGVkIGEgZml4LCBidXQgdGhhdCB3ZW50IGF3YXkgd2l0aCB0aGUKcmV2ZXJzaW9uIG9mIFNKRSwg c28gbm93IHdlIG5lZWQgdG8gZml4IGl0IGFnYWluLgoKRGF2aWQgUm93bGV5IGFuZCBUb20gTGFu ZQoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQUNKdWZ4RlZRbXI0PUpXSEFPU0x1 S0E1Wnk5SDI2blk2dFZyUkZCT2VrSG9BTHlDa1FAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0t LS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcv Y29tbWl0ZGlmZi9jN2JlM2MwMTViZmU1MThkMDYyNDAyOWU2NDAyNTIyNDhhM2M4NjE1CgpNb2Rp ZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9hbmFs eXplam9pbnMuYyB8IDE4ICsrKysrKysrKysrKysrKystLQoxIGZpbGUgY2hhbmdlZCwgMTYgaW5z ZXJ0aW9ucygrKSwgMiBkZWxldGlvbnMoLSkKCg== --===============0574518317591423068==--