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