Postgres Pro
Downloads
Home   >   mailing lists

Re: Why does the number of rows are different in actual and estimated. - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Why does the number of rows are different in actual and estimated.
Date
Msg-id 20121214191427.80090@gmx.com
Whole thread Raw
Responses Re: Why does the number of rows are different in actual and estimated.
List pgsql-performance
Tree view 
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 by date:

Previous
From: Claudio Freire
Date:
Subject: Re: Why does the number of rows are different in actual and estimated.
Next
From: Tom Lane
Date:
Subject: Re: Why does the number of rows are different in actual and estimated.