Re: proposal : cross-column stats - Mailing list pgsql-hackers

From Tom Lane
Subject Re: proposal : cross-column stats
Date
Msg-id 6282.1292621049@sss.pgh.pa.us
Whole thread Raw
In response to Re: proposal : cross-column stats  (Tomas Vondra <tv@fuzzy.cz>)
Responses Re: proposal : cross-column stats  (Tomas Vondra <tv@fuzzy.cz>)
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ps_status on fastpath
Next
From: Heikki Linnakangas
Date:
Subject: Re: proposal : cross-column stats