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.
Дата
Msg-id 20121214191427.80090@gmx.com
обсуждение исходный текст
Ответы Re: Why does the number of rows are different in actual and estimated.
Список pgsql-performance
Дерево обсуждения 
AI Rumman wrote:
> Claudio Freire <klaussfreire@gmail.com>wrote:
>> I think it's more likely a missing FK constraint.

> Does FK Constraint help to improve performance? Or it is only
> for maintaining data integrity?

I'm not aware of any situation where adding a foreign key
constraint would improve performance.

-Kevin

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

Предыдущее
От: Claudio Freire
Дата:
Сообщение: Re: Why does the number of rows are different in actual and estimated.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Why does the number of rows are different in actual and estimated.