forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commit5b89ef3
committed
Add an 'enable_material' GUC.
The logic for determining whether to materialize has been significantlyoverhauled for 9.0. In case there should be any doubt about whethermaterialization is a win in any particular case, this should provide aconvenient way of seeing what happens without it; but even with enable_materialturned off, we still materialize in cases where it is required forcorrectness.Thanks to Tom Lane for the review.1 parent9287567 commit5b89ef3
File tree
8 files changed
+57
-15
lines changed- doc/src/sgml
- src
- backend
- optimizer
- path
- plan
- utils/misc
- include/optimizer
- test/regress/expected
8 files changed
+57
-15
lines changedLines changed: 17 additions & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1 |
| - | |
| 1 | + | |
2 | 2 |
| |
3 | 3 |
| |
4 | 4 |
| |
| |||
2020 | 2020 |
| |
2021 | 2021 |
| |
2022 | 2022 |
| |
| 2023 | + | |
| 2024 | + | |
| 2025 | + | |
| 2026 | + | |
| 2027 | + | |
| 2028 | + | |
| 2029 | + | |
| 2030 | + | |
| 2031 | + | |
| 2032 | + | |
| 2033 | + | |
| 2034 | + | |
| 2035 | + | |
| 2036 | + | |
| 2037 | + | |
| 2038 | + | |
2023 | 2039 |
| |
2024 | 2040 |
| |
2025 | 2041 |
| |
|
Lines changed: 15 additions & 4 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
59 | 59 |
| |
60 | 60 |
| |
61 | 61 |
| |
62 |
| - | |
| 62 | + | |
63 | 63 |
| |
64 | 64 |
| |
65 | 65 |
| |
| |||
114 | 114 |
| |
115 | 115 |
| |
116 | 116 |
| |
| 117 | + | |
117 | 118 |
| |
118 | 119 |
| |
119 | 120 |
| |
| |||
1852 | 1853 |
| |
1853 | 1854 |
| |
1854 | 1855 |
| |
1855 |
| - | |
1856 |
| - | |
| 1856 | + | |
| 1857 | + | |
| 1858 | + | |
| 1859 | + | |
| 1860 | + | |
1857 | 1861 |
| |
1858 | 1862 |
| |
1859 | 1863 |
| |
| |||
1867 | 1871 |
| |
1868 | 1872 |
| |
1869 | 1873 |
| |
| 1874 | + | |
| 1875 | + | |
| 1876 | + | |
| 1877 | + | |
1870 | 1878 |
| |
1871 | 1879 |
| |
1872 | 1880 |
| |
| |||
1878 | 1886 |
| |
1879 | 1887 |
| |
1880 | 1888 |
| |
| 1889 | + | |
| 1890 | + | |
| 1891 | + | |
1881 | 1892 |
| |
1882 |
| - | |
| 1893 | + | |
1883 | 1894 |
| |
1884 | 1895 |
| |
1885 | 1896 |
| |
|
Lines changed: 6 additions & 4 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
8 | 8 |
| |
9 | 9 |
| |
10 | 10 |
| |
11 |
| - | |
| 11 | + | |
12 | 12 |
| |
13 | 13 |
| |
14 | 14 |
| |
| |||
437 | 437 |
| |
438 | 438 |
| |
439 | 439 |
| |
440 |
| - | |
441 |
| - | |
| 440 | + | |
| 441 | + | |
| 442 | + | |
442 | 443 |
| |
443 |
| - | |
| 444 | + | |
| 445 | + | |
444 | 446 |
| |
445 | 447 |
| |
446 | 448 |
| |
|
Lines changed: 5 additions & 3 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
7 | 7 |
| |
8 | 8 |
| |
9 | 9 |
| |
10 |
| - | |
| 10 | + | |
11 | 11 |
| |
12 | 12 |
| |
13 | 13 |
| |
| |||
578 | 578 |
| |
579 | 579 |
| |
580 | 580 |
| |
581 |
| - | |
| 581 | + | |
| 582 | + | |
| 583 | + | |
582 | 584 |
| |
583 |
| - | |
| 585 | + | |
584 | 586 |
| |
585 | 587 |
| |
586 | 588 |
| |
|
Lines changed: 9 additions & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
10 | 10 |
| |
11 | 11 |
| |
12 | 12 |
| |
13 |
| - | |
| 13 | + | |
14 | 14 |
| |
15 | 15 |
| |
16 | 16 |
| |
| |||
643 | 643 |
| |
644 | 644 |
| |
645 | 645 |
| |
| 646 | + | |
| 647 | + | |
| 648 | + | |
| 649 | + | |
| 650 | + | |
| 651 | + | |
| 652 | + | |
| 653 | + | |
646 | 654 |
| |
647 | 655 |
| |
648 | 656 |
| |
|
Lines changed: 1 addition & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
206 | 206 |
| |
207 | 207 |
| |
208 | 208 |
| |
| 209 | + | |
209 | 210 |
| |
210 | 211 |
| |
211 | 212 |
| |
|
Lines changed: 2 additions & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
7 | 7 |
| |
8 | 8 |
| |
9 | 9 |
| |
10 |
| - | |
| 10 | + | |
11 | 11 |
| |
12 | 12 |
| |
13 | 13 |
| |
| |||
57 | 57 |
| |
58 | 58 |
| |
59 | 59 |
| |
| 60 | + | |
60 | 61 |
| |
61 | 62 |
| |
62 | 63 |
| |
|
Lines changed: 2 additions & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
5 | 5 |
| |
6 | 6 |
| |
7 | 7 |
| |
| 8 | + | |
8 | 9 |
| |
9 | 10 |
| |
10 | 11 |
| |
11 | 12 |
| |
12 | 13 |
| |
13 |
| - | |
| 14 | + | |
14 | 15 |
| |
15 | 16 |
| |
16 | 17 |
| |
|
0 commit comments
Comments
(0)