On Wed, Feb 16, 2011 at 4:22 PM, Bruce Momjian <bruce@xxxxxxxxxx> wrote: > I am not excited about the idea of putting these correlations in > queries. What would be more intesting would be for analyze to build a > correlation coeffficent matrix showing how columns are correlated: > > a b c > a 1 .4 0 > b .1 1 -.3 > c .2 .3 1 > > and those correlations could be used to weigh how the single-column > statistics should be combined. If you can make it work, I'll take it... it's (much) easier said than done, though. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
