diff options
| author | Tom Lane | 2005-01-28 20:34:27 +0000 |
|---|---|---|
| committer | Tom Lane | 2005-01-28 20:34:27 +0000 |
| commit | 875b0c62fabeafd65136ad5d6825274f983b8e88 (patch) | |
| tree | 680fd5be04cdea754b90c7c21a7284621498b44b /src/test | |
| parent | 0bf2587df46f3b554d62f7628d1d474bda7ddfc5 (diff) | |
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.
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/subselect.out | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/subselect.out b/src/test/regress/expected/subselect.out index 07e727de482..56bea035981 100644 --- a/src/test/regress/expected/subselect.out +++ b/src/test/regress/expected/subselect.out @@ -134,11 +134,11 @@ SELECT '' AS five, f1 AS "Correlated Field" WHERE f3 IS NOT NULL); five | Correlated Field ------+------------------ - | 2 | 3 | 1 - | 2 | 3 + | 2 + | 2 (5 rows) -- |