Postgres Pro
Downloads
Home   >   mailing lists

Re: After how many updates should a vacuum be performed? - Mailing list pgsql-admin

From Tom Lane
Subject Re: After how many updates should a vacuum be performed?
Date
Msg-id 28843.1158243103@sss.pgh.pa.us
Whole thread Raw
In response to Re: After how many updates should a vacuum be performed?  (Ellen Cyran <ellen@urban.csuohio.edu>)
List pgsql-admin
Tree view 
Ellen Cyran <ellen@urban.csuohio.edu> 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

pgsql-admin by date:

Previous
From: Volkan YAZICI
Date:
Subject: Re: Time triggered events
Next
From: "Jeanna Geier"
Date:
Subject: Beginning SSL Questions