- Notifications
You must be signed in to change notification settings - Fork5
Commit5254958
committed
Add CREATE TABLESPACE ... WITH ... Options
Tablespaces have a few options which can be set on them to give PG hintsas to how the tablespace behaves (perhaps it's faster for sequentialscans, or better able to handle random access, etc). These options wereonly available through the ALTER TABLESPACE command.This adds the ability to set these options at CREATE TABLESPACE time,removing the need to do both a CREATE TABLESPACE and ALTER TABLESPACE toget the correct options set on the tablespace.Vik Fearing, reviewed by Michael Paquier.1 parent115f414 commit5254958
File tree
8 files changed
+61
-3
lines changed- doc/src/sgml/ref
- src
- backend
- commands
- nodes
- parser
- include/nodes
- test/regress
- input
- output
8 files changed
+61
-3
lines changedLines changed: 22 additions & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
21 | 21 |
| |
22 | 22 |
| |
23 | 23 |
| |
24 |
| - | |
| 24 | + | |
| 25 | + | |
| 26 | + | |
| 27 | + | |
25 | 28 |
| |
26 | 29 |
| |
27 | 30 |
| |
| |||
87 | 90 |
| |
88 | 91 |
| |
89 | 92 |
| |
| 93 | + | |
| 94 | + | |
| 95 | + | |
| 96 | + | |
| 97 | + | |
| 98 | + | |
| 99 | + | |
| 100 | + | |
| 101 | + | |
| 102 | + | |
| 103 | + | |
| 104 | + | |
| 105 | + | |
| 106 | + | |
| 107 | + | |
| 108 | + | |
| 109 | + | |
| 110 | + | |
90 | 111 |
| |
91 | 112 |
| |
92 | 113 |
| |
|
Lines changed: 11 additions & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
239 | 239 |
| |
240 | 240 |
| |
241 | 241 |
| |
| 242 | + | |
242 | 243 |
| |
243 | 244 |
| |
244 | 245 |
| |
| |||
322 | 323 |
| |
323 | 324 |
| |
324 | 325 |
| |
325 |
| - | |
| 326 | + | |
| 327 | + | |
| 328 | + | |
| 329 | + | |
| 330 | + | |
| 331 | + | |
| 332 | + | |
| 333 | + | |
| 334 | + | |
| 335 | + | |
326 | 336 |
| |
327 | 337 |
| |
328 | 338 |
| |
|
Lines changed: 1 addition & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
3370 | 3370 |
| |
3371 | 3371 |
| |
3372 | 3372 |
| |
| 3373 | + | |
3373 | 3374 |
| |
3374 | 3375 |
| |
3375 | 3376 |
| |
|
Lines changed: 1 addition & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1610 | 1610 |
| |
1611 | 1611 |
| |
1612 | 1612 |
| |
| 1613 | + | |
1613 | 1614 |
| |
1614 | 1615 |
| |
1615 | 1616 |
| |
|
Lines changed: 2 additions & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
3588 | 3588 |
| |
3589 | 3589 |
| |
3590 | 3590 |
| |
3591 |
| - | |
| 3591 | + | |
3592 | 3592 |
| |
3593 | 3593 |
| |
3594 | 3594 |
| |
3595 | 3595 |
| |
3596 | 3596 |
| |
| 3597 | + | |
3597 | 3598 |
| |
3598 | 3599 |
| |
3599 | 3600 |
| |
|
Lines changed: 1 addition & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1669 | 1669 |
| |
1670 | 1670 |
| |
1671 | 1671 |
| |
| 1672 | + | |
1672 | 1673 |
| |
1673 | 1674 |
| |
1674 | 1675 |
| |
|
Lines changed: 10 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
| 1 | + | |
| 2 | + | |
| 3 | + | |
| 4 | + | |
| 5 | + | |
| 6 | + | |
| 7 | + | |
| 8 | + | |
| 9 | + | |
| 10 | + | |
1 | 11 |
| |
2 | 12 |
| |
3 | 13 |
| |
|
Lines changed: 13 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 | + | |
1 | 14 |
| |
2 | 15 |
| |
3 | 16 |
| |
|
0 commit comments
Comments
(0)