Re: Improve selectivity estimate for range queries

From: Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)oss(dot)ntt(dot)co(dot)jp>
To: Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
Cc: hosoya(dot)yuzuko(at)lab(dot)ntt(dot)co(dot)jp, pgsql-hackers(at)lists(dot)postgresql(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: Re: Improve selectivity estimate for range queries
Date: 2019-01-08 08:01:23
Message-ID: CAM103Dtnr-eBJWuxP4L5xh+rDq55SzR3LndOZyuEs9-L6_W3TA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>:

> 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
>
>
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Haribabu Kommi 2019-01-08 08:09:12 Re: Displaying and dumping of table access methods
Previous Message Padam Chopra 2019-01-08 07:59:00 Mentoring for GCI-19