On Sun, Feb 13, 2011 at 10:49 PM, Josh Berkus <j...@agliodbs.com> wrote: > >> I fail to see how 1 through 3 can tell the planner the correlation >> between two fields in two separate tables. > > CREATE CORRELATION_ESTIMATE ( table1.colA ) = ( table2.colB ) IS 0.3 > > ... and then it fixes the correlation for *every* query in the database, not > just that one. And is easy to fix if the correlation changes.
I like that. Even better, could we setup some kind of simple command to tell analyze to collect stats for the two columns together? -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
