Skip to content
Snippets Groups Projects
  • Tom Lane's avatar
    875b0c62
    When dealing with multiple grouping columns coming from the same table, · 875b0c62
    Tom Lane authored
    clamp the estimated number of groups to table row count over 10, instead
    of table row count; this reflects a heuristic that people probably won't
    group over a near-unique set of columns, and the knowledge that we don't
    currently have any way to estimate the correlation of the columns better
    than guessing.  This change creates a trivial plan change in one of the
    regression tests.
    875b0c62
    History
    When dealing with multiple grouping columns coming from the same table,
    Tom Lane authored
    clamp the estimated number of groups to table row count over 10, instead
    of table row count; this reflects a heuristic that people probably won't
    group over a near-unique set of columns, and the knowledge that we don't
    currently have any way to estimate the correlation of the columns better
    than guessing.  This change creates a trivial plan change in one of the
    regression tests.