James Robinson <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org