Re: Maintenance

From: vrms <vrms(at)netcologne(dot)de>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Maintenance
Date: 2024-05-08 14:28:55
Message-ID: 2323019d-ba9b-4eba-86e8-84b030bdd94a@netcologne.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wasim Devale 2024-05-08 14:31:26 Re: Maintenance
Previous Message Ron Johnson 2024-05-08 13:10:34 Re: Maintenance