Re: After how many updates should a vacuum be performed?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ellen Cyran <ellen(at)urban(dot)csuohio(dot)edu>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: After how many updates should a vacuum be performed?
Date: 2006-09-14 14:11:43
Message-ID: 28843.1158243103@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ellen Cyran <ellen(at)urban(dot)csuohio(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jeanna Geier 2006-09-14 14:17:00 Beginning SSL Questions
Previous Message Ellen Cyran 2006-09-14 13:17:30 Re: After how many updates should a vacuum be performed?