diff options
| author | Tom Lane | 2003-01-27 20:51:54 +0000 |
|---|---|---|
| committer | Tom Lane | 2003-01-27 20:51:54 +0000 |
| commit | 70fba70430bd42b1a31c6d49646f9d1991eb8e7c (patch) | |
| tree | 865c11bc1262e1fd48067f9b897abf2a50653ddf /src/test | |
| parent | b2773d4099d2dbccc4d23165a093581090c49451 (diff) | |
Upgrade cost estimation for joins, per discussion with Bradley Baetz.
Try to model the effect of rescanning input tuples in mergejoins;
account for JOIN_IN short-circuiting where appropriate. Also, recognize
that mergejoin and hashjoin clauses may now be more than single operator
calls, so we have to charge appropriate execution costs.
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/subselect.out | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/src/test/regress/expected/subselect.out b/src/test/regress/expected/subselect.out index 8debffe00ba..8d7597863fc 100644 --- a/src/test/regress/expected/subselect.out +++ b/src/test/regress/expected/subselect.out @@ -58,10 +58,10 @@ SELECT '' AS six, f1 AS "Uncorrelated Field" FROM SUBSELECT_TBL six | Uncorrelated Field -----+-------------------- | 1 - | 1 - | 2 | 2 | 3 + | 1 + | 2 | 3 (6 rows) @@ -71,10 +71,10 @@ SELECT '' AS six, f1 AS "Uncorrelated Field" FROM SUBSELECT_TBL six | Uncorrelated Field -----+-------------------- | 1 - | 1 - | 2 | 2 | 3 + | 1 + | 2 | 3 (6 rows) |