forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commitd6d5f67
committed
Modify create_index regression test to avoid intermittent failures.
We have been seeing intermittent buildfarm failures due to a querysometimes not using an index-only scan plan, because a backgroundauto-ANALYZE prevented the table's all-visible bits from being setimmediately, thereby causing the estimated cost of an index-only scanto go up considerably. Adjust the test case so that a bitmap index scan ispreferred instead, which serves equally well for the purpose the test caseis actually meant for. (Of course, it would be better to eliminate theinterference from auto-ANALYZE, but I see no low-risk way to do that,so any such fix will have to be left for 9.3 or later.)1 parent9fa82c9 commitd6d5f67
File tree
2 files changed
+15
-13
lines changed- src/test/regress
- expected
- sql
2 files changed
+15
-13
lines changedLines changed: 12 additions & 10 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
2605 | 2605 |
| |
2606 | 2606 |
| |
2607 | 2607 |
| |
2608 |
| - | |
| 2608 | + | |
2609 | 2609 |
| |
2610 | 2610 |
| |
2611 |
| - | |
2612 |
| - | |
2613 |
| - | |
2614 |
| - | |
2615 |
| - | |
2616 |
| - | |
2617 |
| - | |
| 2611 | + | |
| 2612 | + | |
| 2613 | + | |
| 2614 | + | |
| 2615 | + | |
| 2616 | + | |
| 2617 | + | |
| 2618 | + | |
| 2619 | + | |
2618 | 2620 |
| |
2619 | 2621 |
| |
2620 |
| - | |
| 2622 | + | |
2621 | 2623 |
| |
2622 | 2624 |
| |
2623 |
| - | |
| 2625 | + | |
2624 | 2626 |
| |
2625 | 2627 |
|
Lines changed: 3 additions & 3 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
865 | 865 |
| |
866 | 866 |
| |
867 | 867 |
| |
868 |
| - | |
| 868 | + | |
869 | 869 |
| |
870 | 870 |
| |
871 | 871 |
| |
872 |
| - | |
| 872 | + | |
873 | 873 |
| |
874 |
| - | |
| 874 | + |
0 commit comments
Comments
(0)