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 1sW4QZ-00D6TO-4f for pgsql-committers@arkaria.postgresql.org; Tue, 23 Jul 2024 01:34:55 +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 1sW4QX-008jck-8S for pgsql-committers@arkaria.postgresql.org; Tue, 23 Jul 2024 01:34:53 +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 1sW4QW-008jcc-VV for pgsql-committers@lists.postgresql.org; Tue, 23 Jul 2024 01:34: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.94.2) (envelope-from ) id 1sW4QU-000ykf-Hv for pgsql-committers@lists.postgresql.org; Tue, 23 Jul 2024 01:34: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=14xo5Tn7gidC0MH31ipe3MdQhf1rS3j4ICPXH7qUHXA=; b=lmhByyrXNhqpBplrPeoPdSLvnS jJor/up25xU+0eGUhgxCqDKTVaMC/FP14R+M8mif/AHsq/ggHkO+y90lW0W0aZ3EpfpBPIqhRfzBF 1pR8OTYWcyIRMaG8t9ayWMHGDoTZheyjd1G903USgPGIAbJ6an6IYqD5Gr/Hs/5Mo6gq4nttTIp5K YZF0sfn+RJOvOQhVES/E4CwxrHm2np9GvBCyBwAKmdF8xa3HdEK78SMwnAd7T/tFD+IoWSnj+3YJ5 K0r9cfLFts4PTWpSi+EfyxNs8tDAB+asnAsoZLxTm3xMv6rLpuPV5/zE8EFmHX8wOeEHs/CKcQZ7n y33IVIwg==; 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 1sW4QT-0035QB-29 for pgsql-committers@lists.postgresql.org; Tue, 23 Jul 2024 01:34:49 +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 1sW4QR-000mln-Ua for pgsql-committers@lists.postgresql.org; Tue, 23 Jul 2024 01:34:47 +0000 Content-Type: multipart/mixed; boundary="===============7170532692891008969==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix rowcount estimate for gather (merge) paths X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 23 Jul 2024 01:34:47 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7170532692891008969== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHJvd2NvdW50IGVzdGltYXRlIGZvciBnYXRoZXIgKG1lcmdlKSBwYXRocwoKSW4gdGhlIGNh c2Ugb2YgYSBwYXJhbGxlbCBwbGFuLCB3aGVuIGNvbXB1dGluZyB0aGUgbnVtYmVyIG9mIHR1cGxl cwpwcm9jZXNzZWQgcGVyIHdvcmtlciwgd2UgZGl2aWRlIHRoZSB0b3RhbCBudW1iZXIgb2YgdHVw bGVzIGJ5IHRoZQpwYXJhbGxlbF9kaXZpc29yIG9idGFpbmVkIGZyb20gZ2V0X3BhcmFsbGVsX2Rp dmlzb3IoKSwgd2hpY2ggYWNjb3VudHMKZm9yIHRoZSBsZWFkZXIncyBjb250cmlidXRpb24gaW4g YWRkaXRpb24gdG8gdGhlIG51bWJlciBvZiB3b3JrZXJzLgoKQWNjb3JkaW5nbHksIHdoZW4gZXN0 aW1hdGluZyB0aGUgbnVtYmVyIG9mIHR1cGxlcyBmb3IgZ2F0aGVyIChtZXJnZSkKbm9kZXMsIHdl IHNob3VsZCBtdWx0aXBseSB0aGUgbnVtYmVyIG9mIHR1cGxlcyBwZXIgd29ya2VyIGJ5IHRoZSBz YW1lCnBhcmFsbGVsX2Rpdmlzb3IgdG8gcmV2ZXJzZSB0aGUgZGl2aXNpb24uICBIb3dldmVyLCBj dXJyZW50bHkgd2UgdXNlCnBhcmFsbGVsX3dvcmtlcnMgcmF0aGVyIHRoYW4gcGFyYWxsZWxfZGl2 aXNvciBmb3IgdGhlIG11bHRpcGxpY2F0aW9uLgpUaGlzIGNvdWxkIHJlc3VsdCBpbiBhbiB1bmRl cmVzdGltYXRpb24gb2YgdGhlIG51bWJlciBvZiB0dXBsZXMgZm9yCmdhdGhlciAobWVyZ2UpIG5v ZGVzLCBlc3BlY2lhbGx5IHdoZW4gdGhlcmUgYXJlIGZld2VyIHRoYW4gZm91cgp3b3JrZXJzLgoK VGhpcyBwYXRjaCBmaXhlcyB0aGlzIGlzc3VlIGJ5IHVzaW5nIHRoZSBzYW1lIHBhcmFsbGVsX2Rp dmlzb3IgZm9yIHRoZQptdWx0aXBsaWNhdGlvbi4gIFRoZXJlIGlzIG9uZSBlbnN1aW5nIHBsYW4g Y2hhbmdlIGluIHRoZSByZWdyZXNzaW9uCnRlc3RzLCBidXQgaXQgbG9va3MgcmVhc29uYWJsZSBh bmQgZG9lcyBub3QgY29tcHJvbWlzZSBpdHMgb3JpZ2luYWwKcHVycG9zZSBvZiB0ZXN0aW5nIHBh cmFsbGVsLWF3YXJlIGhhc2ggam9pbi4KCkluIHBhc3NpbmcsIHRoaXMgcGF0Y2ggcmVtb3ZlcyBh biB1bm5lY2Vzc2FyeSBhc3NpZ25tZW50IGZvciBwYXRoLnJvd3MKaW4gY3JlYXRlX2dhdGhlcl9t ZXJnZV9wYXRoLCBhbmQgZml4ZXMgYW4gdW5pbml0aWFsaXplZC12YXJpYWJsZSBpc3N1ZQppbiBn ZW5lcmF0ZV91c2VmdWxfZ2F0aGVyX3BhdGhzLgoKTm8gYmFja3BhdGNoIGFzIHRoaXMgY291bGQg cmVzdWx0IGluIHBsYW4gY2hhbmdlcy4KCkF1dGhvcjogQW50aG9uaW4gQm9ubmVmb3kKUmV2aWV3 ZWQtYnk6IFJhZmlhIFNhYmloLCBSaWNoYXJkIEd1bwpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rn ci5lcy9tL0NBTzZfWHFyOSs1MU54Z089WG9zcEVrVWVBZy1wPUVqQVdtdHBkY1p3alJnR0tKNTNp QUBtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpo dHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzU4MWRmMjE0ODczN2ZkYjBi YTZmMmQ4ZmRhNWNlYjlkMWU2MzAyZTYKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNy Yy9iYWNrZW5kL29wdGltaXplci9wYXRoL2FsbHBhdGhzLmMgICB8ICA3ICsrKy0tLS0Kc3JjL2Jh Y2tlbmQvb3B0aW1pemVyL3BhdGgvY29zdHNpemUuYyAgIHwgMTggKysrKysrKysrKysrKysrKysr CnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3BsYW5uZXIuYyAgICB8ICA3ICsrLS0tLS0Kc3Jj L2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvcGF0aG5vZGUuYyAgIHwgIDEgLQpzcmMvaW5jbHVkZS9v cHRpbWl6ZXIvY29zdC5oICAgICAgICAgICAgfCAgMSArCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0 ZWQvam9pbl9oYXNoLm91dCB8IDE5ICsrKysrKysrKy0tLS0tLS0tLS0KNiBmaWxlcyBjaGFuZ2Vk LCAzMyBpbnNlcnRpb25zKCspLCAyMCBkZWxldGlvbnMoLSkKCg== --===============7170532692891008969==--