Re: vacuum vs vacuum full

On Wed, Nov 18, 2020 at 1:33 AM Atul Kumar <akumar14871(at)gmail(dot)com> wrote:

> Hi,
>
> We have a table of 3113GB, and we are planning to vacuum it in non
>

Just making sure that isn't a typo (repeated 1s)...

business hours i.e. 12AM to 4AM, So my queries are:
>
> 1. What should be perform on the table Vacuum or Vacuum full ?
>

You should be vacuuming that table constantly, so why is the particular
vacuum special? What are the "last vacuum" related statistics for this
table?

There is "vacuum" and there is "rebuilding the whole table from scratch",
the later of which is unfortunately named "vacuum full".

If you haven't started learning/thinking about it yet you should try and
get an understanding around where your system is in the process of
requiring an anti-wraparound vacuum. Or, more generally, using "vacuum
freeze".

David J.