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
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-
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
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 -
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/row-estimation-examples.html
Description:
Hello, on page
https://www.postgresql.org/docs/current/row-estimation-examples.html - there
is a example:
selectivity = (1 - null_frac1) * (1 - nu
