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

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

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

2005-12-19 Thread Tom Lane
"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 qu

[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