public inbox for [email protected]
help / color / mirror / Atom feedFrom: Rui DeSousa <[email protected]>
To: Ron Johnson <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Pg_repack
Date: Mon, 12 Aug 2024 13:55:47 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CANzqJaByQvYhDELeO3n63VPPWenFdOm03qt2g_Ev4qsXCb7dYw@mail.gmail.com>
References: <CA+M9Y+B03KvHX2qUfvepv6_u72V7b-_zR_=SnMueBrG5xQ34Jw@mail.gmail.com>
<[email protected]>
<CANzqJaByQvYhDELeO3n63VPPWenFdOm03qt2g_Ev4qsXCb7dYw@mail.gmail.com>
> On Aug 12, 2024, at 12:06 PM, Ron Johnson <[email protected]> wrote:
>
> But pg_repack is just a better VACUUM FULL, and VACUUM FULL has to be better than autovacuum because it fully vacuums a table.
>
No.
Vacuum — actually vacuums by removing dead tuples that are no longer needed, freezing tuples, etc. The removal of dead tuples frees space on the given page and it also truncates the fully empty pages that are located at the end of the file if it can.
Vacuum FULL — is something completely different. It rebuilds the entire table thus it coalesces all free space and by proxy does the same as vacuum (removing dead tuples that are no longer needed).
— It does this by creating a new table and then swapping in the new table when; regardless of the number of dead tuples.
Vacuum FULL should not be run on a regular basis.
view thread (14+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Pg_repack
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox