Re: How did VACUUM ANALYZE reclaim large TOAST bloat at disk level in PostgreSQL 16?

## pramod gupta (mail2sony2010@gmail.com):

> 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