3 ms·
> Postgres don't actually delete data until you a VACUUM occurs. FWIW, a large portion of cleanup happens on access. If the entire page will not be accessed un
by anarazel 9y ago
> Postgres don't actually delete data until you a VACUUM occurs.
FWIW, a large portion of cleanup happens on access. If the entire page will not be accessed until the next VACUUM that doesn't change anything, but in OLTP workloads that space will often be reclaimed much earlier.
Doesn't change anything about your larger point though.