- Notifications
You must be signed in to change notification settings - Fork5
Commit3bf3ab8
committed
Add a materialized view relations.
A materialized view has a rule just like a view and a heap andother physical properties like a table. The rule is only used topopulate the table, references in queries refer to thematerialized data.This is a minimal implementation, but should still be useful inmany cases. Currently data is only populated "on demand" by theCREATE MATERIALIZED VIEW and REFRESH MATERIALIZED VIEW statements.It is expected that future releases will add incremental updateswith various timings, and that a more refined concept of definingwhat is "fresh" data will be developed. At some point it may evenbe possible to have queries use a materialized in place ofreferences to underlying tables, but that requires the otherabove-mentioned features to be working first.Much of the documentation work by Robert Haas.Review by Noah Misch, Thom Brown, Robert Haas, Marko TiikkajaSecurity review by KaiGai Kohei, with a decision on how best toimplement sepgsql still pending.1 parentb15a6da commit3bf3ab8
File tree
103 files changed
+4240
-438
lines changed- contrib
- oid2name
- pg_upgrade
- pgstattuple
- vacuumlo
- doc/src/sgml
- ref
- src
- backend
- access
- common
- heap
- catalog
- commands
- executor
- nodes
- optimizer
- plan
- util
- parser
- postmaster
- rewrite
- storage/lmgr
- tcop
- utils
- adt
- cache
- bin
- initdb
- pg_dump
- psql
- include
- catalog
- commands
- executor
- nodes
- parser
- tcop
- utils
- pl
- plpgsql/src
- tcl
- test/regress
- expected
- output
- sql
Some content is hidden
Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.
103 files changed
+4240
-438
lines changedLines changed: 2 additions & 2 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
444 | 444 |
| |
445 | 445 |
| |
446 | 446 |
| |
447 |
| - | |
| 447 | + | |
448 | 448 |
| |
449 | 449 |
| |
450 | 450 |
| |
| |||
515 | 515 |
| |
516 | 516 |
| |
517 | 517 |
| |
518 |
| - | |
| 518 | + | |
519 | 519 |
| |
520 | 520 |
| |
521 | 521 |
| |
|
Lines changed: 1 addition & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
282 | 282 |
| |
283 | 283 |
| |
284 | 284 |
| |
285 |
| - | |
| 285 | + | |
286 | 286 |
| |
287 | 287 |
| |
288 | 288 |
| |
|
Lines changed: 2 additions & 2 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
525 | 525 |
| |
526 | 526 |
| |
527 | 527 |
| |
528 |
| - | |
529 |
| - | |
| 528 | + | |
| 529 | + | |
530 | 530 |
| |
531 | 531 |
| |
532 | 532 |
| |
|
Lines changed: 3 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
145 | 145 |
| |
146 | 146 |
| |
147 | 147 |
| |
| 148 | + | |
148 | 149 |
| |
149 | 150 |
| |
150 | 151 |
| |
| |||
323 | 324 |
| |
324 | 325 |
| |
325 | 326 |
| |
| 327 | + | |
326 | 328 |
| |
327 | 329 |
| |
328 | 330 |
| |
| |||
343 | 345 |
| |
344 | 346 |
| |
345 | 347 |
| |
| 348 | + | |
346 | 349 |
| |
347 | 350 |
| |
348 | 351 |
| |
|
Lines changed: 1 addition & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
216 | 216 |
| |
217 | 217 |
| |
218 | 218 |
| |
| 219 | + | |
219 | 220 |
| |
220 | 221 |
| |
221 | 222 |
| |
|
Lines changed: 1 addition & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
209 | 209 |
| |
210 | 210 |
| |
211 | 211 |
| |
212 |
| - | |
| 212 | + | |
213 | 213 |
| |
214 | 214 |
| |
215 | 215 |
| |
|
Lines changed: 5 additions & 4 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1597 | 1597 |
| |
1598 | 1598 |
| |
1599 | 1599 |
| |
1600 |
| - | |
1601 |
| - | |
| 1600 | + | |
| 1601 | + | |
1602 | 1602 |
| |
1603 | 1603 |
| |
1604 | 1604 |
| |
| |||
1789 | 1789 |
| |
1790 | 1790 |
| |
1791 | 1791 |
| |
1792 |
| - | |
1793 |
| - | |
| 1792 | + | |
| 1793 | + | |
| 1794 | + | |
1794 | 1795 |
| |
1795 | 1796 |
| |
1796 | 1797 |
| |
|
Lines changed: 16 additions & 7 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
13743 | 13743 |
| |
13744 | 13744 |
| |
13745 | 13745 |
| |
| 13746 | + | |
| 13747 | + | |
| 13748 | + | |
| 13749 | + | |
13746 | 13750 |
| |
13747 | 13751 |
| |
13748 | 13752 |
| |
| |||
13867 | 13871 |
| |
13868 | 13872 |
| |
13869 | 13873 |
| |
13870 |
| - | |
| 13874 | + | |
13871 | 13875 |
| |
13872 | 13876 |
| |
13873 | 13877 |
| |
13874 | 13878 |
| |
13875 |
| - | |
| 13879 | + | |
13876 | 13880 |
| |
13877 | 13881 |
| |
13878 | 13882 |
| |
13879 | 13883 |
| |
13880 |
| - | |
| 13884 | + | |
13881 | 13885 |
| |
13882 | 13886 |
| |
13883 | 13887 |
| |
13884 | 13888 |
| |
13885 |
| - | |
| 13889 | + | |
13886 | 13890 |
| |
13887 | 13891 |
| |
13888 | 13892 |
| |
13889 | 13893 |
| |
13890 |
| - | |
13891 |
| - | |
13892 |
| - | |
| 13894 | + | |
| 13895 | + | |
| 13896 | + | |
13893 | 13897 |
| |
13894 | 13898 |
| |
13895 | 13899 |
| |
| |||
13906 | 13910 |
| |
13907 | 13911 |
| |
13908 | 13912 |
| |
| 13913 | + | |
| 13914 | + | |
| 13915 | + | |
| 13916 | + | |
| 13917 | + | |
13909 | 13918 |
| |
13910 | 13919 |
| |
13911 | 13920 |
| |
|
Lines changed: 4 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
21 | 21 |
| |
22 | 22 |
| |
23 | 23 |
| |
| 24 | + | |
24 | 25 |
| |
25 | 26 |
| |
26 | 27 |
| |
| |||
63 | 64 |
| |
64 | 65 |
| |
65 | 66 |
| |
| 67 | + | |
66 | 68 |
| |
67 | 69 |
| |
68 | 70 |
| |
| |||
102 | 104 |
| |
103 | 105 |
| |
104 | 106 |
| |
| 107 | + | |
105 | 108 |
| |
106 | 109 |
| |
107 | 110 |
| |
| |||
136 | 139 |
| |
137 | 140 |
| |
138 | 141 |
| |
| 142 | + | |
139 | 143 |
| |
140 | 144 |
| |
141 | 145 |
| |
|
Lines changed: 1 addition & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
39 | 39 |
| |
40 | 40 |
| |
41 | 41 |
| |
| 42 | + | |
42 | 43 |
| |
43 | 44 |
| |
44 | 45 |
| |
|
Lines changed: 167 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
| 1 | + | |
| 2 | + | |
| 3 | + | |
| 4 | + | |
| 5 | + | |
| 6 | + | |
| 7 | + | |
| 8 | + | |
| 9 | + | |
| 10 | + | |
| 11 | + | |
| 12 | + | |
| 13 | + | |
| 14 | + | |
| 15 | + | |
| 16 | + | |
| 17 | + | |
| 18 | + | |
| 19 | + | |
| 20 | + | |
| 21 | + | |
| 22 | + | |
| 23 | + | |
| 24 | + | |
| 25 | + | |
| 26 | + | |
| 27 | + | |
| 28 | + | |
| 29 | + | |
| 30 | + | |
| 31 | + | |
| 32 | + | |
| 33 | + | |
| 34 | + | |
| 35 | + | |
| 36 | + | |
| 37 | + | |
| 38 | + | |
| 39 | + | |
| 40 | + | |
| 41 | + | |
| 42 | + | |
| 43 | + | |
| 44 | + | |
| 45 | + | |
| 46 | + | |
| 47 | + | |
| 48 | + | |
| 49 | + | |
| 50 | + | |
| 51 | + | |
| 52 | + | |
| 53 | + | |
| 54 | + | |
| 55 | + | |
| 56 | + | |
| 57 | + | |
| 58 | + | |
| 59 | + | |
| 60 | + | |
| 61 | + | |
| 62 | + | |
| 63 | + | |
| 64 | + | |
| 65 | + | |
| 66 | + | |
| 67 | + | |
| 68 | + | |
| 69 | + | |
| 70 | + | |
| 71 | + | |
| 72 | + | |
| 73 | + | |
| 74 | + | |
| 75 | + | |
| 76 | + | |
| 77 | + | |
| 78 | + | |
| 79 | + | |
| 80 | + | |
| 81 | + | |
| 82 | + | |
| 83 | + | |
| 84 | + | |
| 85 | + | |
| 86 | + | |
| 87 | + | |
| 88 | + | |
| 89 | + | |
| 90 | + | |
| 91 | + | |
| 92 | + | |
| 93 | + | |
| 94 | + | |
| 95 | + | |
| 96 | + | |
| 97 | + | |
| 98 | + | |
| 99 | + | |
| 100 | + | |
| 101 | + | |
| 102 | + | |
| 103 | + | |
| 104 | + | |
| 105 | + | |
| 106 | + | |
| 107 | + | |
| 108 | + | |
| 109 | + | |
| 110 | + | |
| 111 | + | |
| 112 | + | |
| 113 | + | |
| 114 | + | |
| 115 | + | |
| 116 | + | |
| 117 | + | |
| 118 | + | |
| 119 | + | |
| 120 | + | |
| 121 | + | |
| 122 | + | |
| 123 | + | |
| 124 | + | |
| 125 | + | |
| 126 | + | |
| 127 | + | |
| 128 | + | |
| 129 | + | |
| 130 | + | |
| 131 | + | |
| 132 | + | |
| 133 | + | |
| 134 | + | |
| 135 | + | |
| 136 | + | |
| 137 | + | |
| 138 | + | |
| 139 | + | |
| 140 | + | |
| 141 | + | |
| 142 | + | |
| 143 | + | |
| 144 | + | |
| 145 | + | |
| 146 | + | |
| 147 | + | |
| 148 | + | |
| 149 | + | |
| 150 | + | |
| 151 | + | |
| 152 | + | |
| 153 | + | |
| 154 | + | |
| 155 | + | |
| 156 | + | |
| 157 | + | |
| 158 | + | |
| 159 | + | |
| 160 | + | |
| 161 | + | |
| 162 | + | |
| 163 | + | |
| 164 | + | |
| 165 | + | |
| 166 | + | |
| 167 | + |
Lines changed: 2 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
38 | 38 |
| |
39 | 39 |
| |
40 | 40 |
| |
| 41 | + | |
41 | 42 |
| |
42 | 43 |
| |
43 | 44 |
| |
| |||
279 | 280 |
| |
280 | 281 |
| |
281 | 282 |
| |
| 283 | + | |
282 | 284 |
| |
283 | 285 |
| |
284 | 286 |
| |
|
Lines changed: 2 additions & 2 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
33 | 33 |
| |
34 | 34 |
| |
35 | 35 |
| |
36 |
| - | |
37 |
| - | |
| 36 | + | |
| 37 | + | |
38 | 38 |
| |
39 | 39 |
| |
40 | 40 |
| |
|
0 commit comments
Comments
(0)