On Tue, Mar 3, 2009 at 3:33 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > > Because it would be the wrong answer, except in the uncommon case where > the field values are completely independent (at least, I would expect > that to be uncommon when people have multicolumn indexes on them).
Actually I think it's *more* likely to be true for multicolumn indexes. If the two columns were correlated then you wouldn't need the multicolumn index since you could just use one of the columns alone. The case where people create multicolumn indexes btree indexes is usually when they have a "major"-"minor" relationship between the two columns so for each value of the major key there is a whole range of minor keys. Sure multi-column statistics would be nice though. -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
