Re: proposal : cross-column stats
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tomas Vondra <tv@fuzzy.cz>
Cc: pgsql-hackers@postgresql.org
Date: 2010-12-17T21:24:09Z
Lists: pgsql-hackers
Tomas Vondra <tv@fuzzy.cz> writes: > AFAIK it will work with reasonably precise estimates, but the point is > you need an estimate of distinct values of the whole group of columns. > So when you want to get an estimate for queries on columns (a,b), you > need the number of distinct value combinations of these two columns. That seems likely to be even more unreliable than our existing single-column estimates :-( regards, tom lane