Eric Hiller wrote:
I read up a bit about this command and it seems that while it is running
the database is unusable. About how long did this take for you when you
ran it?
Under VACUUM FULL, it's very slow. But I don't know that it's unusable.
I don't have what you would call a lot but it took maybe 10 minutes. I have a
relatively slow system.
But since FULL locks the table, it will have an effect. You might have to take
dbmail down while you do the largest tables. But I would start with a VACUUM
ANALYZE and make certain that the autovacuum process is running.
Only after that would I consider going to a VACUUM FULL. It will probably
require a short system outage to do the message related tables but not the users
or other smaller tables.
