Re: incorrect information in documentation

2022-04-12 Thread David G. Johnston
On Mon, Aug 9, 2021 at 8:40 PM David G. Johnston wrote: > On Mon, Aug 9, 2021 at 11:05 AM Bruce Momjian wrote: > >> >> > selectivity = (1 - null_frac1) * (1 - null_frac2) * min(1/ >> > num_distinct1, >> > 1/num_distinct2) >> > = (1 - 0) * (1 - 0) / max

Re: incorrect information in documentation

2021-08-09 Thread David G. Johnston
On Mon, Aug 9, 2021 at 11:05 AM Bruce Momjian wrote: > > > selectivity = (1 - null_frac1) * (1 - null_frac2) * min(1/ > > num_distinct1, > > 1/num_distinct2) > > = (1 - 0) * (1 - 0) / max(1, 1) > > = 0.0001 > > Nice, can you

Re: incorrect information in documentation

2021-08-09 Thread Bruce Momjian
On Mon, Aug 9, 2021 at 09:20:53AM -0700, David G. Johnston wrote: > On Mon, Aug 9, 2021 at 9:06 AM David G. Johnston > wrote: > > On Mon, Aug 9, 2021 at 8:02 AM PG Doc comments form > > wrote: > > Hello, on page > https://www.postgresql.org/docs/current/row-estimation-

Re: incorrect information in documentation

2021-08-09 Thread David G. Johnston
On Mon, Aug 9, 2021 at 9:06 AM David G. Johnston wrote: > On Mon, Aug 9, 2021 at 8:02 AM PG Doc comments form < > nore...@postgresql.org> wrote: > >> Hello, on page >> https://www.postgresql.org/docs/current/row-estimation-examples.html - >> there >> is a example: >> selectivity = (1 - null_frac1

Re: incorrect information in documentation

2021-08-09 Thread David G. Johnston
On Mon, Aug 9, 2021 at 8:02 AM PG Doc comments form 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 -