Slide 69
Slide 69 text
69/147
2015
Auto / Manual Clean Dead Node
《 Sentry 的災難與慘痛經驗 》
The internet is full of awful advice of users suggesting you
should turn off autovacuum, or run it manually at low traffic
times, or simply adjust its schedule to run less often. To know
why that’s ill-advised, you first need to understand the
consequences of autovacuum not running.
網路上很多人建議關閉 AUTOVACUUM ,改以排程或手動
選擇負載低的期間執行 VACUUM 。但這是不明智的,你只
要知道不運行 AUTOVACUUM 會帶來的各種嚴重後果就會
明白了。
Ref: http://blog.getsentry.com/2015/07/23/transaction-id-wraparound-in-postgres.html