Why VACUUM?Whenever rows in a PostgreSQL table are updated or deleted, dead rows are left behind. VACUUM gets rid of them so that the space…
View More Vacuum problems solving
Tag: vacuum
AutoVacuum in PostgreSQL-7
We’ve already mentioned that normally (i. e., when nothing holds the transaction horizon for a long time) VACUUM usually does its job. The problem is how…
View More AutoVacuum in PostgreSQL-7
Vacuum in postgreSQL-6
What does vacuum do? In-page vacuum works fast, but frees only part of the space. It works within one table page and does not touch…
View More Vacuum in postgreSQL-6