• Simon Riggs's avatar
    Collect and use multi-column dependency stats · 2686ee1b
    Simon Riggs authored
    Follow on patch in the multi-variate statistics patch series.
    
    CREATE STATISTICS s1 WITH (dependencies) ON (a, b) FROM t;
    ANALYZE;
    will collect dependency stats on (a, b) and then use the measured
    dependency in subsequent query planning.
    
    Commit 7b504eb2 added
    CREATE STATISTICS with n-distinct coefficients. These are now
    specified using the mutually exclusive option WITH (ndistinct).
    
    Author: Tomas Vondra, David Rowley
    Reviewed-by: Kyotaro HORIGUCHI, Álvaro Herrera, Dean Rasheed, Robert Haas
    and many other comments and contributions
    Discussion: https://postgr.es/m/56f40b20-c464-fad2-ff39-06b668fac47c@2ndquadrant.com
    2686ee1b
cost.h 8.93 KB