On 11/18/20 3:41 AM, Olivier Gautherot wrote:
Hi Atul,

On Wed, Nov 18, 2020 at 9:33 AM Atul Kumar <akumar14...@gmail.com <mailto:akumar14...@gmail.com>> 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:

[snip]

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


Given the size of the table, it will probably take several days.

No matter how long it takes, this is an excellent argument for partitioning Very Large Tables: many maintenance tasks are made *much* easier.



--
Angular momentum makes the world go 'round.

Reply via email to