Re: 7.3.3 drop table takes very long time

On Thursday 08 January 2004 9:14 am, Mike Mascari wrote:
> 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

Yesterday I had someone drop a table while a pg_dumpall was running.
The drop didn't complete till the dump was done.

Cheers,
Steve