Re: Vacuum full hang => strace

"Gaetano Mendola" <mendola@bigfoot.com> writes:
> gettimeofday({1044264831, 559402}, NULL) = 0
> setitimer(ITIMER_REAL, {it_interval={0, 0}, it_value={1, 0}},
> {it_interval={0, 0}, it_value={0, 0}}) = 0
> semop(21037068, 0xbfffed00, 1)          = -1 EINTR (Interrupted system call)
> --- SIGALRM (Alarm clock) ---
> sigreturn()                             = ? (mask now [])
> semop(21037068, 0xbfffed00, 1

> that's all, after this remain there for ever.

Looks like my guess was right: it's waiting for some other process to
release a lock.  Check for open transactions that have accessed the
table in question.

            regards, tom lane