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@xxxxxxxxx>: > On Fri, Dec 2, 2011 at 8:32 PM, Ernesto Quiñones <ernestoq@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
