Re: incorrect information in documentation

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: incorrect information in documentation
Дата
Msg-id CAKFQuwYQacXmG9zMcOgbBtGp-1QusGjXQBfMez9GcHpv=AX6SQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: incorrect information in documentation  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: incorrect information in documentation  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-docs
On Mon, Aug 9, 2021 at 9:06 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Mon, Aug 9, 2021 at 8:02 AM PG Doc comments form <noreply@postgresql.org> wrote:
Hello, on page
https://www.postgresql.org/docs/current/row-estimation-examples.html - there
is a example:
selectivity = (1 - null_frac1) * (1 - null_frac2) * min(1/num_distinct1,
1/num_distinct2)
            = (1 - 0) * (1 - 0) / max(10000, 10000)
            = 0.0001
in the first string  " * min" and in the second " / max"
as I understand it isn't correct.

Division is just multiplication by the reciprocal so while the presentation here is inconsistent it is correct.  Likewise, the larger a number the smaller its reciprocal, so the change from min to max also works.  


FWIW this used to be presented with the calculation and formula in sync, but the original had a simple typo in the calculation.  When the typo got fixed back in December of 2007 [1] the author of the patch simplified the calculation at the same time.  I suggest we update the formula line to match the calculation presented.

David J.


В списке pgsql-docs по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: incorrect information in documentation
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: incorrect information in documentation