Re: Lock issue when trying to vacuum db

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jess Balint" <jbalint(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Lock issue when trying to vacuum db
Date: 2005-12-20 03:03:29
Message-ID: 24291.1135047809@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Jess Balint" <jbalint(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Manuel Sugawara 2005-12-20 03:44:22 localization problem (and solution)
Previous Message Christopher Kings-Lynne 2005-12-20 02:09:52 Re: [pgadmin-hackers] Client-side password encryption