Re: WIP: multivariate statistics / proof of concept

Albe Laurenz <laurenz.albe@wien.gv.at>

From: Albe Laurenz <laurenz.albe@wien.gv.at>

To: "Tomas Vondra *EXTERN*" <tv@fuzzy.cz>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2014-10-13T07:36:19Z

Lists: pgsql-hackers

Tomas Vondra wrote:
> attached is a WIP patch implementing multivariate statistics.

I think that is pretty useful.
Oracle has an identical feature called "extended statistics".

That's probably an entirely different thing, but it would be very
nice to have statistics to estimate the correlation between columns
of different tables, to improve the estimate for the number of rows
in a join.

Yours,
Laurenz Albe

Commits

Collect and use multi-column dependency stats
- 2686ee1b7ccf 10.0 landed
Implement SortSupport for macaddr data type
- f90d23d0c518 10.0 cited
Implement multivariate n-distinct coefficients
- 7b504eb282ca 10.0 landed
Generate fmgr prototypes automatically
- 352a24a1f9d6 10.0 cited