Re: Why does the number of rows are different in actual and estimated.

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: Why does the number of rows are different in actual and estimated.
Дата
Msg-id CAGTBQpZfLp5C=qCR68UVOOrUXeSCoz_mJrkvM3+Svpahh+J4tg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why does the number of rows are different in actual and estimated.  (AI Rumman <rummandba@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
On Fri, Dec 14, 2012 at 4:01 PM, AI Rumman <rummandba@gmail.com> wrote:
> Does FK Constraint help to improve performance? Or it is only for
> maintaining data integrity?

I'm not entirely sure it's taken into account, I think it is, but a FK
would tell the planner that every non-null value will produce a row.
It seems to think there are a large portion of non-null values that
don't.

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

Предыдущее
От: AI Rumman
Дата:
Сообщение: Re: Why does the number of rows are different in actual and estimated.
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Why does the number of rows are different in actual and estimated.