## pramod gupta ([email protected]): > How was VACUUM ANALYZE able to reclaim such a large amount of space, > especially for TOAST data? > > Under what conditions does PostgreSQL reclaim disk space without requiring > VACUUM FULL or CLUSTER?
https://www.postgresql.org/docs/current/routine-vacuuming.html#VACUUM-FOR-SPACE-RECOVERY "in the special case where one or more pages at the end of a table become entirely free and an exclusive table lock can be easily obtained" Regards, Christoph -- Spare Space
