]> granicus.if.org Git - postgresql/commit
When dealing with multiple grouping columns coming from the same table,
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 28 Jan 2005 20:34:27 +0000 (20:34 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 28 Jan 2005 20:34:27 +0000 (20:34 +0000)
commit875b0c62fabeafd65136ad5d6825274f983b8e88
tree680fd5be04cdea754b90c7c21a7284621498b44b
parent0bf2587df46f3b554d62f7628d1d474bda7ddfc5
When dealing with multiple grouping columns coming from the same table,
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.
src/backend/utils/adt/selfuncs.c
src/test/regress/expected/subselect.out