14.03.2018 | Laurenz AlbeFour reasons why VACUUM won’t remove dead rows from a table
Why vacuum? Post UPDATED 12.07.2022: Whenever rows in a PostgreSQL table are updated or deleted, dead rows are left behind. VACUUM gets rid of them so that the space can be reused. If a table doesn’t get vacuumed, it will get bloated, which wastes disk space and slows down sequential table scans (and – to […]
Read more