vrms you are correct.
On Wed, 8 May, 2024, 7:59 pm vrms, <vrms(at)netcologne(dot)de> wrote:
>
> 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
>