• Tomas Vondra's avatar
    Allow setting statistics target for extended statistics · d06215d0
    Tomas Vondra authored
    When building statistics, we need to decide how many rows to sample and
    how accurate the resulting statistics should be. Until now, it was not
    possible to explicitly define statistics target for extended statistics
    objects, the value was always computed from the per-attribute targets
    with a fallback to the system-wide default statistics target.
    
    That's a bit inconvenient, as it ties together the statistics target set
    for per-column and extended statistics. In some cases it may be useful
    to require larger sample / higher accuracy for extended statics (or the
    other way around), but with this approach that's not possible.
    
    So this commit introduces a new command, allowing to specify statistics
    target for individual extended statistics objects, overriding the value
    derived from per-attribute targets (and the system default).
    
      ALTER STATISTICS stat_name SET STATISTICS target_value;
    
    When determining statistics target for an extended statistics object we
    first look at this explicitly set value. When this value is -1, we fall
    back to the old formula, looking at the per-attribute targets first and
    then the system default. This means the behavior is backwards compatible
    with older PostgreSQL releases.
    
    Author: Tomas Vondra
    Discussion: https://postgr.es/m/20190618213357.vli3i23vpkset2xd@development
    Reviewed-by: Kirk Jamison, Dean Rasheed
    d06215d0
pg_statistic_ext.h 2.11 KB