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 [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
