Ellen Cyran <ellen@xxxxxxxxxxxxxxxxx> writes: > Also, the vacuum of all the database only took 1 hour and 20 minutes so > is there anything I should look at the next time this happens besides i/o? I'm still wondering about locks. If the VACUUM seems to be just sitting and not doing I/O, look in the pg_locks view to see if it's blocked on a lock. regards, tom lane
