Thomas Munro writes:
> So, in that plan we saw anti-join estimate 1 row but really there were
> 13462. If you remove most of Q21 and keep just the anti-join between
> l1 and l3, then you try removing different quals, you can see the the
> problem is not the <>
On Fri, Dec 1, 2017 at 4:05 AM, Robert Haas wrote:
> On Wed, Nov 29, 2017 at 11:55 PM, Thomas Munro
> wrote:
>> Thank you for the original pointer and the commit. Everything here
>> seems to make intuitive sense and the accompanying
Ashutosh Bapat writes:
> On Fri, Jul 21, 2017 at 4:10 AM, Thomas Munro
> wrote:
>> Please find attached a new version, and a test script I used, which
>> shows a bunch of interesting cases. I'll add this to the commitfest.
> I
On Thu, Sep 14, 2017 at 2:23 PM, Ashutosh Bapat
wrote:
> Are you referring to rounding errors? We should probably add some fuzz
> factor to cover the rounding errors and cause a diff when difference
> in expected and reported plan rows is beyond that fuzz factor.