Postgres Pro
Downloads
Home   >   mailing lists

Re: Maintenance - Mailing list pgsql-admin

From Wasim Devale
Subject Re: Maintenance
Date
Msg-id CAB5fag6e3gqnO6rtBByF5Aa3x28Af1e=zQq+fOmag0WChCrUww@mail.gmail.com
Whole thread Raw
In response to Re: Maintenance  (vrms <vrms@netcologne.de>)
Responses Maintenance
List pgsql-admin
Tree view
vrms you are correct.

On Wed, 8 May, 2024, 7:59 pm vrms, <vrms@netcologne.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

pgsql-admin by date:

Previous
From: vrms
Date:
Subject: Re: Maintenance
Next
From: "Wetmore, Matthew (CTR)"
Date:
Subject: Maintenance