forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commit3ec8576
committed
Revert "Skip redundant anti-wraparound vacuums"
This reverts commit2aa6e33, that added a fast path to skipanti-wraparound and non-aggressive autovacuum jobs (these have no senseas anti-wraparound implies aggressive). With a cluster using a highamount of relations with a portion of them being heavily updated, thiscould cause autovacuum to lock down, with autovacuum workers attemptingrepeatedly those jobs on the same relations for the same database, thatjust kept being skipped. This lock down can be solved with a manualVACUUM FREEZE.Justin King has reported one environment where the issue happened, andJulien Rouhaud and I have been able to reproduce it in a secondenvironment. With a very aggressive autovacuum_freeze_max_age,triggering those jobs with pgbench is a matter of minutes, and hittingthe lock down is a lot harder (my local tests failed to do that).Note that anti-wraparound and non-aggressive jobs can only be triggeredon a subset of shared catalogs:- pg_auth_members- pg_authid- pg_database- pg_replication_origin- pg_shseclabel- pg_subscription- pg_tablespaceWhile the lock down was possible down to v12, the root cause of thosejobs is a much older issue, which needs more analysis.Bonus thanks to Andres Freund for the discussion.Reported-by: Justin KingDiscussion:https://postgr.es/m/CAE39h22zPLrkH17GrkDgAYL3kbjvySYD1io+rtnAUFnaJJVS4g@mail.gmail.comBackpatch-through: 121 parent97cda93 commit3ec8576
1 file changed
+4
-20
lines changedLines changed: 4 additions & 20 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
255 | 255 |
| |
256 | 256 |
| |
257 | 257 |
| |
258 |
| - | |
259 |
| - | |
260 |
| - | |
261 |
| - | |
262 |
| - | |
263 |
| - | |
264 |
| - | |
265 |
| - | |
266 |
| - | |
267 |
| - | |
268 |
| - | |
269 |
| - | |
270 |
| - | |
271 |
| - | |
272 |
| - | |
273 |
| - | |
274 |
| - | |
275 | 258 |
| |
276 | 259 |
| |
277 | 260 |
| |
| |||
400 | 383 |
| |
401 | 384 |
| |
402 | 385 |
| |
403 |
| - | |
404 |
| - | |
405 |
| - | |
| 386 | + | |
| 387 | + | |
| 388 | + | |
| 389 | + | |
406 | 390 |
| |
407 | 391 |
| |
408 | 392 |
| |
|
0 commit comments
Comments
(0)