Re: 7.4 - FK constraint performance

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Well, there's the smoking gun all right.  Why does it think there are
> going to be 7893843 matching rows!?  Could we see the pg_stats row for
> the large.small_id column?
> 
>             regards, tom lane

schemaname    tablename    attname    null_frac    avg_width    n_distinct    most_common_vals
most_common_freqs    histogram_bounds    correlation
my    large    small_id    0    4    10    {7,3,5,1,4,2,8,10,6,9}
{0.108667,0.105,0.104333,0.101333,0.100667,0.0983333,0.0983333,0.0983333,0.094,0.091}0.0597573




__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html