On Fri, Dec 2, 2011 at 8:32 PM, Ernesto Quiñones <ernestoq@gmail.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?