On Wed, Nov 18, 2020 at 10:45 AM Ron <ronljohnso...@gmail.com> wrote:
> 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> 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. > I can only agree with this comment. The main issue I see is the available disk space, as the partitioning process will include copying the whole table. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Libre de virus. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>