On May 29, 2019, at 1:36 PM, Robert Haas wrote:
> Well, it's all there in the code. I believe the issue is that the
> final estimates are based on the number of rows that will be returned
> from the relation, which is often less, and occasionally more, than
> the total of the rows in the relation
On Sun, May 26, 2019 at 1:00 PM Donald Dong wrote:
> I noticed the estimated rows of the base relations during the join
> searching is *very* different from the estimations in the final plan.
>
> Join search (rows of the initial_rels):
> RELOPTINFO (ct): rows=1 width=4
> RELOPTINFO (it): rows=1 wi
Hi,
I noticed the estimated rows of the base relations during the join
searching is *very* different from the estimations in the final plan.
Join search (rows of the initial_rels):
RELOPTINFO (ct): rows=1 width=4
RELOPTINFO (it): rows=1 width=4
RELOPTINFO (mc): rows=17567 width=32
RELOPTINFO (mi_
