Re: Lock issue when trying to vacuum db

"Jess Balint" <jbalint@gmail.com> writes:
> Hi, I have a database that had a large table in it. I dropped the table, but
> when I try to full vacuum the db, it just freezes indefinitely. There are
> shared locks held on this that I can't identify. I've tried bouncing this
> instance and ran some queries immediately after starting up.

AFAIK, the only way for a lock to survive a database restart is a
prepared transaction.  Are you running 8.1, and if so what does
pg_prepared_xacts show?
        regards, tom lane