Re: Why does row estimation on nested loop make no sense to me - Mailing list pgsql-general

From Tom Lane
Subject Re: Why does row estimation on nested loop make no sense to me
Date
Msg-id 26056.1368808522@sss.pgh.pa.us
Whole thread Raw
In response to Why does row estimation on nested loop make no sense to me  (Jeff Amiel <becauseimjeff@yahoo.com>)
Responses Re: Why does row estimation on nested loop make no sense to me  (Jeff Amiel <becauseimjeff@yahoo.com>)
List pgsql-general
Jeff Amiel <becauseimjeff@yahoo.com> writes:
> How can the estimated number of rows for the nested loop node EXCEED the product of the 2 row estimates of the tables
beingjoined? 
> Not only does it exceed it - but it is orders of magnitude greater.

Can you provide a self-contained test case that does this?

            regards, tom lane


pgsql-general by date:

Previous
From: Jeff Amiel
Date:
Subject: Why does row estimation on nested loop make no sense to me
Next
From: Amit Langote
Date:
Subject: Re: Why does row estimation on nested loop make no sense to me