On 5/8/24 3:10 PM, Ron Johnson wrote:
> Don't dead tuples have to be vacuumed away before the space can be reused?
I think that is correct. As per my understanding ...
VACUUM
- removes dead tuples and makes the consumed space available for future data
- does not free disk space
- does not cause any locks
VACUUM FULL
- removes dead tuples and frees actual disk space
- causes locks on the table being VACUUMed