diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/stats.out | 5 | ||||
| -rw-r--r-- | src/test/regress/sql/stats.sql | 6 |
2 files changed, 11 insertions, 0 deletions
diff --git a/src/test/regress/expected/stats.out b/src/test/regress/expected/stats.out index 00811e2145f..56bace1187b 100644 --- a/src/test/regress/expected/stats.out +++ b/src/test/regress/expected/stats.out @@ -11,6 +11,11 @@ SHOW track_counts; -- must be on on (1 row) +-- ensure that both seqscan and indexscan plans are allowed +SET enable_seqscan TO on; +SET enable_indexscan TO on; +-- for the moment, we don't want index-only scans here +SET enable_indexonlyscan TO off; -- wait to let any prior tests finish dumping out stats; -- else our messages might get lost due to contention SELECT pg_sleep(2.0); diff --git a/src/test/regress/sql/stats.sql b/src/test/regress/sql/stats.sql index 4a72a949f29..bb349b2dfa6 100644 --- a/src/test/regress/sql/stats.sql +++ b/src/test/regress/sql/stats.sql @@ -8,6 +8,12 @@ -- conditio sine qua non SHOW track_counts; -- must be on +-- ensure that both seqscan and indexscan plans are allowed +SET enable_seqscan TO on; +SET enable_indexscan TO on; +-- for the moment, we don't want index-only scans here +SET enable_indexonlyscan TO off; + -- wait to let any prior tests finish dumping out stats; -- else our messages might get lost due to contention SELECT pg_sleep(2.0); |