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.