Postgres Pro
Downloads
Home   >   mailing lists

Re: Lock issue when trying to vacuum db - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Lock issue when trying to vacuum db
Date
Msg-id 24291.1135047809@sss.pgh.pa.us
Whole thread Raw
In response to Lock issue when trying to vacuum db  ("Jess Balint" <jbalint@gmail.com>)
Responses Re: Lock issue when trying to vacuum db  ("Jess Balint" <jbalint@gmail.com>)
List pgsql-hackers
Tree view 
"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

pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: [pgadmin-hackers] Client-side password encryption
Next
From: Manuel Sugawara
Date:
Subject: localization problem (and solution)