Thanks for the answer Scott, actually my autovacuum_naptime is 1h ..
but I don't find naptime parameter for a manual vacuum
thanks again
2011/12/2 Scott Marlowe <scott.marlowe@gmail.com>:
> 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?
--
----------------------------------------------------------
Visita : http://www.eqsoft.net
----------------------------------------------------------
Sigueme en Twitter : http://www.twitter.com/ernestoq