Re: Question about VACUUM

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Ernesto Quiñones <ernestoq(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Question about VACUUM
Date: 2011-12-03 03:42:12
Message-ID: CAOR=d=0Fqhg_-W7cUc+OFaab7ajyyoO+o6hR88=dNndQqpvdKA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Dec 2, 2011 at 8:32 PM, Ernesto Quiñones <ernestoq(at)gmail(dot)com> wrote:
> Hi friends
>
> I want to know if it's possible to predict (calculate), how long a
> VACUUM FULL process will consume in a table?
>
> can I apply some formula to calculate this?

If you look at what iostat is doing while the vacuum full is running,
and divide the size of the table by that k/sec you can get a good
approximation of how long it will take. Do you have naptime set to
anything above 0?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tory M Blue 2011-12-03 04:09:25 pg_upgrade
Previous Message Ernesto Quiñones 2011-12-03 03:32:01 Question about VACUUM