New answers tagged vacuum
VACUUM can only remove dead tuples which are long-dead, that is, dead to all possible uses. If you have long-lived transactions, they may prevent the recently-dead tuples from being removed. This is an example of a situation where a long-lived transaction prevented removal: INFO: "pgbench_accounts": found 0 removable, 2999042 nonremovable row versions in ...
Top 50 recent answers are included