Re: vacuum vs vacuum full

On 11/18/20 2:33 AM, Atul Kumar wrote:
> Hi,
>
> We have a table of 3113GB, and we are planning to vacuum it in non
> business hours i.e. 12AM to 4AM, So my queries are:
>
> 1. What should be perform on the table Vacuum or Vacuum full ?

The documentation *clearly states* the difference between VACUUM and VACUUM
FULL.

https://www.postgresql.org/docs/9.6/sql-vacuum.html

> 2. Do we need to perform Analyze also?

I always do.

> 3. Will the operation be completed in the given time frame? how to
> check the same.

How in the heck do we know your system's hardware configuration?

> 4. Who acquire lock on table vacuum or vacuum full.

Read the docs.

> 5. If the activity goes beyond time frame, do we have any option to do
> continue doing t without acquiring lock on the table ?
>
> If you also need the structure of the table, Please let me know.
>
> Please help me by responding my query wise.

--
Angular momentum makes the world go 'round.