Re: 7.3.3 drop table takes very long time - Mailing list pgsql-general

From Tom Lane
Subject Re: 7.3.3 drop table takes very long time
Date
Msg-id 11871.1073581548@sss.pgh.pa.us
Whole thread Raw
In response to 7.3.3 drop table takes very long time  ("Eric Freeman" <ejf7@hotmail.com>)
Responses Re: 7.3.3 drop table takes very long time
List pgsql-general
"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?

            regards, tom lane

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Queries taking a very long time
Next
From: Mike Mascari
Date:
Subject: Re: 7.3.3 drop table takes very long time