Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nmJzg-0004VT-Ut for pgsql-committers@arkaria.postgresql.org; Wed, 04 May 2022 18:45:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nmJzf-0007M2-JZ for pgsql-committers@arkaria.postgresql.org; Wed, 04 May 2022 18:44:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nmJzf-0007Lt-CJ for pgsql-committers@lists.postgresql.org; Wed, 04 May 2022 18:44:59 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nmJzc-0006QW-NH for pgsql-committers@lists.postgresql.org; Wed, 04 May 2022 18:44:58 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nmJzc-00024p-5N for pgsql-committers@lists.postgresql.org; Wed, 04 May 2022 18:44:56 +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 1nmJzb-002XkJ-7d for pgsql-committers@lists.postgresql.org; Wed, 04 May 2022 18:44:55 +0000 Content-Type: multipart/mixed; boundary="===============7577896968937346535==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix rowcount estimate for SubqueryScan that's under a Gather. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 04 May 2022 18:44:55 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7577896968937346535== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHJvd2NvdW50IGVzdGltYXRlIGZvciBTdWJxdWVyeVNjYW4gdGhhdCdzIHVuZGVyIGEgR2F0 aGVyLgoKU3VicXVlcnlTY2FuIHdhcyBhbHdheXMgZ2V0dGluZyBsYWJlbGVkIHdpdGggYSByb3dj b3VudCBlc3RpbWF0ZQphcHByb3ByaWF0ZSBmb3Igbm9uLXBhcmFsbGVsIGNhc2VzLiAgSG93ZXZl ciwgbm9kZXMgdGhhdCBhcmUKdW5kZXJuZWF0aCBhIEdhdGhlciBzaG91bGQgYmUgdHJlYXRlZCBh cyBwcm9jZXNzaW5nIG9ubHkgb25lCndvcmtlcidzIHNoYXJlIG9mIHRoZSByb3dzLCB3aGV0aGVy IHRoZSBwYXJ0aWN1bGFyIG5vZGUgaXMgZXhwbGljaXRseQpwYXJhbGxlbC1hd2FyZSBvciBub3Qu ICBNb3N0IG5vbi1zY2FuLWxldmVsIG5vZGUgdHlwZXMgZ2V0IHRoaXMKcmlnaHQgYXV0b21hdGlj YWxseSBiZWNhdXNlIHRoZXkgYmFzZSB0aGVpciByb3djb3VudCBlc3RpbWF0ZSBvbgp0aGF0IG9m IHRoZWlyIGlucHV0IHN1Yi1QYXRoKHMpLiAgQnV0IFN1YnF1ZXJ5U2NhbiBkaWRuJ3QgZG8gdGhh dCwKaW5zdGVhZCB1c2luZyB0aGUgd2hvbGUtcmVsYXRpb24gcm93Y291bnQgZXN0aW1hdGUgYXMg aWYgaXQgd2VyZQphIG5vbi1wYXJhbGxlbC1hd2FyZSBzY2FuIG5vZGUuICBJZiB0aGVyZSBpcyBh IHBhcmFsbGVsLWF3YXJlIG5vZGUKYmVsb3cgdGhlIFN1YnF1ZXJ5U2NhbiwgdGhpcyBpcyB3cm9u ZywgYW5kIGl0IHJlc3VsdHMgaW4gaW5mbGF0aW5nCnRoZSBjb3N0IGVzdGltYXRlcyBmb3Igbm9k ZXMgYWJvdmUgdGhlIFN1YnF1ZXJ5U2Nhbiwgd2hpY2ggY2FuIGNhdXNlCnVzIHRvIG5vdCBjaG9v c2UgYSBwYXJhbGxlbCBwbGFuLCBvciBjaG9vc2UgYSBzaWxseSBvbmUgLS0tIGFzIGluZGVlZApp cyB2aXNpYmxlIGluIHRoZSBvbmUgcmVncmVzc2lvbiB0ZXN0IHdob3NlIHJlc3VsdHMgY2hhbmdl IHdpdGggdGhpcwpwYXRjaC4gIChBbHRob3VnaCB0aGF0IHBsYW4gdHJlZSBhcHBlYXJzIHRvIGNv bnRhaW4gbm8gU3VicXVlcnlTY2FucywKdGhlcmUgd2VyZSBzb21lIGluIGl0IGJlZm9yZSBzZXRy ZWZzLmMgZGVsZXRlZCB0aGVtLikKClRvIGZpeCwgdXNlIHBhdGgtPnN1YnBhdGgtPnJvd3Mgbm90 IGJhc2VyZWwtPnR1cGxlcyBhcyB0aGUgbnVtYmVyCm9mIGlucHV0IHR1cGxlcyB3ZSdsbCBwcm9j ZXNzLiAgVGhpcyByZXF1aXJlcyBlc3RpbWF0aW5nIHRoZSBxdWFscycKc2VsZWN0aXZpdHkgYWZy ZXNoLCB3aGljaCBpcyBzbGlnaHRseSBhbm5veWluZzsgYnV0IGl0IHNob3VsZG4ndApyZWFsbHkg YWRkIG11Y2ggY29zdCB0aGFua3MgdG8gdGhlIGNhY2hpbmcgZG9uZSBpbiBSZXN0cmljdEluZm8u CgpUaGlzIGlzIHByZXR0eSBjbGVhcmx5IGEgYnVnIGZpeCwgYnV0IEknbGwgcmVmcmFpbiBmcm9t IGJhY2stcGF0Y2hpbmcKYXMgcGVvcGxlIG1pZ2h0IG5vdCBhcHByZWNpYXRlIHBsYW4gY2hvaWNl cyBjaGFuZ2luZyBpbiBzdGFibGUgYnJhbmNoZXMuClRoZSBmYWN0IHRoYXQgaXQgdG9vayB1cyB0 aGlzIGxvbmcgdG8gaWRlbnRpZnkgdGhlIGJ1ZyBzdWdnZXN0cyB0aGF0Cml0J3Mgbm90IGEgbWFq b3IgcHJvYmxlbS4KClBlciByZXBvcnQgZnJvbSBidWNvbywgdGhvdWdoIHRoaXMgaXMgbm90IGhp cyBwcm9wb3NlZCBwYXRjaC4KCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMjAyMjA0 MTIxNDU3MTU5MzA3MjQ4QHNvaHUuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwot LS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvYzQwYmE1ZjMx OGY5NmE2YTVhMjk3MjliOTg3ZWFkMTFjNWRjNjVjMQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0t LS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvY29zdHNpemUuYyAgICAgICAgICB8IDIy ICsrKysrKysrKysrKysrKysrKy0tLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9pbmNyZW1l bnRhbF9zb3J0Lm91dCB8IDEwICsrKystLS0tLS0KMiBmaWxlcyBjaGFuZ2VkLCAyMiBpbnNlcnRp b25zKCspLCAxMCBkZWxldGlvbnMoLSkKCg== --===============7577896968937346535==--