Re: Help: 8.0.3 Vacuum of an empty table never completes ...

James Robinson <jlrobins@socialserve.com> writes:
> Comparing the logs further with when it did complete, it seems that  
> one table in particular (at least) seems afflicted:

> social=# vacuum verbose analyze agency.swlog_client;

> hangs up forever -- have to control-c the client. Likewise for w/o  
> 'analyze'.

Given that it's not eating CPU time, one would guess that it's blocked
waiting for a lock.  Can you find any relevant locks in pg_locks?
        regards, tom lane