Re: 7.3.3 drop table takes very long time

Tom Lane wrote:

>"Eric Freeman" <ejf7@hotmail.com> writes:
>
>
>>I started the drop table command yesterday and it's been running for almost
>>24 hours.
>>
>>
>
>You're stuck in some kind of infinite loop --- there's no way that DROP
>should take any noticeable amount of time.  I'm guessing that the system
>catalog entries for this particular table are corrupted somehow, but no
>idea just how.  It would be worth trying to track it down in case there
>is a PG bug lurking.
>
>Can you attach to the looping backend with a debugger and get a stack
>trace for us?
>
>
Is there any possibility that he's got an open transacation sitting out
there for days holding a lock on that table?

Mike Mascari