Re: Improve selectivity estimate for range queries

Поиск
Список
Период
Сортировка
От Kyotaro HORIGUCHI
Тема Re: Improve selectivity estimate for range queries
Дата
Msg-id 20190108.164333.02014217.horiguchi.kyotaro@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: Improve selectivity estimate for range queries  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
Ответы Re: Improve selectivity estimate for range queries  (Kyotaro HORIGUCHI <horiguchi.kyotaro@oss.ntt.co.jp>)
Список 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 по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [Sender Address Forgery]Re: error message when subscriptiontarget is a partitioned table
Следующее
От: Mikael Kjellström
Дата:
Сообщение: Re: OpenBSD versus semaphores