vacuum vs vacuum full

From: Atul Kumar <akumar14871(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: vacuum vs vacuum full
Date: 2020-11-18 08:33:44
Message-ID: CA+ONtZ5QFB7yc110XdE_d8=7z7HXB_DiNbJ39sz8nf3uUPMcTw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?
2. Do we need to perform Analyze also?
3. Will the operation be completed in the given time frame? how to
check the same.
4. Who acquire lock on table vacuum or vacuum full.
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.

Regards,
Atul

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim Gündüz 2020-11-18 09:20:39 Re: Postgresql13-devel fails to install on centos 7
Previous Message Hemil Ruparel 2020-11-18 08:15:02 Re: Postgresql13-devel fails to install on centos 7