Re: [HACKERS] Lock issue when trying to vacuum db

2005-12-19 Thread Jess Balint
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]

[HACKERS] Lock issue when trying to vacuum db

2005-12-19 Thread Jess Balint
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. The results a