Lonni J Friedman <netllama(at)gmail(dot)com> writes:
> I've got an 8.1.10 instance running on Linux-i686. The system hosts 5
> databases, all of which get vacuumed via a cronjob 3 times a day. All
> of a sudden, the vacuum job for 1 of the databases is hanging
> indefinitely.
Is it actually blocked, or just busy? (strace'ing the vacuum process
would be one pretty definitive way of telling.)
8.1.10 is mighty old, so frankly I'd suggest an update to 8.1.recent
before you expend a whole lot of effort tracing the problem.
regards, tom lane