Content-Type: multipart/alternative;
 boundary="------------Y8j0dL5YFB6LE8gI40aMy5k0"
Message-ID: <2323019d-ba9b-4eba-86e8-84b030bdd94a@netcologne.de>
Date: Wed, 8 May 2024 16:28:55 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Maintenance
To: pgsql-admin@lists.postgresql.org
References: 
 <CAEQOu1Fu2i7EoimtG_T4FQkuN5z3L5pY6n4jHHk=xB+NWZMfMw@mail.gmail.com>
 <8f36cff9-78aa-4e72-ab22-093a889a926d@gmx.net>
 <CANzqJaBf=f_CLxJO8MqN45z+KTY1i6hiF3Zt1mNX6Pmz66-JdQ@mail.gmail.com>
Content-Language: en-US
From: vrms <vrms@netcologne.de>
In-Reply-To: 
 <CANzqJaBf=f_CLxJO8MqN45z+KTY1i6hiF3Zt1mNX6Pmz66-JdQ@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/2323019d-ba9b-4eba-86e8-84b030bdd94a%40netcologne.de>
Precedence: bulk

This is a multi-part message in MIME format.
--------------Y8j0dL5YFB6LE8gI40aMy5k0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit


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
--------------Y8j0dL5YFB6LE8gI40aMy5k0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <br>
    On 5/8/24 3:10 PM, Ron Johnson wrote:
    <div class="moz-cite-prefix"> <br>
      <div>&gt; Don't dead tuples have to be vacuumed away before the
        space can be reused?</div>
    </div>
    <div class="gmail_quote">
      <div><br>
        I think that is correct. As per my understanding ...<br>
        <br>
        VACUUM<br>
        <br>
           - removes dead tuples and makes the consumed space available
        for future data<br>
           - does not free disk space<br>
           - does not cause any locks<br>
        <br>
        VACUUM FULL<br>
        <br>
           - removes dead tuples and frees actual disk space<br>
           - causes locks on the table being VACUUMed<br>
      </div>
    </div>
  </body>
</html>

--------------Y8j0dL5YFB6LE8gI40aMy5k0--