Re: 7.3.3 drop table takes very long time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mike Mascari <mascarm(at)mascari(dot)com>
Cc: Eric Freeman <ejf7(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: 7.3.3 drop table takes very long time
Date: 2004-01-08 17:16:49
Message-ID: 11970.1073582209@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mike Mascari <mascarm(at)mascari(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Travel Jadoo 2004-01-08 17:20:51 Re: order by is ambiguous
Previous Message Mike Mascari 2004-01-08 17:14:21 Re: 7.3.3 drop table takes very long time