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.96) (envelope-from ) id 1vpvLV-001Igh-2d for pgsql-committers@arkaria.postgresql.org; Tue, 10 Feb 2026 21:32:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vpvLV-00102l-0E for pgsql-committers@arkaria.postgresql.org; Tue, 10 Feb 2026 21:32:33 +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.96) (envelope-from ) id 1vpvLU-00102a-2b for pgsql-committers@lists.postgresql.org; Tue, 10 Feb 2026 21:32:33 +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.98.2) (envelope-from ) id 1vpvLR-000000001X9-2cDY for pgsql-committers@lists.postgresql.org; Tue, 10 Feb 2026 21:32:32 +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=77ifQKxH4odzwN/GDE47JHH/XekyjY/+/Anb5Cpnxkk=; b=e2zt9z2DbCira2Ku3BDfZydyGV ZYDv5sZ37CJM+VWsG6dWzP+zEn+luSsovUCB0DIRIN2WtEkixH2yAI9LII8QNI4Rn88FLJ9W9KWB2 Gf7GlQt0P/JT47qDVAntOtFD+ZIAo4F0Fdu2l91eurVhGrttr3LJjqhJNh8sF9MUwhlpkuIvqDkdi nghgBTsxN6VCjjZkOcKWSLPAnG1411rTPooQvQOMLhw5cnMoB2UQdPYdqzY79KZQRtEMOM3HF3wzs B7203OpowddVU8LheX3XETtCHPawqeYjbP+GwB2WGnQKQtrokWsk95fhw9/4nKaeQcIdcTTb/AnLw yVDWNROQ==; 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.96) (envelope-from ) id 1vpvLR-0004ch-1p for pgsql-committers@lists.postgresql.org; Tue, 10 Feb 2026 21:32:30 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vpvLQ-00035t-2N for pgsql-committers@lists.postgresql.org; Tue, 10 Feb 2026 21:32:29 +0000 Content-Type: multipart/mixed; boundary="===============3263219161926895613==" MIME-Version: 1.0 From: Robert Haas To: pgsql-committers@lists.postgresql.org Subject: pgsql: Store information about range-table flattening in the final plan X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 10 Feb 2026 21:32:29 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3263219161926895613== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U3RvcmUgaW5mb3JtYXRpb24gYWJvdXQgcmFuZ2UtdGFibGUgZmxhdHRlbmluZyBpbiB0aGUgZmlu YWwgcGxhbi4KClN1cHBvc2UgdGhhdCB3ZSdyZSBjdXJyZW50bHkgcGxhbm5pbmcgYSBxdWVyeSBh bmQsIHdoZW4gdGhhdCBzYW1lCnF1ZXJ5IHdhcyBwcmV2aW91c2x5IHBsYW5uZWQgYW5kIGV4ZWN1 dGVkLCB3ZSBsZWFybmVkIHNvbWV0aGluZyBhYm91dApob3cgYSBjZXJ0YWluIHRhYmxlIHdpdGhp biB0aGF0IHF1ZXJ5IHNob3VsZCBiZSBwbGFubmVkLiBXZSB3YW50IHRvCnRha2Ugbm90ZSB3aGVu IHRoYXQgc2FtZSB0YWJsZSBpcyBiZWluZyBwbGFubmVkIGR1cmluZyB0aGUgY3VycmVudApwbGFu bmluZyBjeWNsZSwgYnV0IHRoaXMgaXMgZGlmZmljdWx0IHRvIGRvLCBiZWNhdXNlIHRoZSBSVEkg b2YgdGhlCnRhYmxlIGZyb20gdGhlIHByZXZpb3VzIHBsYW4gd29uJ3QgbmVjZXNzYXJpbHkgYmUg ZXF1YWwgdG8gdGhlIFJUSQp0aGF0IHdlIHNlZSBkdXJpbmcgdGhlIGN1cnJlbnQgcGxhbm5pbmcg Y3ljbGUuIFRoaXMgaXMgYmVjYXVzZSBlYWNoCnN1YnF1ZXJ5IGhhcyBhIHNlcGFyYXRlIHJhbmdl IHRhYmxlIGR1cmluZyBwbGFubmluZywgYnV0IHRoZXNlIGFyZQpmbGF0dGVuZWQgaW50byBvbmUg cmFuZ2UgdGFibGUgd2hlbiBjb25zdHJ1Y3RpbmcgdGhlIGZpbmFsIHBsYW4sCmNoYW5naW5nIFJU SXMuCgpDb21taXQgOGM0OWE0ODRlOGViYjAxOTlmYmE0YmQ2OGVhYWVkYWY0OWI0OGVkMCBhbGxv d3MgdXMgdG8gbWF0Y2ggdXAKc3VicXVlcmllcyBzZWVuIGluIHRoZSBwcmV2aW91cyBwbGFubmlu ZyBjeWNsZXMgd2l0aCB0aGUgc3VicXVlcmllcwpjdXJyZW50bHkgYmVpbmcgcGxhbm5lZCBqdXN0 IGJ5IGNvbXBhcmluZyB0ZXh0dWFsIG5hbWVzLCBidXQgdGhhdCdzCm5vdCBxdWl0ZSBlbm91Z2gg dG8gbGV0IHVzIGRlZHVjZSBhbnl0aGluZyBhYm91dCBpbmRpdmlkdWFsIHRhYmxlcywKYmVjYXVz ZSB3ZSBkb24ndCBrbm93IHdoZXJlIGVhY2ggc3VicXVlcnkncyByYW5nZSB0YWJsZSBhcHBlYXJz IGluCnRoZSBmaW5hbCwgZmxhdHRlbmVkIHJhbmdlIHRhYmxlLgoKVG8gZml4IHRoYXQsIHN0b3Jl IGEgbGlzdCBvZiBTdWJQbGFuUlRJbmZvIG9iamVjdHMgaW4gdGhlIGZpbmFsCnBsYW5uZWQgc3Rh dGVtZW50LCBlYWNoIGluY2x1ZGluZyB0aGUgbmFtZSBvZiB0aGUgc3VicGxhbiwgdGhlIG9mZnNl dAphdCB3aGljaCBpdCBiZWdpbnMgaW4gdGhlIGZsYXR0ZW5lZCByYW5nZSB0YWJsZSwgYW5kIHdo ZXRoZXIgb3Igbm90Cml0IHdhcyBhIGR1bW15IHN1YnBsYW4gLS0gaWYgaXQgd2FzLCBzb21lIFJU SXMgbWF5IGhhdmUgYmVlbiBkcm9wcGVkCmZyb20gdGhlIGZpbmFsIHJhbmdlIHRhYmxlLCBidXQg YWxzbyB0aGVyZSdzIG5vIG5lZWQgdG8gY29udHJvbCBob3cKYSBkdW1teSBzdWJxdWVyeSBnZXRz IHBsYW5uZWQuIFRoZSB0b3BsZXZlbCBzdWJxdWVyeSBoYXMgbm8gbmFtZSBhbmQKYWx3YXlzIGJl Z2lucyBhdCBydG9mZnNldCAwLCBzbyB3ZSBtYWtlIG5vIGVudHJ5IGZvciBpdC4KClRoaXMgY29t bWl0IHRlYWNoZXMgcGdfb3ZlcmV4cGxhaW4ncyBSQU5HRV9UQUJMRSBvcHRpb24gdG8gbWFrZSB1 c2UKb2YgdGhpcyBuZXcgZGF0YSB0byBkaXNwbGF5IHRoZSBzdWJxdWVyeSBuYW1lIGZvciBlYWNo IHJhbmdlIHRhYmxlCmVudHJ5LgoKUmV2aWV3ZWQtYnk6IEx1a2FzIEZpdHRsIDxsdWthc0BmaXR0 bC5jb20+ClJldmlld2VkLWJ5OiBKYWt1YiBXYXJ0YWsgPGpha3ViLndhcnRha0BlbnRlcnByaXNl ZGIuY29tPgpSZXZpZXdlZC1ieTogR3JlZyBCdXJkIDxncmVnQGJ1cmQubWU+ClJldmlld2VkLWJ5 OiBKYWNvYiBDaGFtcGlvbiA8amFjb2IuY2hhbXBpb25AZW50ZXJwcmlzZWRiLmNvbT4KUmV2aWV3 ZWQtYnk6IEFtaXQgTGFuZ290ZSA8YW1pdGxhbmdvdGUwOUBnbWFpbC5jb20+ClJldmlld2VkLWJ5 OiBIYWlibyBZYW4gPHRyaXN0YW4ueWltQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IEFsZXhhbmRy YSBXYW5nIDxhbGV4YW5kcmEud2FuZy5vc3NAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwOi8v cG9zdGdyLmVzL20vQ0ErVGdtb1otSmgxVDZReVdvQ09ETVZRZGhUVVBZa2Faald6dHpQMUVuND1a SG9LUHp3QG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0t LS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvYWRiYWQ4MzNmM2Q5 ZTkxNzZlOGQ3MDA1ZjE1ZWE2MDU2OTAwMjI3ZAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0t LS0KY29udHJpYi9wZ19vdmVyZXhwbGFpbi9leHBlY3RlZC9wZ19vdmVyZXhwbGFpbi5vdXQgfCAx MDkgKysrKysrKysrKysrKysrKysrKysrCmNvbnRyaWIvcGdfb3ZlcmV4cGxhaW4vcGdfb3ZlcmV4 cGxhaW4uYyAgICAgICAgICAgIHwgIDM2ICsrKysrKysKY29udHJpYi9wZ19vdmVyZXhwbGFpbi9z cWwvcGdfb3ZlcmV4cGxhaW4uc3FsICAgICAgfCAgMTAgKysKc3JjL2JhY2tlbmQvb3B0aW1pemVy L3BsYW4vcGxhbm5lci5jICAgICAgICAgICAgICAgfCAgIDEgKwpzcmMvYmFja2VuZC9vcHRpbWl6 ZXIvcGxhbi9zZXRyZWZzLmMgICAgICAgICAgICAgICB8ICAyMCArKysrCnNyYy9pbmNsdWRlL25v ZGVzL3BhdGhub2Rlcy5oICAgICAgICAgICAgICAgICAgICAgIHwgICAzICsKc3JjL2luY2x1ZGUv bm9kZXMvcGxhbm5vZGVzLmggICAgICAgICAgICAgICAgICAgICAgfCAgMTcgKysrKwpzcmMvdG9v bHMvcGdpbmRlbnQvdHlwZWRlZnMubGlzdCAgICAgICAgICAgICAgICAgICB8ICAgMSArCjggZmls ZXMgY2hhbmdlZCwgMTk3IGluc2VydGlvbnMoKykKCg== --===============3263219161926895613==--