> Yikes. That's *way* too high. If you're trying to get the vacuum to complete quickly, it really should be zero anyway. Nonzero is for when you don't care how >> long vacuum takes as long as it's not sucking too much I/O from your real work.
Thanks Tom, yap you were right now it runs instantaneously by resetting vacuum back to defaults. I feel kind of dumb at this point :) I guess misunderstood the docs. Thanks again, Regina -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general