Search Postgresql Archives

Re: vacuum vs vacuum full

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Wed, Nov 18, 2020 at 10:45 AM Ron <ronljohnsonjr@xxxxxxxxx> wrote:
On 11/18/20 3:41 AM, Olivier Gautherot wrote:
Hi Atul,

On Wed, Nov 18, 2020 at 9:33 AM Atul Kumar <akumar14871@xxxxxxxxx> 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. 

Libre de virus. www.avast.com

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux