- Notifications
You must be signed in to change notification settings - Fork5
Commit7cce39c
committed
The following patch should allow UPDATE_INTERVAL to be specified on the
command line. We find this useful because we frequently deal withthousands of tables in an environment where neither the databases northe tables are updated frequently. This helps allow us to cut down onthe overhead of updating the list for every other primary loop ofpg_autovacuum.I chose -i as the command-line argument and documented it briefly inthe README.The patch was applied to the 7.4.7 version of pg_autovacuum in contrib.Thomas F.O'Connell1 parentaa8bdab commit7cce39c
File tree
3 files changed
+18
-6
lines changed- contrib/pg_autovacuum
3 files changed
+18
-6
lines changedLines changed: 5 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
123 | 123 |
| |
124 | 124 |
| |
125 | 125 |
| |
| 126 | + | |
| 127 | + | |
| 128 | + | |
| 129 | + | |
126 | 130 |
| |
127 | 131 |
| |
128 | 132 |
| |
| |||
157 | 161 |
| |
158 | 162 |
| |
159 | 163 |
| |
| 164 | + | |
160 | 165 |
| |
161 | 166 |
| |
162 | 167 |
| |
|
Lines changed: 11 additions & 5 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
4 | 4 |
| |
5 | 5 |
| |
6 | 6 |
| |
7 |
| - | |
| 7 | + | |
8 | 8 |
| |
9 | 9 |
| |
10 | 10 |
| |
| |||
1103 | 1103 |
| |
1104 | 1104 |
| |
1105 | 1105 |
| |
| 1106 | + | |
1106 | 1107 |
| |
1107 | 1108 |
| |
1108 | 1109 |
| |
| |||
1157 | 1158 |
| |
1158 | 1159 |
| |
1159 | 1160 |
| |
| 1161 | + | |
| 1162 | + | |
| 1163 | + | |
1160 | 1164 |
| |
1161 | 1165 |
| |
1162 | 1166 |
| |
| |||
1341 | 1345 |
| |
1342 | 1346 |
| |
1343 | 1347 |
| |
| 1348 | + | |
| 1349 | + | |
1344 | 1350 |
| |
1345 | 1351 |
| |
1346 | 1352 |
| |
| |||
1646 | 1652 |
| |
1647 | 1653 |
| |
1648 | 1654 |
| |
1649 |
| - | |
1650 |
| - | |
| 1655 | + | |
| 1656 | + | |
1651 | 1657 |
| |
1652 | 1658 |
| |
1653 | 1659 |
| |
| |||
1661 | 1667 |
| |
1662 | 1668 |
| |
1663 | 1669 |
| |
1664 |
| - | |
1665 |
| - | |
| 1670 | + | |
| 1671 | + | |
1666 | 1672 |
| |
1667 | 1673 |
| |
1668 | 1674 |
| |
|
Lines changed: 2 additions & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
2 | 2 |
| |
3 | 3 |
| |
4 | 4 |
| |
5 |
| - | |
| 5 | + | |
6 | 6 |
| |
7 | 7 |
| |
8 | 8 |
| |
| |||
44 | 44 |
| |
45 | 45 |
| |
46 | 46 |
| |
| 47 | + | |
47 | 48 |
| |
48 | 49 |
| |
49 | 50 |
| |
|
0 commit comments
Comments
(0)