|
|
|
|
|
|
by pritambaral
3031 days ago
|
|
|
> Vacuum helps with deletes but updates create new rows and vacuum never cleans up the old ones. Only if there are long running transactions older than the updates themselves. When no old transactions are left, vacuum reclaims old tuples. If you're talking about vacuum being unable to reclaim pages that still have some live tuples, that problem affects deletes and updates equally. |
|
|