Re: 7.4b4 undetected deadlock? - Mailing list pgsql-bugs

Robert Creager <Robert_Creager@LogicalChaos.org> writes:
> postgres 29304 20209  0 17:37 pts/4    00:00:00 postgres: robert tassiv 192.168.0.250 idle in transaction
       

Almost certainly, that guy is holding the lock REINDEX wants.  The
VACUUM is probably backed up behind the REINDEX.  If you want to
convince me it's a deadlock, you'll need to exhibit pg_locks contents.

            regards, tom lane