]> 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:35:14 +0000 (20:35 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 28 Jan 2005 20:35:14 +0000 (20:35 +0000)
commit7c67dcacd83c885618a58936df627a17470d9991
tree759f3d24900f14b55cd260b5ef8bddc8fa22df2b
parenta098f533d15efe5552c0b6cd661cc123231c8c54
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