Re: Improve selectivity estimate for range queries - Mailing list pgsql-hackers

From Kyotaro HORIGUCHI
Subject Re: Improve selectivity estimate for range queries
Date
Msg-id CAM103Dtnr-eBJWuxP4L5xh+rDq55SzR3LndOZyuEs9-L6_W3TA@mail.gmail.com
Whole thread Raw
In response to Re: Improve selectivity estimate for range queries  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
List pgsql-hackers
Sigh.. In the frrst place, the loop should not stop until the maximum exponent.
sorry, but I don't have a time now..

2019年1月8日(火) 16:43 Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>:
Mmm.

At Tue, 08 Jan 2019 16:26:38 +0900 (Tokyo Standard Time), Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp> wrote in <20190108.162638.106314087.horiguchi.kyotaro@lab.ntt.co.jp>
> FWIW, I got the following result on my environment. It seems
> different enough if this holds on all supported platforms, though
> there still is a case where the result of a sequence of
> arithmetics makes false match.
>
> x = 0.33333333333333331
>    d = 1.000000e+30 match
>    d = 1.000000e+31: 0.000000 match

Of course the "match" in the last line above is a mistake of "NOT
match".
--
Kyotaro Horiguchi
NTT Open Source Software Center


pgsql-hackers by date:

Previous
From: Padam Chopra
Date:
Subject: Mentoring for GCI-19
Next
From: Haribabu Kommi
Date:
Subject: Re: Displaying and dumping of table access methods