diff options
| author | Bruce Momjian | 2013-10-08 16:12:24 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2013-10-08 16:12:24 +0000 |
| commit | ee1e5662d8d8330726eaef7d3110cb7add24d058 (patch) | |
| tree | 07afa37af6d1043d9c16fb4961150b7a3477a18f /src/test | |
| parent | d29a03192615b55593af4a89283f5b5c72f13afe (diff) | |
Auto-tune effective_cache size to be 4x shared buffers
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/join.out | 1 | ||||
| -rw-r--r-- | src/test/regress/sql/join.sql | 2 |
2 files changed, 3 insertions, 0 deletions
diff --git a/src/test/regress/expected/join.out b/src/test/regress/expected/join.out index c94ac614af8..d46ff26d82b 100644 --- a/src/test/regress/expected/join.out +++ b/src/test/regress/expected/join.out @@ -2713,6 +2713,7 @@ where thousand = (q1 + q2); -- -- test placement of movable quals in a parameterized join tree -- +set effective_cache_size = '128MB'; explain (costs off) select * from tenk1 t1 left join (tenk1 t2 join tenk1 t3 on t2.thousand = t3.unique2) diff --git a/src/test/regress/sql/join.sql b/src/test/regress/sql/join.sql index 351400f2da2..1a4dc03d18b 100644 --- a/src/test/regress/sql/join.sql +++ b/src/test/regress/sql/join.sql @@ -711,6 +711,8 @@ where thousand = (q1 + q2); -- test placement of movable quals in a parameterized join tree -- +set effective_cache_size = '128MB'; + explain (costs off) select * from tenk1 t1 left join (tenk1 t2 join tenk1 t3 on t2.thousand = t3.unique2) |