Re: Should 'sum(mvf)' read 'sum(mcv)'...?

2023-04-12 Thread Daniel Gustafsson
> On 12 Apr 2023, at 14:14, Tom Lane wrote: > > Daniel Gustafsson writes: >> I was inclined to spell it out as mcv_frequencies but we use xxx_freqs >> elsewhere on the same page so keeping it consistent seems better. The >> attached >> does this as well as adding mcf/mcv as acronyms as

Re: Should 'sum(mvf)' read 'sum(mcv)'...?

2023-04-12 Thread Tom Lane
Daniel Gustafsson writes: > I was inclined to spell it out as mcv_frequencies but we use xxx_freqs > elsewhere on the same page so keeping it consistent seems better. The > attached > does this as well as adding mcf/mcv as acronyms as previously mentioned (since > they are both tagged as ).

Re: Should 'sum(mvf)' read 'sum(mcv)'...?

2023-04-12 Thread Daniel Gustafsson
> On 22 Aug 2022, at 14:58, Tom Lane wrote: > > Julien Rouhaud writes: >> On Sun, Aug 21, 2022 at 11:02:04PM +, PG Doc comments form wrote: >>> It appears the above sentence is referring to the "(1 - sum(mvf))" portion >>> of the formula, however I am not sure what "mvf" is referring to >>>

Re: Should 'sum(mvf)' read 'sum(mcv)'...?

2022-08-22 Thread Tom Lane
Julien Rouhaud writes: > On Sun, Aug 21, 2022 at 11:02:04PM +, PG Doc comments form wrote: >> It appears the above sentence is referring to the "(1 - sum(mvf))" portion >> of the formula, however I am not sure what "mvf" is referring to >> there...shouldn't it be "(1 - sum(mcv))" in order to

Re: Should 'sum(mvf)' read 'sum(mcv)'...?

2022-08-22 Thread Daniel Gustafsson
> On 22 Aug 2022, at 12:08, Julien Rouhaud wrote: > That was actually introduced 2 years before in 234d50812c8 by Bruce. Yes, I was unclear, I meant that the second use was by Tom (whom I also missed to CC as I said I would so doing that now). -- Daniel Gustafsson

Re: Should 'sum(mvf)' read 'sum(mcv)'...?

2022-08-22 Thread Julien Rouhaud
Hi, On Mon, Aug 22, 2022 at 11:13:38AM +0200, Daniel Gustafsson wrote: > > On 22 Aug 2022, at 09:48, Julien Rouhaud wrote: > > On Sun, Aug 21, 2022 at 11:02:04PM +, PG Doc comments form wrote: > > >> It appears the above sentence is referring to the "(1 - sum(mvf))" portion > >> of the

Re: Should 'sum(mvf)' read 'sum(mcv)'...?

2022-08-22 Thread Daniel Gustafsson
> On 22 Aug 2022, at 09:48, Julien Rouhaud wrote: > On Sun, Aug 21, 2022 at 11:02:04PM +, PG Doc comments form wrote: >> It appears the above sentence is referring to the "(1 - sum(mvf))" portion >> of the formula, however I am not sure what "mvf" is referring to >> there...shouldn't it be

Re: Should 'sum(mvf)' read 'sum(mcv)'...?

2022-08-22 Thread Julien Rouhaud
Hi, On Sun, Aug 21, 2022 at 11:02:04PM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/row-estimation-examples.html > Description: > > About halfway down this page >

Should 'sum(mvf)' read 'sum(mcv)'...?

2022-08-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/row-estimation-examples.html Description: About halfway down this page https://www.postgresql.org/docs/current/row-estimation-examples.html we see the following formula for calculating