Re: WIP: multivariate statistics / proof of concept - Mailing list pgsql-hackers

From Albe Laurenz
Subject Re: WIP: multivariate statistics / proof of concept
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17D73648@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to WIP: multivariate statistics / proof of concept  (Tomas Vondra <tv@fuzzy.cz>)
Responses Re: WIP: multivariate statistics / proof of concept
List 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

pgsql-hackers by date:

Previous
From: Fabrízio de Royes Mello
Date:
Subject: Re: Proposal : REINDEX SCHEMA
Next
From: Heikki Linnakangas
Date:
Subject: Re: [9.4 bug] The database server hangs with write-heavy workload on Windows