| From: | Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | tgl(at)sss(dot)pgh(dot)pa(dot)us |
| Cc: | hosoya(dot)yuzuko(at)lab(dot)ntt(dot)co(dot)jp, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Improve selectivity estimate for range queries |
| Date: | 2019-01-08 07:43:33 |
| Message-ID: | 20190108.164333.02014217.horiguchi.kyotaro@lab.ntt.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Mmm.
At Tue, 08 Jan 2019 16:26:38 +0900 (Tokyo Standard Time), Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> wrote in <20190108(dot)162638(dot)106314087(dot)horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mikael Kjellström | 2019-01-08 07:46:35 | Re: OpenBSD versus semaphores |
| Previous Message | Michael Paquier | 2019-01-08 07:42:35 | Re: [Sender Address Forgery]Re: error message when subscription target is a partitioned table |