forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commitac7a126
committed
Update entry:
< * Allow heap reuse of UPDATEd rows if old and new versions are on the< same heap page?> * Allow heap reuse of UPDATEd rows if no indexed columns are changed,> and old and new versions are on the same heap page?< This is possible for same-page updates because a single index row< can point to both old and new values.> While vacuum handles DELETEs fine, updating of non-indexed columns, like> counters, are difficult for VACUUM to handle efficiently. This method> is possible for same-page updates because a single index row can be> used to point to both old and new values.1 parentfc6a229 commitac7a126
2 files changed
+14
-10
lines changedLines changed: 7 additions & 5 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
2 | 2 |
| |
3 | 3 |
| |
4 | 4 |
| |
5 |
| - | |
| 5 | + | |
6 | 6 |
| |
7 | 7 |
| |
8 | 8 |
| |
| |||
1131 | 1131 |
| |
1132 | 1132 |
| |
1133 | 1133 |
| |
1134 |
| - | |
1135 |
| - | |
| 1134 | + | |
| 1135 | + | |
1136 | 1136 |
| |
1137 |
| - | |
1138 |
| - | |
| 1137 | + | |
| 1138 | + | |
| 1139 | + | |
| 1140 | + | |
1139 | 1141 |
| |
1140 | 1142 |
| |
1141 | 1143 |
| |
|
Lines changed: 7 additions & 5 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 |
| |
| |||
1020 | 1020 |
| |
1021 | 1021 |
| |
1022 | 1022 |
| |
1023 |
| - | |
1024 |
| - | |
1025 |
| - | |
1026 |
| - | |
| 1023 | + | |
| 1024 | + | |
| 1025 | + | |
| 1026 | + | |
| 1027 | + | |
| 1028 | + | |
1027 | 1029 |
| |
1028 | 1030 |
| |
1029 | 1031 |
| |
|
0 commit comments
Comments
(0)