That was it. There were two in there. I rolled 'em back and everything is smooth now. Thanks a lot.
Jess -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Monday, December 19, 2005 10:03 PM To: Jess Balint Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Lock issue when trying to vacuum db "Jess Balint" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
