Re: Estimation rows of FULL JOIN - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Estimation rows of FULL JOIN
Date
Msg-id 338765.1703093945@sss.pgh.pa.us
Whole thread Raw
In response to Estimation rows of FULL JOIN  (Danil Anisimow <anisimow.d@gmail.com>)
List pgsql-hackers
Danil Anisimow <anisimow.d@gmail.com> writes:
> In some cases, the planner underestimates FULL JOIN.

Perhaps.

> Are these simple changes enough to improve this situation?

This looks like an entirely ad-hoc change, one that could make as
many cases worse as it makes better.  If you want to argue for
merging it, you at least need to provide some evidence for thinking
it's a more accurate model of what will happen.  And adjust the
nearby comment to explain it.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Danil Anisimow
Date:
Subject: Estimation rows of FULL JOIN
Next
From: Daniel Gustafsson
Date:
Subject: Re: Remove MSVC scripts from the tree