Re: autovac hung/blocked

On Tue, Nov 14, 2006 at 11:20:30AM -0700, Ed L. wrote:
> I have an 8.1.2 autovac which appears to be hanging/blocking
> every few days or so, but we're don't understand what's causing
> it.  I wasn't able to catch a backtrace before we killed it.  I
> do not see autovac locks in the pg_locks view.
>
> Will running 8.1.5 buy me anything in terms of being able to see
> what it has locked and what locks it might be awaiting?  Or
> maybe in terms of bugs that might explain it?

If there's no locks, why do you think it's blocked?
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)