Re: Estimates not taking null_frac element into account with @@ operator? (8.4 .. git-head)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Estimates not taking null_frac element into account with @@ operator? (8.4 .. git-head)
Дата
Msg-id 8108.1297981248@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Estimates not taking null_frac element into account with @@ operator? (8.4 .. git-head)  (Jesper Krogh <jesper@krogh.cc>)
Ответы Re: Estimates not taking null_frac element into account with @@ operator? (8.4 .. git-head)  (Jesper Krogh <jesper@krogh.cc>)
Список pgsql-hackers
Jesper Krogh <jesper@krogh.cc> writes:
> When something evaluates to "null" isn't included in the result, 
> shouldn't the query-planner
> then take the null_frac into account when computing the estimate?

The proposed patch seems wrong to me: if we're estimating on the basis
of most-common-value fractions, the null_frac is already accounted for,
because it's not part of the MCV selectivity fractions.  IOW, aren't you
double-counting the null fraction?
        regards, tom lane


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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: SSI bug?
Следующее
От: Jesper Krogh
Дата:
Сообщение: Re: Estimates not taking null_frac element into account with @@ operator? (8.4 .. git-head)