Horton

Re: 7.4 - FK constraint performance

ow <oneway_111@yahoo.com>

View thread View on postgr.es
From: ow <oneway_111@yahoo.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Date: 2004-02-13T00:25:48Z
Lists: pgsql-hackers, pgsql-sql 
--- 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