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 1v32p5-00ASJ0-1Y for pgsql-committers@arkaria.postgresql.org; Mon, 29 Sep 2025 01:37:03 +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 1v32p2-00GBVT-Pu for pgsql-committers@arkaria.postgresql.org; Mon, 29 Sep 2025 01:37:01 +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 1v32p2-00GBVL-I0 for pgsql-committers@lists.postgresql.org; Mon, 29 Sep 2025 01:37:01 +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.96) (envelope-from ) id 1v32oz-000QM3-1b for pgsql-committers@lists.postgresql.org; Mon, 29 Sep 2025 01:37:00 +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=hmCOo21iC4lSRGOoRB4fbzsPHk7VqdhlfxaA+elrNjM=; b=C1Fw3iBDvjMFClpI5iOjbU3ikr 4XdlcBvF1r7F+bKkJ6Z8xZYuTp7QISRekBLDuK42/GZFVXLzNSrw0Ob2vOXoUAbesEaxJkDqzmBmq 7YnYC6rYD79gX1JuLOR4+4pmpv+JLAa2ewJeQUDwsXGd44Eg6UnxloFe/+rhQv36QkpKt5SPN7CC9 etRFmQCKd+UKXtwealj7f+nDBPOJRbquV/F2bKhFBq7hVTFgI9VlNeAIXatDqnO/soTV3pxwH4R5U liXpc2n11j/ONaW2gu+SYKWNy8Ge1Ftg/oyqcfC/7a+yBx9oVt0FXMDq2ygTRyA6RdC/7/Emsc8dv gI8FkCRw==; 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 1v32oy-001Eb0-4d for pgsql-committers@lists.postgresql.org; Mon, 29 Sep 2025 01:36:57 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1v32oy-000YMH-0T for pgsql-committers@lists.postgresql.org; Mon, 29 Sep 2025 01:36:56 +0000 Content-Type: multipart/mixed; boundary="===============7310660360728589448==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve planner's width estimates for set operations X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 29 Sep 2025 01:36:56 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7310660360728589448== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSBwbGFubmVyJ3Mgd2lkdGggZXN0aW1hdGVzIGZvciBzZXQgb3BlcmF0aW9ucwoKRm9y IFVOSU9OLCBFWENFUFQgYW5kIElOVEVSU0VDVCwgd2Ugd2VyZSBub3QgdmVyeSBnb29kIGF0IGVz dGltYXRpbmcgdGhlClBhdGhUYXJnZXQud2lkdGggZm9yIHRoZSBzZXQgb3BlcmF0aW9uLiAgU2lu Y2UgdGhlIHRhcmdldGxpc3Qgb2YgdGhlIHNldApvcGVyYXRpb24gaXMgbWFkZSB1cCBvZiBWYXJz IHdpdGggdmFybm89PTAsIHRoaXMgd291bGQgcmVzdWx0IGluCmdldF9leHByX3dpZHRoKCkgYXBw bHlpbmcgYSBkZWZhdWx0IGVzdGltYXRlIGJhc2VkIG9uIHRoZSBWYXIncyB0eXBlCnJhdGhlciB0 aGFuIHRha2luZyB3aWR0aCBlc3RpbWF0ZXMgZnJvbSBhbnkgcmVsYXRpb24ncyBzdGF0aXN0aWNz LgoKSGVyZSB3ZSBhdHRlbXB0IHRvIGltcHJvdmUgdGhlIHNpdHVhdGlvbiBieSBsb29raW5nIGF0 IHRoZSB3aWR0aCBlc3RpbWF0ZXMKZm9yIHRoZSBzZXQgb3BlcmF0aW9uIGNoaWxkIHBhdGhzIGFu ZCBjYWxjdWxhdGluZyB0aGUgYXZlcmFnZSB3aWR0aCBvZiB0aGUKcmVsZXZhbnQgY2hpbGQgcGF0 aHMgd2VpZ2h0ZWQgb3ZlciB0aGUgZXN0aW1hdGVkIG51bWJlciBvZiByb3dzLiAgRm9yClVOSU9O IGFuZCBJTlRFUlNFQ1QsIHRoZSByZWxldmFudCBwYXRocyB0byBsb29rIGF0IGFyZSAqYWxsKiBj aGlsZCBwYXRocy4KRm9yIEVYQ0VQVCwgc2luY2Ugd2UgZG9uJ3QgcmV0dXJuIHJvd3MgZnJvbSB0 aGUgcmlnaHQtaGFuZCBjaGlsZCAob25seQpwb3NzaWJseSByZW1vdmUgbGVmdC1oYW5kIHJvd3Mg bWF0Y2hpbmcgdGhvc2UpLCB3ZSB1c2Ugb25seSB0aGUgbGVmdC1oYW5kCmNoaWxkIGZvciB3aWR0 aCBlc3RpbWF0ZXMuCgpUaGlzIGFsc28gYWRqdXN0cyB0aGUgaGFzaGVkLVVOSU9OIFBhdGgncyBQ YXRoVGFyZ2V0IHRvIHVzZSB0aGUgc2FtZQpQYXRoVGFyZ2V0IGFzIGl0cyBBcHBlbmQgc3VicGF0 aC4gIEJvdGggUGF0aFRhcmdldHMgd2lsbCBiZSB0aGUgc2FtZSBhbmQKYXJlIHZvaWQgb2YgYW55 IHJlc2p1bmsgY29sdW1ucywgcGVyIGdlbmVyYXRlX2FwcGVuZF90bGlzdCgpLiAgTWFraW5nCnRo ZSBBZ2dQYXRoIHVzZSB0aGUgc2FtZSBQYXRoVGFyZ2V0IHNhdmVzIGhhdmluZyB0byBhZGp1c3Qg dGhlICJ3aWR0aCIKb2YgdGhlIEFnZ1BhdGgncyBQYXRoVGFyZ2V0IHRvby4KClRoaXMgd2FzIHJl cG9ydGVkIGFzIGEgYnVnIGJ5IHN1bncuZm5zdCwgYnV0IGl0J3Mgbm90IHNvbWV0aGluZyB3ZSBl dmVyCmNsYWltZWQgdG8gZG8gcHJvcGVybHkuICBQbHVzLCBpZiB3ZSB3ZXJlIHRvIGFkanVzdCB0 aGlzIGluIGJhY2sKYnJhbmNoZXMsIHBsYW5zIGNvdWxkIGNoYW5nZSBhcyB0aGUgZXN0aW1hdGVk IGlucHV0IHNpemVzIHRvIFNvcnRzIGFuZApIYXNoIEFnZ3JlZ2F0ZXMgY291bGQgZ28gdXAgb3Ig ZG93bi4gIFBsYW4gY2hvaWNlcyBhcmVuJ3Qgc29tZXRoaW5nIHdlCndhbnQgdG8gZGVzdGFiaWxp emUgaW4gc3RhYmxlIHZlcnNpb25zLgoKUmVwb3J0ZWQtYnk6IHN1bncuZm5zdCA8OTM2NzM5Mjc4 QHFxLmNvbT4KQXV0aG9yOiBEYXZpZCBSb3dsZXkgPGRyb3dsZXltbEBnbWFpbC5jb20+CkRpc2N1 c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vdGVuY2VudF8zNENGODAxN0FCODE5NDRBNEMwOERE MDg5RDQxMEFCNkMzMDZAcXEuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0t LS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvMmNiNDljNjA5YmQ5 YmY0NGQzMTk1OTFkZjdiZWYxZWIxMDdjYjM3NQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0t LS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3ByZXAvcHJlcHVuaW9uLmMgfCA1OSArKysrKysrKysr KysrKysrKysrKysrKysrKysrKysrLS0tCjEgZmlsZSBjaGFuZ2VkLCA1NSBpbnNlcnRpb25zKCsp LCA0IGRlbGV0aW9ucygtKQoK --===============7310660360728589448==--