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 20190108.164333.02014217.horiguchi.kyotaro@lab.ntt.co.jp
Whole thread Raw
In response to Re: Improve selectivity estimate for range queries  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
Responses Re: Improve selectivity estimate for range queries  (Kyotaro HORIGUCHI <horiguchi.kyotaro@oss.ntt.co.jp>)
List pgsql-hackers
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: Michael Paquier
Date:
Subject: Re: [Sender Address Forgery]Re: error message when subscriptiontarget is a partitioned table
Next
From: Mikael Kjellström
Date:
Subject: Re: OpenBSD versus semaphores