Postgres Pro
Downloads
Home   >   mailing lists

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 11970.1073582209@sss.pgh.pa.us
Whole thread Raw
In response to Re: 7.3.3 drop table takes very long time  (Mike Mascari <mascarm@mascari.com>)
List pgsql-general
Tree view 
Mike Mascari <mascarm@mascari.com> writes:
> Is there any possibility that he's got an open transacation sitting out
> there for days holding a lock on that table?

Good thought ... but if that was the issue then the DROP would just be
sleeping waiting for the lock, and Eric did say it was consuming CPU ...

            regards, tom lane

pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: 7.3.3 drop table takes very long time
Next
From: Travel Jadoo
Date:
Subject: Re: order by is ambiguous